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
I copied all the .jars correctly. (All other things are...
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?
or better with VBS?
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:
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...
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?
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...
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...
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
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.
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...
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 months. I am now certain i made the best choice to start working with b4j. After searching the forum i managed to put together this sub... no big...
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 to add the library into B4a , but I getting the error below :
UNEXPECTED TOP-LEVEL EXCEPTION:
com.android.dx.cf.iface.ParseException: bad class file...