/// <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); } }
// 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); } }