Search Results

XLUtils is a wrapper of poi-5.0.0, it does not support TextDirection, you can use poi-5.1.0+ for that. Download poi-5.1.0 here and move the jar to additional folder The project is attached.
link: Yes. I'm using XLUtils to create the word document
link: Hi Marco. Yes, I am using XLUtils to create the Word document. In the attachment, the Word document is created without problem. But in XLUtils paragr

There are some minor API changes. It is recommended to use the new version and especially for new projects, use XLUtils. You should reference XLUtils even if using jPOI directly: https://www.b4x./#content The old version is available here: https://www.b4x.com/android/forum/t...t-excel-xls-and-xlsx-w

Are you looking for a tool to create reports in B4J? XLUTILS is a POWERFUL, simple, and efficient library for building reports. After trying several times with JasperReports, I was still concerned about relying on third-party tools. XLUTILS works for both Excel and Word documents. The fact is, XLU

XLUtils includes a type named XLAddress. It makes it easy to switch between the 0 based indices and the addresses "names", as they appear in Excel. You can create an address in three ways: 'identical result: address = xl.AddressZero(0, 0) address = xl.AddressName("A1") address = xl.AddressOne("A",
link: - XLUtils v1.03 - Adds support for outlining and links: https://www.b4x.-hyperlinks-and-outlining-grouping.130413/ 112813
link: Internal packager: The b4xlib includes the required configuration to create a standalone package, however it will only work with the next version of B
link: - v1.10 - Styling implementation was rewritten. XLStyle.BoldFont renamed to FontBold. XLUtils goes a long way to reuse cell styles automatically. The

Effective and efficient solution. Erel, Thank you very much for your customary and continuous support to the community.
link: 135843 Private Sub AddComment (sheet As XLSheetWriter, address As XLAddress, CommentText As String) Dim factory As JavaObject = sheet.Workbook.j
link: Hello everyone. Is it possible to add comments to a specific cell? Something like that: 135812 Thanks in advance. Luis

There are some minor API changes. It is recommended to use the new version and for new projects use XLUtils. You should reference XLUtils even if using jPOI directly: https://www.b4x./#content The old version is available here: https://www.b4x.-supports-microsoft-excel-xls-and-xlsx-workbooks.57392/#
link: The migration from jPOI 4 to jPOI 5 should be simple. The "real" migration should be from jPOI directly to XLUtils. New projects should definitely us
link: Noted that when using a b4xlib which includes the Extra field which adds #PackagerProperty attributes automatically, eg. XLUtils.b4xlib and the projec

xlUtils has a the method: xl.GetWorkbookRangeNames may be you can see how are all this ranges named.
link: Dim result As XLReaderResult = XL.Reader.ReadRange(folder, name, sheetname & "!Data") '<<==== returns nothing I know what you might say, and that
link: You cannot directly get a non-unique named range. You can use this code: Private Sub GetSheetRange(Workbook As XLWorkbookWriter, SheetName As String,

Main concepts and reading MS Excel workbooks with XLUtils: https://www.b4x.-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 th
link: Great work.
link: Just in Time :)

Not sure. Maybe you can prepare several charts and fill the matching one at runtime.
link: No worries. That's another option, but I think I can live with the unused colours in the chart key.
link: I am using XLUtils (excellent library, thank you!) with a template xlsx file, adding data and populating a chart using the dynamic named ranges as exp

xlUtils.OpenExcel is windows only: 139123
link: There is no cmd.exe in MAC OS, you need to use whatever terminal name you are using on your Mac.
link: Yes i know this. As you read in first post i dont use cmd.exe but only code in first post.l. think I it comes from this line Wait For (xl.OpenExcel(no
link: CRASH ON MAC Dim nomefile As String = $"xxxxx${DateTime.Date(DateTime.Now)}.xlsx"$ wb.Save(File.DirApp, nomefile)

Powered by ColBERT