Umbraco Export Data from database table or custom query to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells
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
Features in this Release
The release of this module supports the following features.
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
Umbraco Export Data from database table or custom query to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells
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
Features in this Release
The release of this module supports the following features.