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 Setup()
{
_data = new DataSet("Test");
_data.Tables.Add(DataSourceConverterTest.GetDataTable());
_data.Tables.Add(GetSecondDataTable());
}