I have created a Workbook/Excel in .xlsx format with Java using Apache POI API successfully. My code is as below that is created a file named “RiponAlWasim.xlsx” in D drive: When I tried to open “RiponAlWasim.xlsx” it was shown the file is corrupted. What’s the wrong? Answer It n…
Tag: excel
NoClassDefFoundError: UnsupportedFileFormatException while using apache poi to write to an excel file
I am trying to write to an excel(.xlsx) file using Apache poi, I included the apache poi dependencies in my pom.xml file. But I am getting the following exception in execution. The code and pom.xml is specified as follows. I am getting the exception in the following line. Code: Pom: Answer I think You’r…
Java apache POI java.lang.IllegalArgumentException: Position 21504 past the end of the file
I don’t know what am I doing wrong. I’m just reading and writing an Excel file, but always get this exception: java.lang.IllegalArgumentException: Position 21504 past the end of the file book.xls exists and has the number “1” in each cell from A1 to L50. Answer You are attempting to wr…
Unable to open XLSX file using Apache POI: NoClassDefFoundError
I’m having problems trying to open an XLSX file with Apache POI. My code: Exception thrown: Background: Running JDK 7 on MacOS X (Mavericks) Using NetBeans Imported jars (all from Apache POI binary distribution): poi-3.11-20141221.jar poi-ooxml-3.11-20141221.jar poi-ooxml-schemas-3.11-20141221.jar commo…
Format number with thousands separator in Excel using Apache POI
I want to format some number cells, with a comma as thousands separator. For example: I have the following code. What should I use as formatStr? Is there an easy way? Or do I have to detect the number of zeros in order to produce something like this #,###,###? Keep in mind that I’m dealing with numbers.…
Is there any way to create a Pivot Table in Excel using Apache POI?
I am currently working on the automation of Excel, and add such I have made a good use of the Apache POI library. As I have so much data stored in my excel workbook in various columns, that I’m trying to create a pivot table. Is there any way to create Pivot tables using POI ? My requirement is that
Apache POI – setting left/right print margin in Excel
Is that possible – with apache POI – to set left or right print margin for Excel sheet? The default margins are quite big. I cannot see neither setLeftMargin nor setRightMargin in XSSFPrintSetup, but only header and footer: Is there any kind friend that could help me a little? Answer The sheet mar…
Opening CSV with UTF-8 BOM via Excel
I create csv file with data by the means of java. And I faced the following well-known issue: the letters in Portuguese were displayed by the wrong way in Excel (when opening by double click). I solved this by UTF-16LE+BOM, but excel started to recognize tabs as columns separators instead of commas. So I look…
Using Apache POI how to read a specific excel column
I’m having a problem in excel while using Apache POI. I can read across rows, but sometimes I’m in a situation where I would like to read a particular column only. So is it possible to read any particular column like only the ‘A’ column only or the column ‘C’ only. I’…
Multiline text in Excel cells
I’m trying to write multiline text to excel cells. But when I open the document, I see only one line until I double-click it for editing, then it becomes two-lined. Why is it so? Thanks Answer You need to set the row height to accomodate two lines of text. You need to set the wrap text = true to get