PyExcel

Xlnt

 
 

Cross-Platform C++ Library for Excel Spreadsheet 

Open Source API allows to Read, Write, Modify & Export Microsoft Excel XLSX Spreadsheet Files via C++ API.

 

Xlnt is a modern open source C++ library that provides features for manipulating XLSX spreadsheets files. It enables software developers to read and write spreadsheet files from/to XLSX files. On May 10th, 2017 the first public release of Xlnt version 1.0 was available for public use. The recent work mostly focuses on compatibility enhancements and better performance.

The Xlnt library offers functionality for many important features, such as creating Excel-style workbook and numbers-style workbook, encrypted Workbook creation, Excel Binary Workbook, document Properties, hyperlink support, Page Margins, Comments, Cell Styles and many more.

Getting Started with Xlnt

The following steps update the compiler and set the appropriate environment variables.

Install PIP Command

sudo add-apt-repository ppa:ubuntu-toolchain-r/test
sudo apt update
sudo apt-get upgrade
sudo apt-get install gcc-6 g++-6
export CC=/usr/bin/gcc-6  
export CXX=/usr/bin/g++-6

First Download the zip files from the Xlnt repository at GitHub and then apply the following commands.

Install using GitHub

sudo add-apt-repository ppa:ubuntu-toolchain-r/test
sudo apt update
sudo apt-get upgrade
sudo apt-get install gcc-6 g++-6
export CC=/usr/bin/gcc-6  
export CXX=/usr/bin/g++-6

C++ API to Read from an Existing XLSX Spreadsheet

The open source Xlnt library provides functionality for reading an existing XLSX spreadsheet inside C++ applications. It also allows developers to print the string values to the screen.  Moreover, once you read the contents it is also possible to export the contents into a file and store on the location of your choice. 

Apply Formatting & Style to Excel Spreadsheet

The Xlnt library enables programmers to apply formatting and styles to their data inside an Excel spreadsheet. A format in Xlnt corresponds to the alignment, border, fill, font, number format, and protection settings applied to a cell. On the other hand, a style is a named style created in the "Cell styles" dropdown in Excel. It needs to have a name and optionally any of alignment, border, fill, font, number format, protection. A cell can have both a format and a style.

Setting Page Margins of a Worksheet

The open source Xlnt enables programmers to apply page margins to an Excel worksheet page inside their own C++ applications.  Page margins specify how much blank area should be left around the information in an Excel worksheet. They provide a visual border for users printed pages and an area where the page can be held or bound.