B4J Question [XLUtils] How to create MS Excel documents?

[rtek1000]

Hi,

I found this library, very useful, but I couldn't find how to create the file.

There is a post related to how to create Word documents:

[XLUtils] Creating MS Word Documents

XLUtils v2.00 adds support for creating MS Word documents, and converting Word documents to PDF. It is done in a similar way to BCTextEngine, using custom BBCode. This works very nicely with B4X smart strings feature. Full example: Dim wd As WordUtils wd.Initialize Dim doc As WordDocument =...

www.b4x.com

Lib:

XLUtils / jPOI 5 - Read and write MS Excel workbooks

As written here, I plan to make it easier to read and write Excel workbooks. The solution is based on three components: - Apache POI - https://poi.apache.org/ Large open source project that provides APIs for Microsoft documents. Note that the files are accessed directly, it doesn't depend on the...

www.b4x.com

I found this reference that seems to be creating a new file:

​

Workbook wb = new HSSFWorkbook();
...
try  (OutputStream fileOut = new FileOutputStream("workbook.xls")) {
    wb.write(fileOut);
}

Workbook wb = new XSSFWorkbook();
...
try (OutputStream fileOut = new FileOutputStream("workbook.xlsx")) {
    wb.write(fileOut);
}

Source: https://poi.apache.org/components/spreadsheet/quick-guide.html#NewWorkbook


How can I create a new excel file using jPOI library?

Thank you.

 

[Erel]

[XLUtils] Writing Excel Workbooks

Main concepts and reading MS Excel workbooks with XLUtils: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/#content Writing workbooks is also simple but does require a bit more code. There are several types that we will use, in addition to...

www.b4x.com