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: Wrong version was previously uploaded (v2.09). Now it should be v2.10....
link: /threads/xlutils-loa-reading-and-writing-excel-data-with-listofarrays.170983/ Depends on ListOfArrays...
link: - V2.09 - New bidi attribute for paragraph tags. Dim doc As WordDocument = wd.CreateDocument doc.A...

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.../android/forum/threads/xlutils-word-bookmarks-urls-and-page-breaks.131826/ The paragraph tag...
link: Please start a new thread....
link: how to adjust img width according to page width...

XLUtils v2.10 adds support for reading data as ListOfArrays, and writing data from ListOfArrays. Note that it depends on ListOfArrays v0.94+. Very simple to use. Excel workbook: 171431 Reading: 'Read the sheet: Dim res As XLReaderResult = xl.Reader.ReadSheetByIndex("C...
link: Fixed....
link: The latest version downloaded is still 2.09...

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...

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...

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...

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...