xssf Questions
3
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...
Canaliculus asked 10/5, 2012 at 12:33
4
Solved
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...
Agio asked 5/8, 2015 at 23:12
2
Solved
I am trying to check if my excel file already exists. If it doesn't exists, I want to create a new one and if it exists I will delete it and create a new one. I wrote following program but I am get...
Factious asked 24/3, 2015 at 15:15
4
Solved
After opening and immediately closing an xlsx-file, created with Apache POI XSSF, I get prompted to save unsaved changes. As far as i can tell, this is happening because I am using formulas within ...
8
Solved
I have an xlsx file that I am reading with - Apache POI Library.
For example,
In some row, I have such cells values:
01-Sep-13 | 15136.00| Matt|......
My goal is:
Read all cells in the rows a...
Select asked 22/10, 2013 at 18:0
4
Solved
I'm trying to generate an excel file with some validations, I've read the poi dev guides for implementing it. During implementation, I got an exception (String literals in formulas can't be bigger ...
Apoenzyme asked 28/12, 2011 at 11:14
5
Solved
I've followed a simple guide to constructing a workbook using Apache POI XSSF. Following the same guide I was able to WRITE an Excel sheet, however when attempting to read from one, I'm receiving t...
Search asked 3/6, 2016 at 15:34
5
when i tried to create a workbook in normal java class it is creating but when i tried to run the same on servlet it is throwing exceptions
Normal java class
import java.io.File;
import java.io.F...
Peay asked 18/11, 2014 at 11:12
8
I just have a quick question about how to read in an xlsx file using the XSSF format from Apache.
Right now my code looks like this:
InputStream fs = new FileInputStream(filename); // (1)
XSSFWo...
Brecher asked 12/5, 2011 at 22:38
6
I'm trying to do work upgrading a Java application to handle .xlsx, using a newer POI library than our existing one. I'm having issues similar to those mentioned in the comments to the answer here:...
Broadbent asked 17/2, 2011 at 15:24
3
i'm working with apache poi and XLSX file. i use xssf classes to dynamically create a spreadsheet.
i'd like to set cell's style in a for loop, but it doesn't seem to work...here's my code :
for(in...
Galen asked 9/7, 2013 at 10:42
6
hi
i want to read xlsx file or xls file what ever it is. can XSSF support xls file ? or do i need to write the separate code for both kind of files ?
3
Solved
I'm trying to create a sheet in the Excel file using Apache POI.
Since it's Excel 2007, I'm using XSSF and I'm looking a for way to make a sheet right-to-left aligned.
In HSSF there is a method o...
Boyt asked 28/7, 2011 at 7:17
6
Solved
I need to convert csv to xls/xlsx in my project? How can i do that? Can anyone post me some examples? I want to do it with Apache poi. I also need to create a cell from java side.
Nannienanning asked 6/8, 2013 at 10:13
2
Solved
I tried to use setFillForegroundColor and setFillBackgroundColor to change the cell color of an excel file.
However, I failed and I really didn't know what the problem was. I've googled for many ...
4
Solved
I have a problem with Apache POI project.
I failed to use XSSF and HSSF in the "Same Java Class". Which jar should I download or which artifact should I get add into maven?
I want to handle both ...
Sahaptin asked 24/11, 2010 at 12:40
4
Solved
How do i get the index of the last column when reading a xlsx file using the Apache POI API?
There's a getLastRowNum method, but I can't find nothing related to the number of columns...
EDIT:
I'...
Fourdrinier asked 3/2, 2010 at 18:16
4
Solved
I'm using apache poi 3.7 and I need to put border to a range of cells or merged region.
how can I to apply border to a merged region when the sheet and workbook type is XSSF. In HSSF type I use Re...
Lallation asked 30/6, 2012 at 20:7
4
Solved
I try to parse an excel file into XML using apache poi xssf.
Now having a cell and not knowing what is in it I just want to get a String out of it.
But when I use
cell.getStringCellValue()
it th...
Dissert asked 3/2, 2014 at 21:45
2
Solved
Is there a way to determine if cell is a date?
I know about style.getDataFormatString() but that doesn't help me,
because I can't determine if is formating is for date or not.
Baumgardner asked 13/7, 2011 at 10:14
9
Solved
I need to auto-fit all rows in large (30k+ rows) xlsx file.
The following code via apache poi works on small files, but goes out with OutOfMemoryError on large ones:
Workbook workbook = WorkbookF...
Albigenses asked 4/2, 2011 at 12:5
3
Solved
I'm trying to use POI XSSF to evaluate some Excel formulas.
The values do not have to be saved, and I may have to calculate many formulas, so I'm trying to do it all in the same cell.
The problem...
Beheld asked 29/4, 2011 at 18:59
1
Solved
Good evening!
I've some trouble with apache poi v. 3.14, when I open the rendered xlsx with Libreoffice or Excel the style is not applied correctly.
I have this code:
class... {
private XSSFCell...
Rapeseed asked 4/4, 2017 at 16:8
1
Solved
In a Java method, I am using an Apache POI Sheet (from XSSFWorkbook). I can read the sheet name using getSheetName() method. But is there any way to find the sheet position in the workbook? I don't...
Gabriel asked 18/3, 2017 at 14:54
2
I found the following code to create a excel sheet from an existing template with formats and add data to it and save it to a new file
POIFSFileSystem fs = new POIFSFileSystem(
new FileInputStrea...
Bligh asked 25/1, 2012 at 23:33
1 Next >
© 2022 - 2024 — McMap. All rights reserved.