WorkSheet.Columns.AutoFit(); 如果使用 xml生成该如何设置?

Castiel丶Luo 2010-09-06 11:54:05

  writer2.WriteLine("<?xml version=\"1.0\"?>");

                writer2.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>");

                writer2.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"");

                writer2.WriteLine(" xmlns:o=\"urn:schemas-microsoft-com:office:office\"");

                writer2.WriteLine(" xmlns:x=\"urn:schemas-microsoft-com:office:excel\"");

                writer2.WriteLine(" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"");

                writer2.WriteLine(" xmlns:html=\"http://www.w3.org/TR/REC-html40\">");

                writer2.WriteLine(" <DocumentProperties xmlns=\"urn:schemas-microsoft-com:office:office\">");

                writer2.WriteLine(" <Author>SHELWIN NEE</Author>");

                writer2.WriteLine(string.Format(" <Created>{0}T{1}Z</Created>", DateTime.Now.ToString("yyyy-mm-dd"), DateTime.Now.ToString("HH:MM:SS")));

                writer2.WriteLine(" <Company>MESNAC</Company>");

                writer2.WriteLine(" <Version>11.6408</Version>");

                writer2.WriteLine(" </DocumentProperties>");

                writer2.WriteLine(" <ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">");

                writer2.WriteLine(" <WindowHeight>8955</WindowHeight>");

                writer2.WriteLine(" <WindowWidth>11355</WindowWidth>");

                writer2.WriteLine(" <WindowTopX>480</WindowTopX>");

                writer2.WriteLine(" <WindowTopY>15</WindowTopY>");

                writer2.WriteLine(" <ProtectStructure>False</ProtectStructure>");

                writer2.WriteLine(" <ProtectWindows>False</ProtectWindows>");

                writer2.WriteLine(" </ExcelWorkbook>");

                writer2.WriteLine(" <Styles>");

                writer2.WriteLine(" <Style ss:ID=\"Default\" ss:Name=\"Normal\">");

                writer2.WriteLine(" <Alignment ss:Vertical=\"Bottom\"/>");

                writer2.WriteLine(" <Borders/>");

                writer2.WriteLine(" <Font/>");

                writer2.WriteLine(" <Interior/>");

                writer2.WriteLine(" <Protection/>");

                writer2.WriteLine(" </Style>");

                writer2.WriteLine(" <Style ss:ID=\"s21\">");

                writer2.WriteLine(" <Alignment ss:Vertical=\"Bottom\" ss:WrapText=\"1\"/>");

                writer2.WriteLine(" </Style>");

                writer2.WriteLine(" </Styles>");

                writer2.WriteLine(" <Worksheet ss:Name=\"Sheet1\">");

                writer2.WriteLine(string.Format(" <Table ss:ExpandedColumnCount=\"{0}\" ss:ExpandedRowCount=\"{1}\" x:FullColumns=\"1\"", numCol.ToString(), numRow.ToString()));

                writer2.WriteLine(" x:FullRows=\"0\">");



                //确定列的格式

                for (numTemp = 0; numTemp != numCol - 1; numTemp++)

                {

                    writer2.WriteLine("<Column ss:AutoFitWidth=\"1\"/>");

                }

                //导出标题

                writer2.WriteLine("<Row ss:AutoFitHeight=\"1\">");

                for (numTemp = 0; numTemp != numCol; numTemp++)

                {

                    writer2.Write("<Cell ss:StyleID=\"s21\"><Data ss:Type=\"String\">");

                    writer2.Write(this.Columns[numTemp].Caption);

                    writer2.WriteLine("</Data></Cell>");

                }

                writer2.WriteLine("</Row>");

                //导出数据

                foreach (DataRow row1 in this.Rows)

                {

                    writer2.WriteLine("<Row>");

                    for (numTemp = 0; numTemp != numCol; numTemp++)

                    {

                        writer2.Write("<Cell ss:StyleID=\"s21\"><Data ss:Type=\"String\">");

                        writer2.Write(row1[numTemp].ToString());

                        writer2.WriteLine("</Data></Cell>");

                    }

                    writer2.WriteLine("</Row>");

                }

                writer2.WriteLine(" </Table>");

                writer2.WriteLine(" <WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">");

                writer2.WriteLine(" <Selected/>");

                writer2.WriteLine(" <Panes>");

                writer2.WriteLine(" <Pane>");

                writer2.WriteLine(" <Number>3</Number>");

                writer2.WriteLine(" <ActiveRow>1</ActiveRow>");

                writer2.WriteLine(" </Pane>");

                writer2.WriteLine(" </Panes>");

                writer2.WriteLine(" <ProtectObjects>False</ProtectObjects>");

                writer2.WriteLine(" <ProtectScenarios>False</ProtectScenarios>");

                writer2.WriteLine(" </WorksheetOptions>");

                writer2.WriteLine(" </Worksheet>");

                writer2.WriteLine(" <Worksheet ss:Name=\"Sheet2\">");

                writer2.WriteLine(" <WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">");

                writer2.WriteLine(" <ProtectObjects>False</ProtectObjects>");

                writer2.WriteLine(" <ProtectScenarios>False</ProtectScenarios>");

                writer2.WriteLine(" </WorksheetOptions>");

                writer2.WriteLine(" </Worksheet>");

                writer2.WriteLine(" <Worksheet ss:Name=\"Sheet3\">");

                writer2.WriteLine(" <WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">");

                writer2.WriteLine(" <ProtectObjects>False</ProtectObjects>");

                writer2.WriteLine(" <ProtectScenarios>False</ProtectScenarios>");

                writer2.WriteLine(" </WorksheetOptions>");

                writer2.WriteLine(" </Worksheet>");

                writer2.WriteLine("</Workbook>");

                writer2 = null;

                writer1.Close();