Read Large Excel Files with LightCells API & Reading/Writing Pivot Table of Xlsb


Well-known member
Mar 10, 2010
Programming Experience
What is new in this release?

We are pleased to announce the new release of Aspose.Cells for .NET 7.7.1. It has been released with over 80 useful new features, enhancements and bug fixes. This new release supports reading large Excel files with LightCells API . This is a very useful feature. Sometimes you need to read data from a huge Microsoft Excel workbook with millions of records and you always worry about the performance. You want it to take less time and memory to process big files. The LightCells API is useful in that scenario: to read huge Excel spreadsheets, it uses less memory, so you get better performance and efficiency. Another valuable feature is to find the cells with some particular style or formatting. Aspose.Cells supports finding all cells that have a common style or formatting. It provides the FindOptions.Style property which you can use to specify the style to search cells for. You can now create transparent images of Microsoft Excel worksheet. Sometimes, you need to generate an image of your worksheet as a transparent image. For example, you might want to apply transparency to all the cells which have no fill color. Aspose.Cells provides the ImageOrPrintOptions.Transparent property which applies transparency to a worksheet image. When this property is false, then the cells with no fill color are drawn with white background, and when it is true, cells with no fill color are rendered transparent. In this version, we have refactored the PivotTables module. We?ve made tremendous enhancements and fixed several issues. Several important issues and other enhancements have been addressed in this release as well. For example, issues around reading and writing Microsoft Excel file formats, manipulating conditional formatting, rendering and manipulating pivot tables, rendering images from Excel worksheets, reading and writing HTML files, rendering shapes and controls, Smart Markers, manipulating embedded OLE objects, rendering and manipulating charts, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine of Aspose.Cells for .NET, it now supports the BITAND function (Microsoft Excel 2013). This release includes few enhanced features and plenty of bug fixes as listed below

- Supports reading large files with LightCells
- Rework of reading and writing pivot table of xlsb
- Calculate Min and Max values for DataBars Conditional Formatting
- Read large MS Excel files in light cells mode - (LightCells API)
- Render Conditional Formatting Data Bars with negative values in Sheet to Image feature
- Render cells without colors as transparent cells in the Sheet to Image feature
- Support BitAnd function
- Change the color of all the cells which have some specific color
- Conditional formatting on PivotTable is lost when processed with Aspose.Cells
- Embedding DOC file into an XSLX format now start MS Word to load the embedded DOC
- Issue fixed with rendering Arrow shape in the output PDF file
- Cell.GetDisplayStyle() is now working for TOP 10% and BOTTOM 10% conditional formattings
- Wrong color usage is fixed in the image when rendering from Excel picture
- Aspose.Cells corrupts the XLSB file is now fixed
- MS Excel shows "Unreadable Contents" message is now fixed
- Unicode/Double byte/JPN - HTML conversion issues are resolved
- Excel PivotTable RemoveField problem is fixed
- MS Excel 2003 Report conversion to Excel 2010
- Incorrect 'Repeat item labels' state (*.xlsb) is fixed
- PivotField issue is resolved - Incorrect 'IsCalculatedField' state (*.xlsb)
- PivotTable - Incorrect 'Sort A to Z' state is fixed(*.xlsb)
- PivotTable - Incorrect 'Report filter fileds per row/column' value is fixed (*.xlsb)
- PivotTable - Incorrect 'Number of items to retain per field' state is corrected (*.xlsb)
- PivotTable - Missing value for 'RowHeaderCaption' field is fixed (*.xlsb)
- PivotTable - Missing value of data source for Pivot Tables with multiple consolidation ranges is fixed (*.xlsb)
- PivotTable - Incorrect indent value is corrected
- Incorrect 'Row/Column Headers' state is fixed (*.xlsb)
- PivotTable - Incorrect 'Use Custom Lists when sorting' state is fixed (*.xlsb)
- PivotTable - Incorrect 'AutoFormat' value is fixed (*.xlsb)
- PivotField - Incorrect 'Include new items in manual filter' state (*.xlsb)
- PivotTable - Incorrect 'Show the Values row' state is fixed (*.xlsb)
- Multiline cells are truncation is fixed when transformed to images (Sheet to Image)
- Export to PDF - Multiline text is cut off and overlapped in the cells is fixed
- XLSX to PDF: Result now have Left and Right margins
- Issue fixed with Databars having negative value in conditional formatting
- Rendering only the third page into tiff without following the sequence now work
- Data loss and incorrect label alignment issue is fixed when Excel file is converted to PDF format
- PDF generation formatting issue is fixed with the data
- Title rows coming twice on the first page in the output pdf is now fixed
- PDF generation - Data formatting problem is resolved
- Vertical cell alignment now kept when rendering Excel to PNG image for conditionally formatted cells
- Now can get the image of a chart
- Rendering Arrow issue is resolved in the output HTML file format
- Regression in the quality of SheetRender.ToImage with transparencies
- Fixed bug for the transparency of a Column chart
- ToTiff function Issues resolved for charts' rendering (Extended)
- Autofit Row height issue is resolved in MS Excel 2007
- Combining Worksheets reset the Table names
- Wrap text format is now copied correctly when using Worksheet.Copy method
- Small column widths are now copied correctly when using Worksheet.Copy Method
- Overlapping styles issue is resolved
- The linked cell is now updated from the dropdown list
- Images height changes even though their height is fixed in SmartMarker tags
- Conditional formatting problem in XPS file format is fixed
- Conditional formatting evaluation is corrected
- Conditional formatting Iconset doesn't return the right icons is now fixed
- Image is getting shorter when Worksheet.AutoFitRows() method is called
- Aspose Cells corrupts XLSB workbooks containing embedded objects
- The four cells A1-D1 differ in "0 VS blank"
- Pivot table resizing is fixed enough for some date columns
- Save As XLSX by Aspose.Cells and Open Xml SDK issue is resolved
- Conditional formatting is now well maintained after saving an XLSX file
- Signature Line feature lost is fixed when saving workbook with Aspose Cells
- XLSX character formatting is now working
- Save causes font settings to disappear is now fixed
- Formatting lost upon Saving Workbook is now fixed
- Border style and background changes are fixed when converting an XML - Spreadsheet to XLSX file format
- Excel date formatting and string value lost is fixed when we convert via Aspose.Cells component

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Using LightCells API
- Create Transparent Image of Excel Worksheet

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - Your File Format Experts
Phone: 888.277.6734
Fax: 866.810.9465
Top Bottom