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
-1
votes
1 answer

How do I read part of a Excel sheet, instead of the whole with Java?

I made a small application which reads in an Excel File. I connected it to my MySQL Database so that I can put the file into the database, which contains multiple tables. However, when implementing the values into the 'Orders' table, there is an…
Wout
  • 77
  • 6
-1
votes
2 answers

Reading Name value from excel and put in Map as ke value pair

I am uploading an excel file which has got two columns as Name & Value. I want to read the value from column Name and corresponding value for name and put in HashMap as key value pair.
ps007
  • 35
  • 6
-1
votes
1 answer

How to get merged cell (starting and ending addresses) of XSSF sheet apache POI?

related to java apache poi XSSF file reading i am confused in getting starting and ending indexes of a XSSF excel sheet kindly help me out as early as possible.
Sanjay Kumar
  • 11
  • 6
-1
votes
1 answer

How to import excel file with over 100k rows into MySQL database using java

I am getting error: Exception in thread "main" 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 Office Documents. You need to…
new learner
  • 3
  • 6
-1
votes
1 answer

Apache POI SXSSFSheet.getRow() returns null false positive

i'm new creating questions, so here is i go =D I have all my data stored in a SXSSFWorkbook and i'm trying to add some formula information before write and save the file, everything works ok but when i open the file there is some blank cells where…
Aosi
  • 111
  • 2
  • 7
-2
votes
1 answer

How to combine/merge sheets of two workbook into one workbook

I have two workbooks and each contains one sheet in it. Now I want to combine these two worksheets to one workbook as two sheets using POI and java . Can anyone tell me how to do this ?
Vipul Kumar
  • 11
  • 2
-2
votes
1 answer

Java - Need help getting row # of a specific value

i'm having a bit of trouble getting the row number of a specific string. Let's say I have a cell content = "HC" at row 9 and using the method findRow(sheet, "HC"). I should get a return value of 9, but right now the return is 0. The purpose of the…
user2874977
  • 79
  • 9
-2
votes
1 answer

getting error while reading the .xlsm file using apache POI

I'm trying to read a tempdoc.xlsm file when the following line is executed i get a IO error String fileName = request.getParameter("file"); XSSFWorkbook wb = new XSSFWorkbook(); wb = new XSSFWorkbook(new FileInputStream(fileName)); //error wen…
Kartik P
  • 71
  • 1
  • 1
  • 4
1 2 3
…
32
33