/// <summary>
/// Creates <see cref="DataSourceConverter{DataRow}"/>s based off the <see cref="DataTable"/>. Defaults to all
/// columns defined in each <see cref="DataTable"/>
/// </summary>
/// <param name="table">DataTable</param>
/// <returns>DataSource Converter</returns>
public static DataSourceConverter <DataRow> CreateDefaultDataTableConverter(DataTable table)
{
DataSourceConverter <DataRow> converter = new DataSourceConverter <DataRow>();
foreach (DataColumn column in table.Columns)
{
converter.Fields.Add(new AdapterBoundField <DataRow>(column.ColumnName));
}
return(converter);
}
public void CreateSpreadsheetFromIEnumerable()
{
DataSourceConverter <DisneyCharacter> converter = new DataSourceConverter <DisneyCharacter>();
converter.Fields.Add(new AdapterBoundField <DisneyCharacter>("Name", "Character Name"));
converter.Fields.Add(new AdapterBoundField <DisneyCharacter>("Age", null, "{0:###}"));
XlsDocument doc = new XlsDocument();
converter.CreateWorksheet(doc, _dataList, "testing");
ValidateXlsToIList(doc);
}
public void CreateWorksheetWithDataTable()
{
DataSourceConverter <DataRow> converter = new DataSourceConverter <DataRow>();
converter.Fields.Add(new AdapterBoundField <DataRow>("Name", "Character Name"));
converter.Fields.Add(new AdapterBoundField <DataRow>("Age", "Age", "{0:###}"));
XlsDocument doc = new XlsDocument();
converter.CreateWorksheet(doc, _data, _data.TableName);
Assert.AreEqual(1, doc.Workbook.Worksheets.Count);
ValidateWorksheetFromDataTable(doc.Workbook.Worksheets[0], _data);
}
public void CreateSpreadSheetFromObjectDataSource()
{
DataSourceConverter <DisneyCharacter> converter = new DataSourceConverter <DisneyCharacter>();
converter.Fields.Add(new AdapterBoundField <DisneyCharacter>("Name", "Character Name"));
converter.Fields.Add(new AdapterBoundField <DisneyCharacter>("Age", null, "{0:###}"));
XlsDocument doc = new XlsDocument();
ObjectDataSource ods = new ObjectDataSource("org.in2bits.MyXls.Data.DataSourceConverterTest, org.in2bits.MyXlsTests", "GetData");
converter.CreateWorksheet(doc, ods, "testing");
ValidateXlsToIList(doc);
}
public void WithCustomConverters()
{
DataSetConverter converter = new DataSetConverter();
DataSourceConverter <DataRow> table1Converter = new DataSourceConverter <DataRow>();
table1Converter.Fields.Add(new AdapterBoundField <DataRow>("Name", "Character Name"));
table1Converter.Fields.Add(new AdapterBoundField <DataRow>("Age", "Age", "{0:###}"));
converter.TableAdapters.Add(table1Converter);
converter.TableAdapters.Add(DataSetConverter.CreateDefaultDataTableConverter(_data.Tables[1]));
XlsDocument doc = new XlsDocument();
converter.CreateDocument(doc, _data);
Assert.AreEqual(_data.Tables.Count, doc.Workbook.Worksheets.Count);
DataSourceConverterTest.ValidateWorksheetFromDataTable(doc.Workbook.Worksheets[0], _data.Tables[0]);
ValidateSheetFromDataTable(doc.Workbook.Worksheets[1], _data.Tables[1]);
}
public void CreateSpreadsheetWithBoldHeadersAndCallback()
{
DataSourceConverter <DataRow> converter = new DataSourceConverter <DataRow>();
converter.Fields.Add(new AdapterBoundField <DataRow>("Name", "Character Name"));
AdapterBoundField <DataRow> ageField = new AdapterBoundField <DataRow>("Age");
// Create a delegate on the field that handles populating each row
// this delegate is called for each row for the field in the data
ageField.CellDataBound += delegate(object sender, AdapterFieldEventArgs <DataRow> args)
{
args.Cell.Value = String.Format("{0} is {1} Years Old", args.DataItem["Name"], args.DataItem["Age"]);
};
converter.Fields.Add(ageField);
converter.HeaderDataBound += DataSourceConverter <DataRow> .BoldAllCells;
XlsDocument doc = new XlsDocument();
converter.CreateWorksheet(doc, _data, "Testing");
// validate worksheet is created
Assert.AreEqual(1, doc.Workbook.Worksheets.Count);
Assert.AreEqual(_data.Rows.Count + 1, doc.Workbook.Worksheets[0].Rows.Count);
// validate header row
Assert.AreEqual("Character Name", doc.Workbook.Worksheets[0].Rows[1].CellAtCol(1).Value);
Assert.IsTrue(doc.Workbook.Worksheets[0].Rows[1].CellAtCol(1).Font.Bold);
Assert.AreEqual("Age", doc.Workbook.Worksheets[0].Rows[1].CellAtCol(2).Value);
Assert.IsTrue(doc.Workbook.Worksheets[0].Rows[1].CellAtCol(2).Font.Bold);
ushort i = 2;
foreach (DataRow row in _data.Rows)
{
Assert.AreEqual(row["Name"], doc.Workbook.Worksheets[0].Rows[i].CellAtCol(1).Value);
Assert.AreEqual(String.Format("{0} is {1} Years Old", row["Name"], row["Age"]),
doc.Workbook.Worksheets[0].Rows[i].CellAtCol(2).Value);
i++;
}
}
