More examples of Aspose.Cells for .NET features missing in VSTO to deal with Microsoft Excel Documents
[![][1] helps you to understand the extra features and importance of Aspose.Cells over VSTO Excel.
What’s New in the release of v1.1 Save Workbook to Text or CSV Format Encrypting Excel Files Display or Hide Tabs Display or Hide Scroll Bars Display or Hide Gridline Display or Hide Row Column Headers Advanced Protection Settings since Excel XP Tracing Precedents and Dependents Adding Hyperlinks to Link Data Exisiting Examples Smart Markers Smart Markers feature Grouping Data Using Anonymous Types or Custom Objects Image Markers Using Nested Objects Converting Worksheet Converting Worksheet to Image Converting Worksheet to Image File By Page Import and Export Worksheet Import data from document Importing from Array Importing from ArrayList Importing from Custom Objects Importing from DataTable Export data from document Columns Containing Strongly Typed Data Columns Containing Non-Strongly Typed Data Conversion Conversion Download Latest Examples You can download latest examples from one of the following locations:
DNN Export Data to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells
Aspose .NET DNN Data Exporter to Excel Module allows users to export data directly from local or remote database tables, views and by the custom queries 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.
free download video demo open source Features in this Release The release of this module supports the following features.
Apply Themes to Charts in Excel Files using Java
We are pleased to announce the release of Aspose.Cells for Java 7.3.0. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long-awaited feature: support for XML maps.
Read/Write MHTML Files and Apply Themes to Charts in Aspose.Cells for .NET 7.3.0
[![Aspose.Cells logo][1]. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long awaited feature: support for XML maps.
Our development team has worked to improve sheet to image and Excel to PDF conversions.
Disable Compatibility Checker in Excel and Other Useful Enhancements using Aspose.Cells for .NET 7.2.2
We’re pleased to share the announcement of Aspose.Cells for .NET 7.2.2. We have added a new feature, disabling Microsoft Excel’s Compatibility Checker in this release. We have also added support for adding quotes around your data when saving to CSV format, as one of our customers asked us to. We have added some other useful enhancements around the Subtotals feature. The XML Map properties will now be retained when re-saving the template file.
Input Large Strings and Other Enhancements in Aspose.Cells for .NET 7.2.1
We are pleased to announce the release of Aspose.Cells for .NET 7.2.1. This month’s release allows you to input strings larger than 32K for text and CSV formats. We have enhanced the shapes rendering module, specifically improving Excel-to-PDF conversion. We have also improved the Smart Markers feature so that Aspose.Cells for .NET now supports nested objects in Smart Markers.
Moreover, we have made some enhancements regarding PivotTables and the internal Worksheet-to-Image modules and fixed some other issues.
Import DataView with more than 65,536 Records and useful enhancements with Aspose.Cells for .NET 7.2.0
We are pleased to announce the release of Aspose.Cells for .NET 7.2.0. This month’s release provides extensive support for the DataView object and now you can import more than 65,536 records; this was a restriction in the older versions. An important enhancement is also made for the ComboBox control for XLSM file format. Moreover, we have fixed a number of bugs, one of them is: “Build Error C2686” for C++ users especially.
Dates Retained when Reading CSV Files using Java
We are pleased to announce the release of Aspose.Cells for Java 7.2.0. This month’s release provides support to retain the exact date format when reading CSV files: the dates will not be changed. We have also made some enhancements regarding shape rendering in our internal source modules. Finally, we have fixed a few issues regarding charts and other drawing objects.
Read release notes to get a full list of the new enhancements and fixes included in Aspose.
Create Tables in XLS Format and Customize the Ribbon XML using Aspose.Cells for .NET 7.1.2
We are pleased to announce the release of Aspose.Cells for .NET 7.1.2. This month’s release provides extensive support for tables in XLS format. You can now customize the Ribbon XML. There are some enhancements made for pivot table module. We have improved the performance for PDF rendering and loading large workbooks. Both the load and export processes are now fast enough to suit your performance needs.
Aspoce.Cells Formula Calculation Engine has been enhanced further and we have fixed some bugs for certain formulas.
Tracing Dependents and HTML Table Attributes Supported in Aspose.Cells for .NET 7.1.1
Aspose.Cells for .NET v7.1.1 has been released. This release includes support for tracing precedents and dependents. We also supported new HTML table attributes (for example, TH, ROWSPAN, etc.) for HTML-to-Excel conversion. Moreover, you can now ignore hidden columns when using the auto-fit column(s) feature. We have enhanced the formula calculation engine and sorted out a few formulas, most notably, VLOOKUP, OFFSET, ADDRESS, COUNTBLANK, IF and NETWORKDAYS. We have also improved the Excel-to-PDF conversion feature.