Aspose Introduces New C++ APIs: Create, Edit & Convert XLS, XLSX Spreadsheets without MS Excel

2024-11-01 10:05:42 Computer

1168

Aspose is proud to expand its APIs family with the addition of a new product known as Aspose.Cells for C++ 16.11.0. Aspose.Cells for C++ allows developers to dynamically create, manipulate and convert spreadsheets without requiring Office Automation or Microsoft Excel application. Aspose.Cells for C++ is a native C++ library which is now available for public use. The first release of Aspose.Cells for C++ supports loading and saving Excel 97-2003 Workbook format (XLS) & Open Office XML format (XLSX) from file path as well as stream. It has provided the Workbook class which represents a Microsoft Excel spreadsheet, and provides the properties and methods necessary to work with spreadsheet files. In order to load an existing spreadsheet to an instance of Workbook class, one needs to pass the file path (or stream) to Workbook constructor whereas the Workbook.Save method can be used either for saving the resultant spreadsheet or for conversion. In order to access the worksheets from a spreadsheet, the Aspose.Cells for C++ has exposed the WorksheetCollection & Worksheet classes. A cell is the basic unit of a spreadsheet which can contain data or a formula along with formatting such as font and cell shading. In perspective of Aspose.Cells for C++, a cell is represented by an instance of Cell class whereas a collection of cells is represented by an instance of CellsCollection class. The Aspose.Cells for C++ offers Row & RowCollection classes in order to deal with the worksheet rows whereas Column & ColumnCollection classes have been made available to deal with columns in a worksheet. These classes provide a number of properties and methods in order to manipulate rows and columns as per application requirements. An Excel table is a matrix of cells containing any number of rows and columns whereas the same table is referred to be as a List Object in Aspose.Cells for C++ APIs. The Aspose::Cells::Tables namespace contains all the necessary classes that deals with the operations related to the List Objects. Most worth mentioning classes are ListObject and ListObjectCollection which allow creating and formatting List Objects and so on. It has one of its kind custom built formula calculation engine which supports almost all English based Excel functions including text, logical, information, date & time, lookup & reference, math & trigonometry, statistical, database, financial formulas. Aspose.Cells for C++ also provides the ability to insert a function to a cell as well as retrieve the calculated value. This release includes several enhanced features and bug fixes as listed below

? Open/Save XLS, OOXML file formats
? Set Styles and Formatting to worksheet cells
? Apply data validation to the cells
? Filter data by using an AutoFilter
? Apply Page Setup options
? Set data and Formulas to the cells

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++

- Homepage of Aspose.Cells for C++: http://www.aspose.com/products/cells/cpp

- 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