Stack Overflow
Stack Overflow

Questions tagged [apache-poi-4]

108 questions
0
votes
0 answers

How do I import Apache POI into my project for IntelliJ Idea?

I'm having trouble importing Apache POI into IntelliJ. Steps I took: Download the zip file under Source Distribution on https://poi.apache.org/download.html Click on File -> Project Structure -> Add New Project Library and add the zip file…
fj785
  • 133
  • 1
  • 10
0
votes
1 answer

Apache POI evaluating cells to ErrorEval [#REF!], but result workbook doesn't have any #REF! errors

I'm seeing unusual errors when evaluating cells in my workbook. For context, POI is being used to input values into an excel workbook using defined names. Excel then takes the inputs and does a variety of calculations and lookups to calculate a set…
Mike
  • 1
  • 2
0
votes
0 answers

How to create Watermark on .doc extension files using Java (Apache poi)

I am trying to create a watermark on .doc file and .docx file, I achieved the .docx extension watermarking using the apache-poi 4. But I Cannot rewrite the code for the .doc extension using the same approch. I tried to swap XWPFDocument with…
Sameesh
  • 315
  • 8
  • 18
0
votes
1 answer

Delay in writing values into a excel file that has a formula

Use case: I have a cost calculator implemented in excel. I have to insert a huge number of inputs to be entered into the input cells in a sheet and get the outputs from the same sheet. I have 3 excel sheets like that which are ~3MB in size. The…
Santhosh J
  • 1
  • 1
0
votes
0 answers

Java Apache POI 4.1 createPivotTable throwing "Cannot get a STRING value from a NUMERIC cell"

The problem originates when programmaticly creating pivot tables in .xslx file using the POI 4.1 library. Part of the upgrade of POI to 4.1 from 3.X is the removal of setting cell types. Thus in 4.X calling and setting of cell types is automatically…
SolutionFindingBrowser
  • 63
  • 8
0
votes
1 answer

How to remove future dates from stacked-bar chart

My current java code generates a stacked-bar chart using Apache POI 4.0.1 as shown in following diagram. I don't want to print a line for future dates (for example: In following chart, I don't want those zeros from 04/04 date); but I want those…
user10907060
0
votes
1 answer

Where did org.apache.poi.POIXMLDocument class go in version 4.0.1?

I have a Tomcat application that writes out spreadsheets and it was using the following JAR files: poi-3.16.jar poi-ooxml-3.16.jar poi-ooxml-schemas-3.16.jar I saw there was a version 4.0.1 of poi, and in looking at…
Mark Stewart
  • 2,046
  • 4
  • 22
  • 32
0
votes
2 answers

Plot multiple line charts in one excel sheet using Apache poi

I want to generate multiple chart with different series in a one excel sheet. However i can plot one chart with the following code but when i create second XSSFChart chart and XSSFClientAnchor anchor in the following code it fails to plot the chart…
sachin
  • 11
  • 4
0
votes
1 answer

NotOLE2FileException while reading xls file in apache poi 4.0.1

I am trying to read xls file in java using apache poi 4.0.1 Problem When i try to read the file, i fet following exception org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; Complete…
user7500403
0
votes
2 answers

How to set border by leaving one cell space along each side of entire data using Apache POI 4.0.1 and java

Currently, I'm able to set border beside the entire data (You can refer following image). Current output Code snippet // Code to draw Border at left side int rowstart = 3, rowend = 9; int col = 2; for (rowstart = 1; rowstart <=…
user10907060
0
votes
3 answers

Adding Apache POI 4.0.1 library not sufficient to use XSSFWorkbook

I am using the following tutorial to realize a Selenium Keyword Driven Framework : http://toolsqa.com/selenium-webdriver/keyword-driven-framework/set-excel-apache-poi/ For the part which ask to create an "util" package with an ExcelUtils class, I…
MAURY Hugo
  • 1
  • 1
  • 4
0
votes
0 answers

How to create a PowerPoint from scratch with Apache POI?

I can't seem to create a PPT like this. Any help is appreciated. Thanks. public static void main(String[] args) throws Exception{ File file=new File("/Users/Rakuten/Desktop/Test/example2.ppt"); try { FileOutputStream out= new…
C-flow
  • 19
  • 1
  • 3
0
votes
0 answers

Cannot resolve symbol "AbstractJExcelView"

I am writing a simple spring mvc application that writes the content in the xls format: public class ExcelBuilder extends AbstractJExcelView { @Override protected void buildExcelDocument(Map model, …
Arul Suju
  • 706
  • 1
  • 9
  • 21
0
votes
2 answers

Apache POI poi-ooxml:4.0.0 throws org.apache.poi.ooxml.POIXMLException

Context: Trying to open XLSX file using Apache POI's poi & poi-ooxml 4.0.0 version jar's Issue: The program throws an error as shown below. I find this error when I use version 4.0.0, as I was able to open excel file using version 3.17 or…
iCoder
  • 1,406
  • 6
  • 16
  • 35
0
votes
1 answer

poi 4 Shift rows giving errror but working for poi 3

Hi I have recently migrated to poi 4 from poi 3. I am shifting some rows in a table and inserting new rows. In my sheet there are some tables below the table into which I am inserting rows and I am updating the references for those tables. This code…
Amitesh Sinha
  • 1
  • 1
1 2 3 4 5 6
7
8