I have a Cell object, how can I get the name of that cell? Would like a function such as: String name = myCell.getName(); In Excel I have named it in the name box, so I don't want to get 'B4',...

What I want to do is ask the user if they want to create a new or select an existing Excel workbook. Selecting an existing file is no problem. However I get an error saying "Your file appears not t...

We are using Java 11 and compared to earlier versions of Java ,Java 11 have removed fonts folder from jre/lib. So our poi calls are failing at createsheet call,due to missing fontconfig. If we inst...

I am trying to write a huge excel file, my requirement allows me to write the row and forget, so i am using SXSSF which allows to keep only a few number of rows in memory and rest all are written t...

Java 8 here using Apache POI 4.1 to load Excel (XLSX) files into memory, and write lists of Java beans/POJOs back to new Excel files. To me, an Excel file (at least the ones I'm working with) is r...

I have a requirement Where I need to add data validation to an entire column rather than a specific cell. I went through the documentation of Apache poi and found the example below HSSFWorkbook wo...

How to make this table to auto-fit to document page width, when the column size increases, using apache-poi and aligning that table to center. This code generates a word Document extracting data f...

autoSizeColumn method of POI throws an exception that I didn't manage to resolve : "java.lang.ClassNotFoundException: Didn't find class "java.awt.font.FontRenderContext" on path:..." with this...

I have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read the file in java using POI, it tells that A2 is in numeric cell format. The problem...

When I am trying to update existing excel file I am encountering following error: Exception in thread "main" java.lang.NullPointerException at xltest.main(xltest.java:28) My code: FileInputStr...

I build a very large POI workbook, on my web server. Holding the entire workbook in memory , will not scale for multiple concurrent requests. Is there a way i can progressively write the workbook t...

I know that we can use Apache POI to parse an Excel file and get data. But I heard of a strange thing that excel file can be passed in a similar way we parse CSV (Like just read the file from file ...

Here's what I know so far: You use the method sheet.getNumMergedRegions() to get the number of merged regions in a particular sheet You loop through each count and use the method sheet.getMergedR...

I'm trying to use Apache POI Library in Eclipse RCP project. So I added poi, poi-ooxml and poi-ooxml-schemas to project, but still got an Exception java.lang.NoClassDefFoundError: org/apache/poi/ut...

I have upgraded from org.apache.poi-poi-ooxml-5.2.3 to org.apache.poi-poi-ooxml-5.2.4 due to Security Violation Threat in 5.2.3 Now, I am facing run time exception as java.lang.NoSuchMethodError Ex...

The below code is not working with Apache poi 3.16. Can someone provide with the correct solution, in my project there are some dependency for using only public void ConvertToPDF(String docPath, ...

I want to set the foreground color of a cell to a given color in hex code. For example, when I try to set it to red: style.setFillForegroundColor(new XSSFColor(Color.decode("#FF0000")).getIndexed(...

I am using Apache POI API to generate excel spreadsheet to output some data. The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text ...

I need to create a drop down list in excel file using Apache POI. and I am able to do that so But I am not able to make first item in drop down list as default Item. public class sd { /** * @pa...

I now have this problem. I want to write a excel file hold in this XSSFWorkbook (workbook) obj into a zip file eg(example.zip while contain this example.xlsx file) to a remote server. I have trie...

I am currently using Apache POI for Java to set formulas in cells. But after I run the program and open the Excel file that I created and processed, the cells with the formula include the formula ...

I need to add the apache poi to my project (I need hssf, ss and xssf). I downloaded a jar file from the internet but it does not contain xssf. I went to http://poi.apache.org/ and I downloaded this...

I am getting Number stored as text warning for the created excel file using POI. I am trying to display percentage. This question discusses the same, but it's for python. Can some one please sugges...

I am getting this error: org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Off...

I've written module that generates excel, and deployed it under Servicemix. In Windows environment everything is fine, but under Linux Servicemix unexpectedly crashes on following call: for (shor...