jpoi

  1. MarcRB

    B4J Question animatedcounter error at 'jPOI to the rescue' example

    Hello, I'm trying to run the example 'jPOI to the rescue' because I will try to edit an existing MS Word doc / template file. During compiling I've got this error. Is there something not compatible with B4J v10 at Java 14. Or do I need some extra libs? The error says it is missing an image in...
  2. W

    B4J Code Snippet [XLUtils] [jPOI5] Detect/unhide hidden rows and columns in a worksheet

    Dim i As Int Dim theSheet As PoiSheet = ... Dim joTheSheet As JavaObject = theSheet Dim theSheetWriter As XLSheetWriter = ... Dim theSheetLastRow1 As Int = theSheet.LastRowNumber + 1 ' One-based index of the last row in the sheet Dim theSheetLastCol0 As Int = theSheet.GetRow(0).Cells.Size - 1 '...
  3. V

    B4J Question Error JPOI

    Hello everyone, I've been using B4J for a while, but now i run into problems. I wrote a module that reads MT940 files. That works very well so far. The problem is that I have to write the balances of the bank accounts into an existing EXCEL file. In the development environment it works...
  4. V

    German JPOI

    Hallo Alle Zusammen, bin zwar schon eine Zeitlang mit B4J zu Gange, aber das erste Mal auf Probleme gestoßen. Ich habe ein Modul geschrieben, dass MT940 Dateien ausliest. Das funktioniert soweit gut. Das Problem ist nun, dass ich die Salden der Bankkonten in eine existierende EXCEL-Datei...
  5. rtek1000

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

    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: https://www.b4x.com/android/forum/threads/xlutils-creating-ms-word-documents.131732/ Lib...
  6. KMatle

    B4J Tutorial [jPOI] Migration to version 5 experience (not a big thing)

    Just a short note how my experience was migrating to JPOI5. Not worth a tutorial - more a "all easy note" when you migrate an important app (like mine which is used by a company). I needed to remove the Packager property (The B4J-packager does it on it's own with the new version)...
  7. KMatle

    B4J Question Get display value via jPOI respecting locale

    I'm using this snippet to format an date cell to a real date: ub PoiGetFormattedCellValue(ExcelCell As PoiCell) As String Dim JOCell As JavaObject = ExcelCell Dim JODataFormatter As JavaObject Dim JOConditionalFormattingEvaluator As JavaObject Dim JOFormulaEvaluator As...
  8. C

    B4J Question jPOI crash when reading Workbook with wrong password

    Hi, Is there a way around the crash you get if you send wrong password during opening of a workbook with password ? Dim excel_wb As PoiWorkbook 'Read excel file excel_wb.InitializeExisting("", FileName, "password") If there is no password on the workbook then it opens fine. If the password...
  9. Programing Center

    B4J Question Error with JPOI Library

    Hi all, i user JPOI Library for do with excel in my app. when i run with b4j compiler all the thing are good and i don't have any error. when i compile with B4JPackager11, it makes crash and closed. what should i do? i find this error XML-BEANS compiled schema: Could not locate compiled schema...
  10. G

    B4J Question [Solved] OpenDocx get Text from Cells in MSWord Table

    I have a MS Word (docx) file with a table in it, 2 rows each with 3 cells. What I am trying to figure out is how to log the text of each cell. The table looks like this: The code (below) found on examples on this forum in this form is logging just the first cell in the first row. I can get...
  11. R

    Android Question aPOI, Adding pictures to sheet.

    Currently using the aPOI library to create xlsx files. I'm looking to add pictures onto the sheet and am not sure if the library supports this yet? I've looked into the XSSFWorkbook Function - AddPicture and AddPicture2 and can successfully create an xlsx with no errors, however no pictures are...
  12. Patent

    B4J Question jPOI for Tables in Word

    Dear Community, have a Question about missing depencies, see the little Example. Want to add a new Grid in a Table in a Word XDoc with jPOI, based on Erels https://www.b4x.com/android/forum/threads/jpoi-to-the-rescue.104082/#content. I copied all the .jars correctly. (All other things are...
  13. Patent

    B4J Question Get Access to opened MS-Word .docx

    Hi Guys, I'am editing an existing MS-Word Document on a disk with jPOI and it works well. Question is: is it possible to get the Data of an already opened (not saved) docx Document? With jPOI? or better with VBS? greets Patent
  14. KMatle

    B4J Question jPOI: Cell.Type "Date"?

    I have an Excel file with a date column. When I check and read the cell it returns NUMERIC as the cell type. Unfortunately there is no "date type" as the list shows. I logged these values: Log(Cell.CellType) Log(Cell.ValueDate) Log(Cell.Value) which created NUMERIC 40319 Fri May 21...
  15. Mark Read

    B4J Tutorial jPOI Library - Automatic column width.

    I was trying to get to grips with setting the column width in my Excel table. According to the help I tried: number of characters x 256, but all my columns dissappeared! Setting a value of 2560 gives a width in Excel of 9.29 or 70 Pixels, enough for 9 characters. 2560/9.29=275 which I...
  16. Mashiane

    B4J Question jPOI - How do I set and apply a filter and only get the rows affected?

    Hi there I want to be able to apply a filter on a particular column, let's say C and then apply a filter that excludes all blanks on that column and then the rows that I will access are only the ones applicable to that filter? Is that possible? Thanks!
  17. Mashiane

    B4J Question [SOLVED] jPOI how to return 'value' in formular cell?

    Hi SOLUTION: https://www.b4x.com/android/forum/threads/jpoi-get-a-cells-text-property-display-value.99907/#content I have a large worksheet with a lot of columns that have formulas. I want to read the worksheet and save the values to a database. I am able to read the rest of the data however...
  18. Mashiane

    B4J Tutorial jPOI to the rescue...my case today...

    Phew What a long day. This morning I receive a request to consolidate 1.1GB worth of data with 511 files, excel spreadsheet files from a particular tab that has about 120+ columns and I should use a similar template to write all the consolidated rows. Thanks to b4j and jPoi, following on Erels...
  19. T

    B4J Question jpoi : Using different cellstyle

    Hello, I recently discovered the jpoi library, and that seems wonderfull. I am facing a problem I really don't understand. I need to create cells using different style Sub Process_Globals Dim wb As PoiWorkbook Dim sheet1 As PoiSheet Dim Ter_number As String Dim Ter_Name As...
  20. K

    B4J Code Snippet jPOI Get A Cells Text Property (Display Value)

    The code is the equivalent of the VBA .Text property of a cell. It's the value displayed to the user including formatting such as thousands separators,decimal places and currency. It requires the latest version the jPOI library that wraps Apache POI 4.00. Sub...
Top