Category "apache-poi"

How to read Excel cell having Date with Apache POI?

I'm using Apache POI 3.6, I want to read an excel file which has a date like this 8/23/1991. switch (cell.getCellType()) { ... ... case HSSFCell.CE

How can I set the complete page background for a Word page with Apache POI?

I have already searched all day today, but without success. First I created a new Word document and tried to set the background with //Blank Document XWPFD

Apache poi excel writer works in ide but not in fat jar? java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML str

The code works perfectly fine in IDE but not in normal .jar or in fat .jar? The program works perfectly fine otherwise. Also non-fat .jar doesn't work either. T

Java Excel/POJO Mapping in POI

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

Creating a checkbox in XLSX using Apache POI (Java)

I need to create an Excel checkbox in an XSSFSheet, but I have found no obvious classes/methods for doing so in the Java Apache POI library (4.0.1), nor any exa

How to use Low Level CTRPr & CTPPr Classes of latest Apache POI 5.2.2

I am upgrading to latest POI 5.2.2 from POI 3.14. Currently I am using below mentioned low level classes in Apace POI 3.14 which needs to be updated. i)CTRPr -

Why STOnOff Enums are removed in Apache 5.2.2 ? How to set X_0 & X_1 values?

I was using STOnOff.X_0 Enum to set value as 0(i.e false) for some elements in Apache POI 3.14 when constructing docx file. But now currently in latest version

How to fetch the conversation id from a .msg file using MAPIMessage

I'm trying to parse a .msg file. How do I get the conversation id? I'm using org.apache.poi.hsmf.MAPIMessage

Java ERROR: package X is declared in the unnamed module, but module Y does not read it

I am trying to make my javafx project to create an Excel file. One of the first steps for it would be XSSFWorkbook workbook = new XSSFWorkbook(); for which to w

Replacing an image using Apache POI is not working

I want to replace an existing image present in a slide of a PPT using Apache POI. But there is some difficulty to achieve this. Can anyone suggest how to approa

Apache POI: ${my_placeholder} is treated as three different runs

I have a .docx template with placeholders to be filled, such as ${programming_language}, ${education}, etc. The placeholder keywords must be easily distinguishe

Apache poi get table from text box

I'm using apache poi for iteration table in docx file. All works fine but if table in text box, my code don't see table - table.size() = 0 XWPFDocument doc =

Exception in thread "main" java.lang.NoSuchFieldError: Factory

Recently upgraded POI jar version from 3.17 to 5.1 and below code which was working in 3.x is now broken, ( jdk 1.8 ) Below are the set of Jar used below is my

How to horizontally merge XWPFTable using POI in Java

I want to horizontally merge columns of the row in a XWPFTable. I tried the answer in this link. How to merge cells (or apply colspan) using XWPFTable in POI

read excel by column name java POI

Good afternoon experts have a problem and I need to read the entire excel file by column name instead of its index,example: Column1 | Column2 | Column3 data1

Apache POI : delete the cached results from the file

I am trying to update an existing Excel file with many formulas. I can't use evaluate-function ( Excel-file contains a function not supported by Apache POI )

Store cell values to Object

I'm currently new to TestNG using java. I'm trying to read the values from an excel using poi apache 4.0 public static void read2dRowExcelFile2(String filePath)

Java Apache POI Excel save as PDF

How can I convert/save excel file to pdf? I'm using java play framework to generate some excel files and now the requirement changes to pdf. I don't want to rec

How to append to existing excel file using Java HSSF

I am still relatively new to Java and have cobbled together enough code that allows me to write my data out to a new excel file. However, I want it to write (a

Apache POI: Is it possible to use SXSSF without temporary files?

I'd like to use SXSSF (Streaming Usermodel API) from Apache POI. What I don't like is that it uses temporary files. Question: Is it possible in Apache POI to f