Questions tagged as 'apache-poi'

0
answers

Apache POI - Create document word [closed]

I would like to create a Microsoft Word document with programming, but I am having difficulty because I am a beginner in Java. I tried to start with the example of the following link " link ", but it did not work. I would fill a form in the brow...
asked by 24.08.2015 / 02:16
1
answer

Apache POI: how to tell if a spreadsheet has come to an end?

I'm developing a personal project, and for this I'm using Java along with the Apache POI to read XLS files, how can I tell if the spreadsheet has come to an end? Thank you!     
asked by 10.02.2018 / 04:23
1
answer

Java Poi does not download

I'm using the poi 3.15 library to generate excel on a web system, but I'm having a hard time downloading the file locally, but when I do it does nothing. I put it in the beginning like this: String caminho = System.getProperty("user.home");...
asked by 14.02.2017 / 22:11
1
answer

Get the time in from an excell worksheet

I'm using the POI api in Java. To get the time in an excel spreadsheet. In the excell spreadsheet the data is as text Image : publicvoidobterHora(){Cellhora=row.getCell(7);System.out.println("hora: "+hora); }    result: Dec 31, 1899...
asked by 05.10.2018 / 15:40
1
answer

I'm trying to read and write an XLS with Apache POI

I'm trying to make a class that le a .xls file and write another file in the same format, but my class gives the following error: org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x3E7265746E65633C, expected...
asked by 17.08.2018 / 15:06
1
answer

How to solve ioexception in xls file generated by jett?

I have a bean with method to generate report so done with jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo", fichasTecnicasMateriaPrimaResumo); try { Exc...
asked by 02.09.2017 / 22:40
1
answer

How to solve InvalidFormatException in xls file generated by jett?

I have a method to generate report made with jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo", fichasTecnicasMateriaPrimaResumo); try { InputStream inPath = Produt...
asked by 04.09.2017 / 17:53
0
answers

POI apache, Function if the value in a cell erases the entire line

I need a help with the use of POI apache, in my application I need to perform a query inside a worksheet, this query checks if there is a value in the worksheet, this query is ok, below I'll put the code simulating a value for make it easier to...
asked by 01.12.2015 / 21:48
0
answers

Reading cells with HLOOKUP formulas

I'm having a hard time evaluating a formula with the Apache Poi API in a cell that contains the formula HLOOKUP(B9,$AK$8:$AS$68,2,FALSE) . The same thing happens to be a file .xls or .xlsx . The excel sheet has a table...
asked by 17.10.2015 / 22:49
1
answer

Error getting time with row.getCell ()

I'm getting data from a worksheet in excel. public void Hora() Cell horaAgen = null; if(row.getCell(7) != null ){ horaAgen = row.getCell(7); System.out.println("hora: "+horaAgen); } } In the worksheet this: 9:00...
asked by 03.10.2018 / 20:18