Read/Write XLSM, CSV or XLSB Files & Named Ranges Support in Excel Spreadsheets using C++

It has provided support for more file formats including CSV, Tab-Delimited, XLSM and XLSB. Developers can now load these file formats in Aspose.Cells' object model as well as save the result back after manipulation.
By: Aspose
 
LANE COVE, Australia - Feb. 9, 2017 - PRLog -- What's new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for C++ 17.1.0. This release includes many new features and enhancements that further improve the overall feature set of the API. This new release has provided support for more file formats including CSV, Tab-Delimited, XLSM (macro enabled spreadsheet format since Excel 2007) and XLSB (binary spreadsheet format since Excel 2007). Developers can now load these file formats in Aspose.Cells' object model as well as save the result back after manipulation. The process to load any of the supported file format is simple as passing the file path (or an object of the FileStream) to the Factory::CreateIWorkbook method, however, in order to save the result in a particular file format requires explicit directive, that is; by passing appropriate second parameter from the Aspose::Cells::SaveFormat enumeration to the IWorkbook.Save method. In order to get more in-depth knowledge of these newly supported file formats, please check the detailed articles in the documentation section, such as Load & save CSV files, Load & save Tab-Delimited files, Load & save XLSM spreadsheet files and Load & save XLSB spreadsheet files. Aspose.Cells for C++ API now supports the creation of named ranges. The simplest approach to create a named range is to first create an object of the IRange class, and then set its Name property while using the IRange.SetName method. This makes the named range to appear in the Microsoft Excel's Name Manager interface. Besides creating new named ranges, Aspose.Cells for C++ API also supports to manipulate existing named ranges. Please note, if an object of the IRange has the Name property set, that is; IRange object has a name then it becomes the part of the INameCollection which can be accessible via the IWorksheetCollection class object. If the application requirement is to retrieve a specific named range, it can be get via the INameCollection.GetObjectByIndex method. This release includes several enhanced features and bug fixes as listed below

·         Read / Write XLSM file format

·         Read / Write CSV file format

·         Read / Write XLSB file format

·         Create and manipulate Named Ranges

·         Read / Write Tab Delimited file format

Newly added documentation pages and articles

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

 -  Read and Write CSV File Format: https://docs.aspose.com//display/cellscpp/Read+and+Write+CSV+file+format (https://docs.aspose.com/display/cellscpp/Read+and+Write+C...)

 - Create Named Range in a Workbook: https://docs.aspose.com//display/cellscpp/Create+Named+Range+in+a+Workbook (https://docs.aspose.com/display/cellscpp/Create+Named+Ran...)

Overview: Aspose.Cells for C++

Aspose.Cells is a C++ is a native C++ library that enables developers to create, read, edit & convert Excel spreadsheets programmatically without relying on Office automation or Microsoft Excel application. It offers a set of high-level API's to XLS and XLSX formats in the C++ language. Converting XLS to XLSX and XLSX to XLS is as easy and simple as a two liner code. It also supports saving and opening Excel files to and from streams, apply styles and formatting to Excel worksheets, filter data by using an AutoFilter , read and write complex formulae easily & more.

More about Aspose.Cells for C++

-  Download Aspose.Cells for C++: http://downloads.aspose.com/cells/cpp

-  Online documentation of Aspose.Cells for C++: http://www.aspose.com/docs/display/cellscpp/Home

Contact Information

Aspose Pty Ltd,

Suite 163, 79 Longueville Road

Lane Cove, NSW, 2066

Australia

http://www.aspose.com/

sales@aspose.com


Phone: 888.277.6734

Fax: 866.810.9465

Contact
Aspose
***@aspose.com
End
Source:Aspose
Email:***@aspose.com Email Verified
Tags:Write CSV File Format, Read XLSM File Format, Excel spreadsheet API
Industry:Software
Location:Lane Cove - New South Wales - Australia
Account Email Address Verified     Account Phone Number Verified     Disclaimer     Report Abuse
Aspose Pty Ltd. News
Trending
Most Viewed
Daily News



Like PRLog?
9K2K1K
Click to Share