Tagged Questions

1
vote
1answer
26 views

Refresh table JTable with data from a Excel file

I have a code to populate a JTable with data from a Excel File. The problem is that after set data to the JTable, I can´t to repaint the table with the new data. The information charging properly but ...
0
votes
0answers
8 views

Read using XSSF SAX and stream out data with SXSSF - POI

I have to read large sized xlsm with low memory footprint and since apache POI provides XSSF SAX, I should prefer using it. In the first sheet from existing xlsm parsed with SAX, i need to append some ...
1
vote
0answers
16 views

Excel cell values containing times are reported as 12 hour instead of 24 hour with JExcelApi

I need to read an Excel document and extract some cell values for further processing. I use JExcelAPI for this. This works well. We need to have a cell containing wall time as a four character ...
1
vote
1answer
30 views

How to update character set of a excel sheet through Java

I am extracting Russian characters from db and generating one excel sheet. But unfortunately in extracted excel sheet, I have to change the character set manually to "UNICODE(UTF-8)" , otherwise I ...
1
vote
0answers
20 views

Using Excel PERCENTILE function in Apache POI

I am using Apache POI 3.9 and I need to use the Excel formula PERCENTILE and evaluate the formula from within Java. The problem is that PERCENTILE is not supported. I get a ...
0
votes
2answers
42 views

POI cannot open a workbook that opens in Excel

When I try to open a .xlsx file in POI, I get an exception: java.lang.IllegalArgumentException: The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry. Is it really an excel file? ...
-2
votes
0answers
14 views

read and write using xlsb java [on hold]

Can you suggest if there are any java api for reading and writing xlsb. I came across licensed products like aspose.cells and smartxls. Is there any open source api that supports xlsb read and ...
0
votes
1answer
31 views

Reading template xlsm and writing large data to existing worksheet using SXSSF (POI)

I am able to read existing xlsm using XSSF and write data into worksheet using SXSSF. Finally output it as another xlsm with Outputstream. SXSSF is mentioned for writing xlsx in documentation Is it ...
0
votes
2answers
27 views

How to read paged rows from an excel or ods file?

We are using java and ODF Toolkit for reading rows from ods and excel files. The problem is that , even if you want to read only 1 row ,the whole document is loaded and the memory usage for a 50.000 ...
-1
votes
0answers
17 views

Create Architectural Diagram by capturing data from excel sheet or data eneterd in a table/feilds

I want to develop an Application in which i want to enter manually the impacted components.After the data is entered in the tables,feilds i want the Architectural diagram to be drawn automatically ...
0
votes
0answers
28 views

parsing xml excel files

I have an xml file contains data as excel representation. XML looks like below: <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook ...
0
votes
1answer
17 views

set column width in POI using BigGridDemo

I am using BigGridDemo example for POI since I have to generate excel with a million records. However, I am unable to set the column width in the template. ...
0
votes
2answers
27 views

formatting csv columns from java

I'm trying to write a csv-file from java. Works perfectly, but when I write e.g. 19,4 to csv-file, in excel it is shown as 19. April. So I put a \' in front of 19,4. Value is shown as number now, but ...
0
votes
0answers
23 views

how to read multisheet excel file using POI event API?

Since using POI User API can not read big excel file, I have to use POI Event API. However, I find it can not read multi sheet excel file rightly following this ...
-1
votes
1answer
24 views

Excel function xorc in java

I received a passwordsave made in a excel file. The passwords are "encrypted" with the Excel xorc function. Now I'm trying to build up the same in a java program. When I use the xor ^ function I ...

1 2 3 4 5 … 83
15 30 50 per page