Support for Loading & Saving CSV, XLSM & XLSB File Formats, Create & Manipulate Named Ranges with Aspose.Cells for C++ 17.1.0

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Cells for C++Aspose Team is pleased to announce the 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. Please check the detailed release notes in order to get an idea about what is new and what has been enhanced with this revision of Aspose.Cells for C++. If you are planning to upgrade the API from any previous version, we strongly suggest you to check the Public API Changes section to know what has been changed since your current revision of the API.

While you are downloading the API build to give it a try, here is a list of added features along with a few code snippets for quick testing.

Support for More File Formats

This release of Aspose.Cells for C++ has provided the 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 as follow.

Support for Named Ranges

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.

The following code demonstrates the use of Aspose.Cells for C++ API to create a named range in a newly created spreadsheet.

Append(new String("outCreateNamedRange.xlsx"));

//Create a workbook
intrusive_ptr wb = Factory::CreateIWorkbook();

//Access first worksheet
intrusive_ptr ws = wb->GetIWorksheets()->GetObjectByIndex(0);

//Create a range
intrusive_ptr rng = ws->GetICells()->CreateIRange((intrusive_ptr)new String("A5:C10"));

//Set its name to make it named range
rng->SetName((intrusive_ptr)new String("MyNamedRange"));

//Read the named range created above from names collection
intrusive_ptr nm = wb->GetIWorksheets()->GetINames()->GetObjectByIndex(0);

//Print its FullText and RefersTo properties
printf("Full Text: %s\n", nm->GetFullText()->charValue());
printf("Refers To: %s\n", nm->GetRefersTo()->charValue());

//Save the workbook in xlsx format
wb->Save(outCreateNamedRange, SaveFormat_Xlsx);

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.

The following code snippet uses the Aspose.Cells for C++ API to manipulate an existing named range.

//Path of your directory where you want to read or write files from
StringPtr dirPath = new String("D:\\Downloads\\");

//Path of source excel file
StringPtr srcManipulateRange = (new String(dirPath))->Append(new String("srcManipulateRange.xlsx"));

//Path of output excel file
StringPtr outManipulateRange = (new String(dirPath))->Append(new String("outManipulateRange.xlsx"));

//Create a workbook
intrusive_ptr wb = Factory::CreateIWorkbook(srcManipulateRange);

//Read the named range created above from names collection
intrusive_ptr nm = wb->GetIWorksheets()->GetINames()->GetObjectByIndex(0);

//Print its FullText and RefersTo properties
printf("Full Text: %s\n", nm->GetFullText()->charValue());
printf("Refers To: %s\n", nm->GetRefersTo()->charValue());

//Manipulate the RefersTo property of NamedRange
nm->SetRefersTo((intrusive_ptr)new String("=Sheet1!$D$5:$J$10"));

//Save the workbook in xlsx format
wb->Save(outManipulateRange, SaveFormat_Xlsx);

Aspose.Cells for C++ Resources

The resources, you may need to accomplish your tasks:

Keeping the Aspose tradition, you are welcome to shape the upcoming releases of Aspose.Cells for C++ API by posting your suggestions and concerns in the Aspose.Cells support forum.


To keep up with our news, you can follow us on Twitter or follow our Facebook page.