Tagged Questions
0
votes
0answers
15 views
Finding Cell Location in Excel with Apache POI
I have cell objects that I am writing to from an array of information. What I am trying to do is have it that the program will handle any size of array so the cells are being filled in dynamically i ...
0
votes
1answer
33 views
Writing to excel file with apache poi in android project
I have problem whit getting my project to work i will
paste the java files and error log hopefully someone can give me a hint.
The app crash when button R.id.bskickaTidSc3 in TidSc3.java is clicked.
...
android
0
votes
2answers
33 views
Unable to set author and title using Apache POI
I am able to get and set the author and title name but unable to see it in output file. When i see details by clicking right and of my output file , it has old author and title name. please help me..
...
-1
votes
0answers
26 views
Does POI support array?
I need to use array in Java to store cell values read from excel file. I'm using POI 3.9. Does POI support array? if it does, how to use it? and if it doesn't, is there any alternative way to index ...
0
votes
0answers
29 views
workBook.write(fileoutputstream); writes empty excel file
I am trying to write a excel workbook to a file. Using Apache POI. I debug and found out my workbook have data . Once i write this workbook to FileOutputStream, it successfully writes without any ...
1
vote
2answers
43 views
How to get value from excel file?
I have an excel file like this :
I want to get both of the values by using a for-loop and then access them from outside the for-loop.
Both will be used as a value of xml element.
I have written a ...
0
votes
0answers
35 views
Apache POI autoSizeColumn Resizes Incorrectly
I'm using Apache POI in java to create an excel file. I fill in the data then try to autosize each column, however the sizes are always wrong (and I think consistent). The first two rows are always(?) ...
0
votes
0answers
36 views
Add series in excel chart programmatically
I am using POI integrating with my Rails application... I open a template .xlsx file and I populate the template.
In rvm.rb in initializer:
jars = Dir.glob("#{Rails.root}/lib/jars/*.jar").join(':')
...
4
votes
0answers
33 views
Embed files into Excel using Apache POI
I am exporting data to Excel file using Apache POI. In one weird requirement, I need to embed one file in the Excel using this POI. I have the file, and can be taken into streams or as byte arrays. ...
0
votes
0answers
18 views
apache poi DataFormatter on cell containing date
Good day.
I needed to get cell data from excel files as they look like and bumped to DataFormatter class of apache poi. This works like a charm except for cells containing date. Below is my code:
...
-1
votes
0answers
38 views
How to alter an existing cell font style in Apache POI
How can I obtain the existing font from a cell's style and update it in Apache POI?
I don't mean the typical case where you create a font like the following
// works
Font font = ...
0
votes
0answers
39 views
Apache Poi Inserting big image in an excel workbook
I am using Java and apache poi to add an image to an excel workbook. There is no problem with small sized images. When i try to add an image with a big size. The log shows illegal argument exception. ...
-2
votes
0answers
41 views
How to write 2D array to Excel (.xlsx) 2007 fromat in java [closed]
I am trying to write a 2D array to a excel file with .xlsx extension but not succeeded till yet..I tried Apache POI 3.9 but it only write .xls extension. Is there any other way ?
3
votes
2answers
1k views
How to set date as type date in excel with apache poi?
I am using apache poi 3.8 to create an excel file. This excel file needs to contain some dates.
I am trying to write a date to the excel file with as format the excel type "date". But i always get a ...
5
votes
4answers
3k views
Exception when writing to the xlsx document several times using apache poi 3.7
I am getting the following exception while trying to write an .xlsx file using Apache POI: org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
It seems the problem is using the method write ...
