It has following features:
1. Allow multi-sheets based data source.
2. Allow encoding setting.
3. Auto-formating columns based on data type.
4. Allow font and font size changing.
5. Allow with or without grid border.
6. Allow header setting (font, font size, bold, backcolor)
7. Simple and easy to use.
8. And more.
Following is a sample using code:
DataSet ds = GetData(); // Pulling data from data source
int[] currencyIndexes = {3, 4}; // Format 3th, 4th Columnds as currentcy
ExcelDocs doc = new ExcelDocs(ds)
{
BoldHeader = true, // Optional
FontName = ExcelDocs.FonName.Arial, // Optional
FontSize = 11, // Optional
CurrencyColumns = currencyIndexes, // Optional
HeaderBackColor = ExcelDocs.BackColor.Pale_Blue, // Optional
HeaderFontName = ExcelDocs.FonName.Book_Antiqua, // Optional
HeaderFontSize = 12, // Optional
GridBorder = true, // Optional
ShowBooleanValue = ExcelDocs.BooleanValue.Yes_No, // Optional
XmlEncoding = ExcelDocs.Encoding.UTF_8, // Optional
StandaloneXml = true // Optional
};
doc.ExportReport(reportPath, reportName);
1. Allow multi-sheets based data source.
2. Allow encoding setting.
3. Auto-formating columns based on data type.
4. Allow font and font size changing.
5. Allow with or without grid border.
6. Allow header setting (font, font size, bold, backcolor)
7. Simple and easy to use.
8. And more.
Following is a sample using code:
DataSet ds = GetData(); // Pulling data from data source
int[] currencyIndexes = {3, 4}; // Format 3th, 4th Columnds as currentcy
ExcelDocs doc = new ExcelDocs(ds)
{
BoldHeader = true, // Optional
FontName = ExcelDocs.FonName.Arial, // Optional
FontSize = 11, // Optional
CurrencyColumns = currencyIndexes, // Optional
HeaderBackColor = ExcelDocs.BackColor.Pale_Blue, // Optional
HeaderFontName = ExcelDocs.FonName.Book_Antiqua, // Optional
HeaderFontSize = 12, // Optional
GridBorder = true, // Optional
ShowBooleanValue = ExcelDocs.BooleanValue.Yes_No, // Optional
XmlEncoding = ExcelDocs.Encoding.UTF_8, // Optional
StandaloneXml = true // Optional
};
doc.ExportReport(reportPath, reportName);