Stack Overflow
Stack Overflow

Questions tagged [xssf]

XSSF provides Java APIs to read / write Microsoft Excel 2007 (OOXML format .xlsx) files. This tag should be used for questions about accessing Excel 2007 files from Java applications. XSSF is managed under the Apache POI Project. Other tag to consider: [tag:apache-poi]

HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

If you are starting with Apache POI, you may find the Busy Developer's link very useful: http://poi.apache.org/spreadsheet/quick-guide.html

Useful links

488 questions
0
votes
1 answer

NoClassDefFoundError while using api XSSF

I want to read an xlsx file using api XSSF. For that I downloaded poi-3.6 api and then did set the correct classpath but then too when I run my program I get an Exception as in thread "main" java.lang.NoClassDefFoundError:…
Supereme
  • 2,379
  • 12
  • 46
  • 67
0
votes
1 answer

Issues and gotchas with new POI 3.6 API (XSSF) working with Excel 2007 workbooks

I just started using the new POI 3.6 http://poi.apache.org XSSF which was released in December 2009. The updated API provides support for reading and writing in the OOXML spreadsheet format (.xslx) with Java. So far I've been pretty impressed with…
James
  • 12,636
  • 12
  • 67
  • 104
0
votes
0 answers

Memory Leak Issue in Apache POI 3.9 version

I have used Apache POI for creating .xlsx files. I tried with POI 3.8 version but it has the memory leakage issue(It creates temp files and take large amount of time to create excel file). Now I am using POI 3.9 version, but it also shows the memory…
CTcreations
  • 95
  • 1
  • 7
0
votes
0 answers

Apache poi. Formula evalution. evaluteAll vs setForceFormulaRecalculation

[better quality]:. http://imageshack.us/photo/my-images/51/v5cg.png/ Problem: i use formulas in my workBook.xlsx. Depending on the circumstances i change value (3,3). At this example i changed 10 to 20. And after that i want to calculate the…
Eldar
  • 153
  • 5
  • 13
0
votes
1 answer

Xssf merging Queries

I have this piece of code::: XSSFWorkbook workbook1=new XSSFWorkbook(inputStream); XSSFSheet sheet = workbook1.getSheetAt(1); sheet.addMergedRegion(new CellRangeAddress(28,28,5,9)); Now , i have few straight…
user2759877
  • 1
  • 1
0
votes
3 answers

XSSF. NullPointerException

private void cleaner(Integer columnsCount, Integer rowsCount, Object object){ int firstColumn=0; int firstRow=0; XSSFSheet sheet = workBook.getSheetAt(0); for (int lineId=firstRow;lineId
Eldar
  • 153
  • 5
  • 13
0
votes
1 answer

Apache-poi. XSSF. Workbook

I already work with XLS, but today i'm trying new one - xlsx. For XLS I needed only one library, in contrast to XLSX (four libraries). Also I get the whole package errors. Why is this happening? Main: public class Start { public static void…
Eldar
  • 153
  • 5
  • 13
0
votes
0 answers

export to *.xlsx file which is in *.zip

I was googling this question, but couldn't find any solution to my problem. Sorry, if it is duplicate. I am building *.xlsx file in my application. I want user after clicking the button at my Web GUI to have the file downloaded. I wrote smth like…
edward_wong
  • 442
  • 7
  • 21
0
votes
0 answers

why does my program adds blank spaces automatically?

I created a csv file(| delimited) which contains some data but few rows are created automatically at the end of every row and column. There are only 4 rows in the excel file but when it converts to csv it shows…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

Getting wrong output in xls/xlsx while converting it from csv

So i've changed a csv to xls/xlsx but i'm getting one character per cell. I've used pipe(|) as a delimiter in my csv. Here is one line from the…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

Date representation in csv file is to be changed

When i convert xls/xlsx to csv than in that csv file date is coming as Fri Nov 11 00:00:00 IST 1988. But i need yyyy-mm-dd format. What can i do in the following code: [code] row = (HSSFRow) rowIterator.next(); // For each…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

Where does the file goes when the user clicks on upload button from the jsp?

When a user clicks on the upload button after selecting a file from their computer, where does that file goes? Can i use that file's content if a temp file is made? How can i do that? I need my user to upload a file and then validation is performed…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

get complete address of a file

i need to get the full address of a file which needs to be uploaded by the user using browse button. i tried getAbsolutePath, getAbsoluteFile, getCanonicalPath but they all are giving tomcat/bin location. i need the full path of the file which is to…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

excel to postgresql using spring

I'm creating a web app which requires uploading of excel files from the user and the data from that file will get stored in the database. I'm using postgre sql and spring, poi api. I have a program which extracts data from xls and xlsx and displays…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
2 answers

Reading XLSX throws OutOfMemoryError PermGen

At the start of my readXlsx method this line throws a PermGen Error: XSSFWorkbook wb = new XSSFWorkbook(OPCPackage.open(is)); where is is an InputStream for an Excel file sent over HTTP Post. Trying to upload a few times with this error caused…
sjallamander
  • 439
  • 2
  • 6
  • 20
1 2 3
…
32 33