Aspose .NET Umbraco Data Exporter to Excel Module allows users to export data directly from local or remote database tables, views and by custom query into Microsoft Excel or OpenOffice Spreadsheet. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells. This initial version of the module is enriched with the following cool features to make the Export process simple and easy to use
- Allow to connect Local MS SQL Server Database
- Allow to connect Remote MS SQL Server Database
- Populate all Tables from connected database
- Populate all Views from connected database
- Allow to write Custom Query
- Allow to use as Data Source (Table, Views, Custom Query)
- Auto Fit Columns to contents length.
- Allow to skip string more than 32k in excel cells (LoadOptions)
- Apply Header Column formating as Bold Text
- Export Data to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export Data to Tab delimited text document (*.txt)
- Export Data to CSV (Comma delimited) (*.csv)
- Export Data to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting
- Exported document is automatically sent to browser for downloading
!! Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using the module.