Questions tagged as 'apache-poi'

1
answer

Selenium / WebDriver code stops running after reading worksheet 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 file = new FileInputStream(new Fil...
asked by 08.05.2015 / 16:25
1
answer

Expand column Excel Apache POI

I created this class with the necessary code to simulate what I need. The need is to generate an Excel file with some data and that the cell (cell size) is enough to accommodate the text. On most posts I found the prompt to use:    sheet.auto...
asked by 04.01.2019 / 03:37
1
answer

Rename worksheet tab

I'm having trouble renaming the name of a tab in the Excell file. I am debugging and after it gives the set with the new name..I can see the new name changed in the execution but in practice the file itself is not changed. Someone? private sta...
asked by 28.02.2018 / 02:12
1
answer

Changing the list from an Apache excel import api

The system can generate an excel file where all the products in a serialized inventory are found. What I would like is that when this file is imported back all changes made to it are applied inside the system. Here's a minimal verifiable example...
asked by 06.12.2017 / 12:53
2
answers

Apache POI - Error opening file generated in MS Excel

Hello, I'm running some tests with Apache POI , version 3.15 , for .xlsx reporting using the sample code below, only to generate a file: package exemplousoapachepoi; import java.io.*; import org.apache.poi.xssf.usermodel.*; /** * * @...
asked by 23.11.2016 / 17:11
0
answers

Doubt Apache POI

How many drop-down lists does apache poi / excel 2016 support? I ask this, because I am working with a code that dynamically generates a spreadsheet with several dynamic lists, depending on the amount of data that is selected to be exported,...
asked by 13.12.2018 / 18:19
0
answers

Java - Apache POI for Excel

I need to extract information from an Excel (xls) file in Biff4 format, and Apache POI, although great for reading Excel 97-2003 files, does not help much with these older versions. What other library can I use to read these older files?    ...
asked by 05.06.2018 / 21:06
1
answer

Apache poi SpreadSheet

My code when generating a spreadsheet within an excel file it erases all the others, how do I make it create the spreadsheet in 2nd without deleting the others? My code: import java.io.*; import org.apache.poi.xssf.usermodel.*; public clas...
asked by 12.11.2017 / 15:48
1
answer

Java - Import Excel with combo and checkbox

I need to perform an excel spreadsheet import using java. Only the worksheet has selection values such as checkboxes and combos. As in the example below: Does anyone have an example java code that can retrieve these values, with Apache...
asked by 30.10.2017 / 20:46
0
answers

Excel 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 that have many lines. Exception in thr...
asked by 27.10.2016 / 01:55