导出到EXCEL之一：文件流
void GenExcel(string[] MyArray)
{
Random r = new Random();
int rnd = (int)(r.NextDouble() * 1000);
string FileName = "各负责单位办理历次会议任务情况一览表" + "_" + DateTime.Now.ToString("yyyy-MM-dd_HHmmss") + ".xls";
//string path = Server.MapPath("Files/") + FileName;
string path =Server.MapPath(Request.ApplicationPath)+FilesOperationUrl() + FileName;
//将制定类型的资料加载到FileOPeration页面当中
Model.FileInfo model = new Model.FileInfo();
model.FileName = FileName;
model.FileOwnerID = Session["uid"] != null ? Convert.ToInt32(Session["uid"]) : -1;
model.FileType = Convert.ToInt32(ddlFileType.SelectedValue);
model.FileUrl = FilesOperationUrl();
model.UpdateDate = DateTime.Now;
//修改成 不控制只有选择了类型后就把文件上传到服务器当中
new BLL.FileInfo().Add(model);
//File.Create(Server.MapPath(Request.ApplicationPath) + FilesOperationUrl() + FileName ));
string sql = "";
int count = 0;
for (int i = 0; i < MyArray.Length; i++)
{
sql = "select count(*) from ProjectTaskInfo where TaskID =" + MyArray[i];
count += Convert.ToInt32(DbHelperSQL.GetSingle(sql));
}
FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("<?xml version=\"1.0\"?>");
sw.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>");
sw.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"");
sw.WriteLine("xmlns:o=\"urn:schemas-microsoft-com:office:office\"");
sw.WriteLine("xmlns:x=\"urn:schemas-microsoft-com:office:excel\"");
sw.WriteLine("xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"");
sw.WriteLine("xmlns:html=\"http://www.w3.org/TR/REC-html40/">");
sw.WriteLine("<DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");
sw.WriteLine("<LastPrinted>2012-02-24T00:53:33Z</LastPrinted>");
sw.WriteLine("<Created>1996-12-17T01:32:42Z</Created>");
sw.WriteLine("<LastSaved>2012-03-01T07:37:46Z</LastSaved>");
sw.WriteLine("<Version>14.00</Version>");
sw.WriteLine("</DocumentProperties>");
sw.WriteLine("<OfficeDocumentSettings xmlns=\"urn:schemas-microsoft-com:office:office\">");
sw.WriteLine("<AllowPNG/>");
sw.WriteLine("<RemovePersonalInformation/>");
sw.WriteLine("</OfficeDocumentSettings>");
sw.WriteLine("<ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">");
sw.WriteLine("<WindowHeight>4536</WindowHeight>");
sw.WriteLine("<WindowWidth>8508</WindowWidth>");
sw.WriteLine("<WindowTopX>480</WindowTopX>");
sw.WriteLine("<WindowTopY>120</WindowTopY>");
sw.WriteLine("<ProtectStructure>False</ProtectStructure>");
sw.WriteLine("<ProtectWindows>False</ProtectWindows>");
sw.WriteLine("</ExcelWorkbook>");
sw.WriteLine("<Styles>");
sw.WriteLine(" <Style ss:ID=\"Default\" ss:Name=\"Normal\">");
sw.WriteLine("<Alignment ss:Vertical=\"Bottom\"/>");
sw.WriteLine("<Borders/>");
sw.WriteLine("<Font ss:FontName=\"宋体\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("<Interior/>");
sw.WriteLine("<NumberFormat/>");
sw.WriteLine("<Protection/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"m134745396\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"m134745416\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"m134745436\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"m134745456\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"m90713028\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s62\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s63\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s64\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\" ss:Bold=\"1\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s65\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"华文仿宋\" x:CharSet=\"134\" ss:Size=\"12\"/>");
sw.WriteLine("<NumberFormat ss:Format=\"@\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s66\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Left\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Right\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("<Border ss:Position=\"Top\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s67\">");
sw.WriteLine("<Alignment ss:Vertical=\"Bottom\" ss:WrapText=\"1\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("<Style ss:ID=\"s75\">");
sw.WriteLine("<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Center\" ss:WrapText=\"1\"/>");
sw.WriteLine("<Borders>");
sw.WriteLine("<Border ss:Position=\"Bottom\" ss:LineStyle=\"Continuous\" ss:Weight=\"1\"/>");
sw.WriteLine("</Borders>");
sw.WriteLine("<Font ss:FontName=\"宋体\" x:CharSet=\"134\" ss:Size=\"20\" ss:Bold=\"1\"/>");
sw.WriteLine("</Style>");
sw.WriteLine("</Styles>");
sw.WriteLine("<Worksheet ss:Name=\"各负责单位办理历次会议任务情况一览表\">");
sw.WriteLine("<Table ss:ExpandedColumnCount=\"11\" ss:ExpandedRowCount=\"" + (count + 3) + "\" x:FullColumns=\"1\"");
sw.WriteLine("x:FullRows=\"1\" ss:DefaultColumnWidth=\"52.8\"");
sw.WriteLine("ss:DefaultRowHeight=\"15.600000000000001\">");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"250\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"150\" />");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"150\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"300\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"200\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"120\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"120\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"100\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"200\"/>");
sw.WriteLine("<Column ss:AutoFitWidth=\"0\" ss:Width=\"200\"/>");
sw.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"40.949999999999996\">");
sw.WriteLine("<Cell ss:MergeAcross=\"9\" ss:StyleID=\"s75\"><Data ss:Type=\"String\">各责任单位办理历次会议任务情况一览表</Data></Cell>");
sw.WriteLine("</Row>");
sw.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">责任单位</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">任务单号</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">督办单号</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s62\"><Data ss:Type=\"String\">任务内容</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s62\"><Data ss:Type=\"String\">督办内容</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">任务标题</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s62\"><Data ss:Type=\"String\">责任人</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">初次下达时间</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">要求完成时间</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">完成情况</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">工作进展</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s64\"><Data ss:Type=\"String\">会议协调意见</Data></Cell>");
sw.WriteLine("</Row>");
for (int i = 0; i < MyArray.Length; i++)
{
List<Model.ProjectTaskInfo> list = new BLL.ProjectTaskInfo().GetModelList("TaskID=" + MyArray[i] + " order by CompleteTime desc");
if (list.Count < 1)
{
for (int j = 0; j < list.Count; j++)
{
sw.WriteLine("<Row>");
sw.WriteLine(" <Cell ss:StyleID=\"m134745396\"><Data ss:Type=\"String\">" + GetUnitName(list[j].ResponsibleUnits ) + "</Data></Cell>");
sw.WriteLine(" <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskNo,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow2(list[j].SupervisoryNo,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + list[j].TaskTitle + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + GetShow2(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].ResponsiblePerson + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].TaskGiveTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteInfo + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("</Row>");
}
}
else
{
for (int j = 0; j < list.Count; j++)
{
if (j == 0)
{
sw.WriteLine("<Row ss:AutoFitHeight=\"0\" ss:Height=\"18\">");
sw.WriteLine(" <Cell ss:MergeDown=\"" + (list.Count - 1) + "\" ss:StyleID=\"m134745396\"><Data ss:Type=\"String\">" + GetUnitName(list[j].ResponsibleUnits) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskNo,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow2(list[j].SupervisoryNo,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + list[j].TaskTitle + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + GetShow2(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].ResponsiblePerson + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].TaskGiveTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteInfo + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("</Row>");
}
else
{
sw.WriteLine("<Row>");
sw.WriteLine(" <Cell ss:Index=\"2\" ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskNo, list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow2(list[j].SupervisoryNo,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + list[j].TaskTitle + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">" + GetShow1(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
//sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + GetShow2(list[j].TaskContent,list[j].TaskType) + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].ResponsiblePerson + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].TaskGiveTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteTime.Value.ToShortDateString() + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\">" + list[j].CompleteInfo + "</Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("<Cell ss:StyleID=\"s63\"><Data ss:Type=\"String\"></Data></Cell>");
sw.WriteLine("</Row>");
}
}
}
}
sw.WriteLine("</Table>");
sw.WriteLine("<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">");
sw.WriteLine("<PageSetup>");
sw.WriteLine("<Layout x:Orientation=\"Landscape\"/>");
sw.WriteLine("<Header x:Margin=\"0.51181102362204722\"/>");
sw.WriteLine("<Footer x:Margin=\"0.51181102362204722\"/>");
sw.WriteLine("<PageMargins x:Bottom=\"0.98425196850393704\" x:Left=\"0.39370078740157483\" ");
sw.WriteLine("x:Right=\"0.39370078740157483\" x:Top=\"0.98425196850393704\"/>");
sw.WriteLine("</PageSetup>");
sw.WriteLine("<Print>");
sw.WriteLine("<ValidPrinterInfo/>");
sw.WriteLine("<PaperSizeIndex>9</PaperSizeIndex>");
sw.WriteLine("<HorizontalResolution>300</HorizontalResolution>");
sw.WriteLine("<VerticalResolution>300</VerticalResolution>");
sw.WriteLine("</Print>");
sw.WriteLine("<Zoom>115</Zoom>");
sw.WriteLine("<Selected/>");
sw.WriteLine("<Panes>");
sw.WriteLine("<Pane>");
sw.WriteLine("<Number>1</Number>");
sw.WriteLine("<ActiveRow>5</ActiveRow>");
sw.WriteLine("<ActiveCol>3</ActiveCol>");
sw.WriteLine("</Pane>");
sw.WriteLine("</Panes>");
sw.WriteLine("<ProtectObjects>False</ProtectObjects>");
sw.WriteLine(" <ProtectScenarios>False</ProtectScenarios>");
sw.WriteLine("</WorksheetOptions>");
sw.WriteLine("</Worksheet>");
sw.WriteLine(" </Workbook>");
sw.Close();
fs.Close();
//Common.JavascriptHelper.Alert("生成成功,请在“历次汇总下载”中下载", this);
ScriptManager.RegisterStartupScript(this.btnReport, this.btnReport.GetType(), "click", "showDig('" + FilesOperationUrl() + FileName + "');", true);
}
