×

Loading...

Excel Generating Component

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);
Sign in and Reply
Modify
Report