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"...
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...
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...
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...
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...
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...
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...
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...
This is my first code snippet, for exporting a tableview to an excel. ITs my first serious attempt to work with b4j after trying various tools for...
I tried JExcel Api , but Jexcel can only output max row of 65000 . Jpoi can support more than 65000 row ? Can I use this JPOI in B4a ? I trying...
