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
• Auto Fit Columns to contents length.
• Allow to skip string more than 32k in excel cells (LoadOptions)
• Apply Header Column formating as Bold Text
• Allow to use as Data Source (Table, Views, Custom Query)
• 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.

• Downloading, Installing and Uninstalling
• Using and Video Demo

There is much more yet to come and many more examples with documentation are available at Aspose Docs. Keep visiting us.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with Aspose. Once you have signed up, you are ready to try powerful file processing features offered by Aspose file format APIs.

Customer Feedback

Your feedback is very important to us. Please feel free to provide feedback and raise feature requirements. We are keen to implement customer driven features since we are a 100% customer driven company.