Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


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

Sheraz KhanSheraz Khan Member Posts: 16

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

Sign In or Register to comment.