예제 #1
0
 /// <summary>
 /// Initializes a new XlsDocument from the provided DataSet.  Each Table in the
 /// DataSet will be written to a separate Worksheet.  The data for each table will
 /// be written starting at A1 on each sheet, with a Header Row (A1 will be the
 /// name of the first Column, A2 will be the first value).
 /// </summary>
 /// <param name="dataSet">The DataSet to write to this XlsDocument.</param>
 public XlsDocument(DataSet dataSet)
     : this()
 {
     this.FileName = dataSet.DataSetName;
     foreach (DataTable table in dataSet.Tables)
     {
         Worksheet sheet = Workbook.Worksheets.Add(table.TableName);
         sheet.Write(table, 1, 1);
     }
 }
예제 #2
0
 // Token: 0x06000071 RID: 113 RVA: 0x000047A4 File Offset: 0x000037A4
 public XlsDocument(DataSet dataSet) : this()
 {
     this.FileName = dataSet.DataSetName;
     foreach (object obj in dataSet.Tables)
     {
         DataTable dataTable = (DataTable)obj;
         Worksheet worksheet = this.Workbook.Worksheets.Add(dataTable.TableName);
         worksheet.Write(dataTable, 1, 1);
     }
 }