Search Results

on the Excel program. - jPOI - This is a wrapper for Apache POI. - XLUtils - A b4xlib (B4J only.../poi5_dependencies.zip - Download XLUtils. It includes the updated jPOI. Put them in the additional...
link: - V2.07 - Fixes an issue with xl.AddressToString and columns with 'Z' address. Thanks @angel...
link: - V2.06 - Fixes an issue that caused a compilation error in non-ui apps....
link: - V2.04 - Word - new SetMargins method. This method, as SetLandscapeOrientation, depends on poi-ooxm...

115104 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 = wd.CreateDocument doc.Append($"Word document with two lines. This is the second line."$.../android/forum/threads/xlutils-word-bookmarks-urls-and-page-breaks.131826/ The paragraph tag...

114085 XLUtils v1.13 adds support for converting workbooks to PDF. This is a Windows only feature and it relies on Excel being installed on the computer. Exporting to PDF is a matter of calling: Wait For (xl.PowerShellConvertToPdf(WorkbookFile, OutputPDF, SheetIndex, True)) Complete (Success As Boolean) You can also set the print area with Sheet.PrintArea and the print scaling with Sheet.../android/forum/threads/xlutils-templates-and-charts.130373/#content It creates a workbook and then...

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 XLUtils: XLWorkbookWriter - Represents the complete workbook. Created with xl.CreateWriterBlank - creates... of XLUtils: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel...

115274 XLUtils v2.02 adds support for urls, bookmarks and page breaks. A paragraph tag with the PageBreak attribute will start on a new page. $"This will appear at the top of the page"$ The url tag can be used to create external or internal links. External link: $"www.b4x.com"$ Adding internal links is done in two steps: create a bookmark, add one or more links to this bookmark. Create bookmark and set its anchor to "top". Note that it is a self closed tag...

Creating new workbooks based on existing workbooks saves a lot of work and also allows adding features that are not directly available in POI / XLUtils, such as charts. Templates are regular workbooks. Creating a new workbook based on an existing one is very simple, you just need to call XL.CreateWriterFromTemplate instead of CreateWriterBlank. Charts If the source data size is known then adding a chart is trivial. No need to do anything special. When the size is unknown, several extra steps...

draw all charts and prepare the PDF, it shows that XLUtils (POI) can create large Word documents easily....

. You can use both features together. - Requires XLUtils v1.11+...

XLUtils v1.05 adds support for conditional formatting. 112943 A conditional formatting element is made of the applied range and one or more rules. A rule is made of a formula and formatting effects. The formula will be evaluated on each cell in the range. By using a relative address to the first cell in the formula, we are actually referencing all cells in range. Adding conditional formatting is done in three steps: 1. Create one or more rules using Sheet.CreateConditionalFormattingRule. 2...

XLUtils v1.03 adds support for grouping rows and columns and for adding links. 112806 Grouping is done with XLSheetWriter.GroupRows / Columns. By default the expand button is positioned at the bottom. You can move it to the top using a template. Choose Data - Outline settings and uncheck "summary rows below detail": 112808 Adding links is done with XLSheetWriter.CreateHyperlink: Dim LinkStyle As XLStyle = workbook.CreateStyle.FontLink(11).HorizontalAlignment("CENTER"...