Tuesday, November 29, 2016

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

What’s new in this release?

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++ component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for C++

No comments:

Post a Comment