jpoi

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

Hi All, I am making a Quiz Game in which Questions taken from Excel sheet...& displays in two label in two language...One is english and another is my language Hindi... Using Jpoi library I read the excel sheet sucessfully but English is ok....Hindi fonts are not properly displyed...I...