Most voted "apache-poi" questions
Apache POI is a framework for the Java platform that allows you to work with reading and writing data in Microsoft Office documents.
Learn more…38 questions
Sort by count of
-
4
votes1
answer1025
viewsConvert PDF to DOC
It is possible to convert a PDF to a word document by keeping all formatting, alignments, fonts and tables in the converted document, using apache-poi or some other api?
-
3
votes1
answer695
viewsCannot get a text value from a Numeric Cell "Poi"
I am trying to consume data from a spreadsheet in excel, but always gives this error, already tried to format the spreadsheet for text and for number and even then the error persists. How do you fix…
-
3
votes1
answer622
viewsHssfworkbook - How to copy one spreadsheet to another?
I have a spreadsheet of excel I need to copy some data into another spreadsheet. This old spreadsheet is like a "base", I need to copy only the header and caption part (with the cell style, in…
-
2
votes1
answer314
viewsWhat to do to read a column in excel with very large numbers?
How to do for when reading an excel column whose number is too large and prevent it from being interpreted overflowing? In Excel the column is with the number 26468314801. How is a number he carries…
-
2
votes1
answer561
viewsFormula Excel - Apache POI
I created an excel file using the Apache Poi API, in it I set one of the cells with a formula, but when I open the file I need to "enter" the cell with the formula so that it prints the result in…
-
2
votes0
answers209
viewsProblem to read formulas using Apache POI
I’m creating a method to hide the elements that are zeroed out from an excel file, but the problem that it can’t catch the values when the column is a formula. How can I get these values? My code:…
-
2
votes2
answers614
viewsToggle the colors of a column using the java library - apache poi
I am using java with apache poi library to create an excel spreadsheet. I need to keep alternating colors, 1st column (which is department), between yellow and blue, when the data are different as…
-
2
votes1
answer129
viewsApache POI - How to put Hyperlink in an image in Excel?
This is the method I use to put images in Excel: public void insertIcons(String URL, Sheet sheet, int colBegin, int colEnd, int rowBegin, int rowEnd) { try { InputStream iconInput = new…
-
1
votes1
answer1512
viewsSelenium/Webdriver code to run after reading spreadsheet with Apache Poi
My test code using Selenium/Webdriver stops running after reading Apache Poi data. Can anyone tell me why? //poi WebElement searchbox = driver.findElement(By.name("simcard")); try { FileInputStream…
-
1
votes1
answer809
viewsError message after opening Excel file generated by an application
I have an application that reads a file xml, takes the data and passes to a file in the format xls. But when I open the file that was Erardo appears the following message: Would someone explain to…
-
1
votes0
answers421
viewsApache POI - Create word document
I would like to create Microsoft Word document with programming, but I’m having difficulty, because I’m beginner in Java. I tried to start with the following link example…
apache-poiasked 8 years, 10 months ago Pedro Flum 11 -
1
votes2
answers294
viewsJava error inserting picture into spreadsheet. Apache Poi
I am trying to insert an image into a sheet using Apache POI , but I am getting the following error : 03-03 20:21:50.898: E/SELinux(28413): selinux_android_seapp_context_reload: Error reading…
-
1
votes1
answer153
viewsJava - Import Excel with combo and checkbox
I need to import an excel spreadsheet using java. Only the spreadsheet has selection values like checkbox lists and combos. As in the example below: Someone has an example of java code that can…
-
1
votes1
answer108
viewsApache poi Spreadsheet
My code when generating a spreadsheet inside an excel file it erases all the others, as I do for it to create the spreadsheet in 2° without it deleting the others? My code: import java.io.*; import…
-
1
votes0
answers510
viewsExcel with more than 300 thousand lines
Good evening, I have a problem with Excel. The spreadsheet has more than 300 thousand lines and when I run the application with 30 thousand lines I have no problem. The error only happens with files…
-
1
votes2
answers899
viewsApache POI - Error opening file generated in MS Excel
Hello, I’m running some tests with Apache POI, version 3.15, for reporting purposes .xlsx, using the example code below, only to generate a file: package exemplousoapachepoi; import java.io.*;…
-
1
votes1
answer98
viewsList change from an Apache poi excel import
The system can generate an excel file where all the products of a serialized stock are found. What I would like is that when this file is imported back that all changes made to it are applied within…
-
1
votes0
answers94
viewsJava - Apache POI for Excel
I need to extract the information from an Excel file (xls) in Biff4 format, and Apache POI, although it is great for reading Excel files of version 97-2003, does not help much with these older…
-
1
votes0
answers39
viewsInsert Summary into Word document using apache poi library
I am creating an android application of answer of forms, at the end of the questionnaire I am creating a file . docx using the apache poi library, the document is already written successfully,…
-
1
votes1
answer254
viewsTake text from excel cell
I have an application that reads Excel data, but I can only read the value of the cell and I can’t read what the cell is literally showing. For example: Here I select where the spreadsheet is and…
-
1
votes1
answer188
viewsRename worksheet tab
I’m having trouble renaming an Excell file tab. I’m debugging and after it gives the set the new name.. i can see the new name changed in the execution but in practice the file itself is not…
-
1
votes0
answers57
viewsDoubt Apache POI
How many drop-down lists apache poi/excel 2016 supports ? I ask this, because I am working with a code that dynamically generates a spreadsheet with several dynamic lists, which depending on the…
-
1
votes1
answer646
viewsI’m trying to read and write an XLS with Apache POI
I am trying to make a class that reads a file. xls and writes another file in the same format, but my class gives the following error: org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid…
-
1
votes1
answer957
viewsExpand Apache POI Excel column
I created this class with the code necessary to simulate what I need. The need is to generate an Excel file with some data and, that the cell ( the size of the ballot) is enough to accommodate the…
-
0
votes0
answers362
viewsReading 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…
-
0
votes0
answers683
viewsPOI apache, Function if you have the value in a blank cell
I need a little help with the use of apache POI, in my application I need to perform a query inside a spreadsheet, this query checks if there is a value in the spreadsheet, this query is ok, below I…
-
0
votes1
answer892
viewsApache POI: how to know if a spreadsheet has come to an end?
I am developing a personal project, and for this I am using Java along with Apache POI to read XLS files, how can I know if the spreadsheet has reached its end? Thanks in advance!
-
0
votes1
answer50
viewsGet the time on from an Excell spreadsheet
I am using the POI api in Java. To get the time in an excel spreadsheet. In the Excell worksheet the given is as text image: public void obterHora(){ Cell hora = row.getCell(7);…
-
0
votes1
answer219
viewsJava Poi does not download
I’m using the poi 3.15 library to generate excel on a web system, but I’m having trouble downloading the file, locally it works but when I publish it does nothing. I put it at the beginning like…
-
0
votes1
answer10
viewsHow to resolve ioexception in xls file generated by Jett?
Guys I have a bean with way to generate report so done with Jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo",…
-
0
votes1
answer44
viewsHow to resolve Invalidformatexception in xls file generated by Jett?
I have a way of generating reports done with Jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo",…
-
0
votes1
answer172
viewsHow to insert header and footer in documeto docx using Apache Poi
I am trying to insert header and footer in an automatically generated docx file, the image loads but it is not visible in the file. Just follow my code: XWPFDocument doc = new XWPFDocument();…
-
0
votes1
answer45
viewsChange the color of only one of the bars/columns of the graph generated in PPTX - Apache Poi
I’m working with the Apache Poi v4.1.2 in the Java for file generation .pptx, slide display on PowerPoint. I’m basically using the Apache Poi to generate slides with graphics, so far so good, I am…
-
0
votes0
answers11
viewsCapture only one line of an Excel spreadsheet with POI
Hello, everybody! I have a system that needs to validate the type of cell contents of a spreadsheet line. I wish it was just a line, to avoid going through all the lines in the file, to avoid…
-
0
votes0
answers17
viewsPOI ( Execel column reading is different)
Boys, good afternoon, boys ! I have a column in Execel that contains the value : Import used : import org.apache.poi.ss.usermodel.Cell; When I read it like this : spreadsheet.getRow(i). getCell(1).…
-
-1
votes1
answer49
viewsError obtaining time with Row.getCell()
I’m getting data from a spreadsheet in excel. public void Hora() Cell horaAgen = null; if(row.getCell(7) != null ){ horaAgen = row.getCell(7); System.out.println("hora: "+horaAgen); } } On the…
-
-2
votes1
answer116
viewsConvert Cell to String type in Apache POI
How can I convert a guy Cell for String ? String datateste = row.getCell(5);
-
-2
votes2
answers28
viewsApache POI is separating the Runs in the wrong place
I’m learning to work on Apache POI to work with docx documents and I’m trying to do some checks on an existing document: XWPFDocument doc = new…