openxml2.0中的 BestFit 如何使用

• 常规讨论

• 

  

  0

  登录进行投票

  在http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.column_properties(office.14).aspx中介绍了可以调整column宽度的 BestFit 属性，但是我不知道如何定义宽度。

  代码如下：其中CreateMockDataSet()为自定义的一个DateSet,返回了三列值  我不知道如何定位一个列，并设置其宽度

  要想运行如下代码，请安装openxml2.0 sdk并引用

  using DocumentFormat.OpenXml;
  using DocumentFormat.OpenXml.Packaging;
  using DocumentFormat.OpenXml.Spreadsheet;

  Code Snippet

  protected void Button1_Click(object sender, EventArgs e)
          {
              File.Copy(Server.MapPath(@"sampledoc/dhy.xlsx"), Server.MapPath(@"sampledoc/dhy1.xlsx"), true);
              // Open the document for editing.
              using (SpreadsheetDocument spreadSheet = SpreadsheetDocument.Open(Server.MapPath(@"sampledoc/dhy1.xlsx"), true))
              {
                  // Get the SharedStringTablePart. If it does not exist, create a new one.
                  SharedStringTablePart shareStringPart;
                  if (spreadSheet.WorkbookPart.GetPartsOfType().Count() > 0)
                  {
                      shareStringPart = spreadSheet.WorkbookPart.GetPartsOfType().First();
                  }
                  else
                  {
                      shareStringPart = spreadSheet.WorkbookPart.AddNewPart();
                  }
                  // Insert a new worksheet.
                  //WorksheetPart worksheetPart = InsertWorksheet(spreadSheet.WorkbookPart);
                  WorksheetPart worksheetPart = spreadSheet.WorkbookPart.GetPartsOfType().First();
                
                  // Insert the text into the SharedStringTablePart.
                  for (int i = 0; i < CreateMockDataSet().Tables[0].Rows.Count; i++)
                  {
                      for (int j = 0; j < CreateMockDataSet().Tables[0].Columns.Count; j++)
                      {
                          int index = InsertSharedStringItem(CreateMockDataSet().Tables[0].Rows[i][j].ToString(), shareStringPart);
                         
                          // Insert cell A1 into the new worksheet.
                          Cell cell;
                          switch (j)
                          {
                              case 0:
                                  cell = InsertCellInWorksheet("A", (uint)i+1, worksheetPart);
                                  cell.CellValue = new CellValue(index.ToString());
                                  cell.DataType = new EnumValue(CellValues.SharedString);
                                  break;
                              case 1:
                                  cell = InsertCellInWorksheet("B", (uint)i+1, worksheetPart);
                                  cell.CellValue = new CellValue(index.ToString());
                                  cell.DataType = new EnumValue(CellValues.SharedString);
                                  break;
                              case 2:
                                  cell = InsertCellInWorksheet("C", (uint)i+1, worksheetPart);
                                  cell.CellValue = new CellValue(index.ToString());
                                  cell.DataType = new EnumValue(CellValues.SharedString);
                                  break;
                          }
                      }
                  }
                
                  worksheetPart.Worksheet.Save();
              }
              Response.Clear();
              Response.ClearHeaders();
              Response.Buffer = false;
              Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.document";
              Response.AddHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(@"aa.xlsx", System.Text.Encoding.UTF8));
              Response.Charset = "GB2312";
              Response.ContentEncoding = System.Text.Encoding.UTF8;
              Response.WriteFile(Server.MapPath(@"sampledoc/dhy1.xlsx"));
              Response.Flush();
              Response.End();
          }

   

   

  Code Snippet

  private static DataSet CreateMockDataSet()
          {
              DataTable table = new DataTable("sample");
              DataColumn column;
              DataRow row;
              // Create the first column and add to the DataTable.
              column = new DataColumn();
              column.DataType = System.Type.GetType("System.Int32");
              column.ColumnName = "DocID";
              column.AutoIncrement = true;
              column.Caption = "ID";
              // Add the column to the DataColumnCollection.
              table.Columns.Add(column);
              // Create the second column and add it to the column set.
              column = new DataColumn();
              column.DataType = System.Type.GetType("System.String");
              column.ColumnName = "DocName";
              column.AutoIncrement = false;
              column.Caption = "DocName";
              table.Columns.Add(column);
              // Create the third column and add it to the column set.
              column = new DataColumn();
              column.DataType = System.Type.GetType("System.String");
              column.ColumnName = "ChapterTitle";
              column.AutoIncrement = false;
              column.Caption = "ChapterTitle";
              table.Columns.Add(column);
              // Create five DataRow objects, and add them to DataTable.
              for (int i = 0; i <= 4; i++)
              {
                  row = table.NewRow();
                  row["DocID"] = i;
                  row["DocName"] = "Doc " + i;
                  row["ChapterTitle"] = "Chapter Title " + i;
                  table.Rows.Add(row);
              }
              // Create a data set from the table and return it.
              DataSet ds = new DataSet();
              ds.Tables.Add(table);
              return ds;
          }

   

   

  • 已更改类型 宋翔Moderator 2011年4月10日 18:41

  2009年1月10日 6:25

  回复

  |

  引用