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 =...
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:
New Workbook:
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);
}
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...