Create XLSB File in C++

Create XLSB File Using C++

How to create XLSB file? With Aspose.Cells for C++ library, you can easily Create XLSB file programmatically with a few lines of code. Aspose.Cells for C++ is capable of building cross-platform applications with the ability to generate, modify, convert, render and print all Excel files. C++ Excel API not only convert between spreadsheet formats, it can also render Excel files as images, PDF, HTML, ODS, CSV, SVG, JSON, WORD, PPT and more, thus making it a perfect choice to exchange documents in industry-standard formats. You can download its latest version directly, just open NuGet package manager, search for Aspose.Cells.Cpp and install. You may also use the following command from the Package Manager Console.

PM> Install-Package Aspose.Cells.Cpp

How to Create XLSB in C++

It is easy for the developers to create, load, modify and convert XLSB files within running reporting applications for data processing in just few lines of code.

1. Create an object of the Workbook class.
2. Get the first sheet into a Worksheet object.
3. Use Worksheet.GetCells() method to get the cells of the worksheet into a Cells object.
4. Use Cells.Get() method to access the desired cell of the worksheet into a Cell object.
5. Use Cell.PutValue() method to input value into the cell.
6. Save the workbook as .xlsb file using Save() method.

Aspose::Cells::Startup();

// Create an object of the Workbook class.
Workbook wkb;
// Get the first sheet into an Worksheet object.
WorksheetCollection wsc = wkb.GetWorksheets();
Worksheet ws = wsc.Get(0);


// Use Worksheet.GetCells() method to get the cells of the worksheet into an Cells object.
Cells cells = ws.GetCells();


// Use Cells.Get() method to access the desired cell of the worksheet into an Cell object.
Cell cell00 = cells.Get(0, 0);
Cell cell01 = cells.Get(0, 1);
Cell cell10 = cells.Get(1, 0);
Cell cell11 = cells.Get(1, 1);


// Use Cell.PutValue() method to input value into the cell.
cell00.PutValue(u"ColumnA");
cell01.PutValue(u"ColumnB");
cell10.PutValue(u"ValueA");
cell11.PutValue(u"ValueB");


// Save workbook to resultFile folder
wkb.Save(u"created_one.xlsb");

Aspose::Cells::Cleanup();

C++ library to create XLSB file

There are three options to install “Aspose.Cells for C++” onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:

1. Install a NuGet Package . See Documentation
2. Install the library using Include and lib Folders. See Documentation
3. Install Aspose.Cells for C++ in Linux. See Documentation

System Requirements

Before running the C++ conversion sample source code, make sure that you have the following prerequisites.

• Microsoft Windows or a compatible OS with C++ Runtime Environment for Windows 32 bit, Windows 64 bit and Linux 64 bit.
• Add reference to the Aspose.Cells for C++ DLL in your project.