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
2
votes
2 answers

How to get the cell unformatted value in POI XSSF event model?

cell A1 has the formula "=A2" and is formatted to show 1 decimal point cell A2 has the value 4.23 cell A1 shows 4.2 (formatted display value) cell A2 shows 4.23 (formatted display value) My XSSF eventmodel sheetContentHandler class implements…
thedrs
  • 1,412
  • 12
  • 29
2
votes
1 answer

Excel Cell Style issue

I am using below code to get date value from XLSX file. This is working absolutely fine for some XLSX files, but it is not giving exact date format which is in XLSX file. This issue is for some files. For example, I have date like this 21/01/2016…
Sonal
  • 262
  • 5
  • 22
2
votes
1 answer

Java Memory issue using Apache.POI to read write Excel

I am trying to read excel file...make some changes...save to new file. I have created small form with button...On pressing button.. It will load Excel file and load all data to Array list of class I have created. It will loop through Array list and…
Muhammad Sadiq
  • 103
  • 3
  • 8
2
votes
0 answers

Apache POI XSSFPicture.resize() too slow for multiple images in a XSSFSheet

I have to create an XSSF sheet with multiple copies of the same 2 images over 10k times. Currently I call the following block in a loop to set the image into its various places using ClientAnchor. ClientAnchor anchor = helper.createClientAnchor();…
amankapur91
  • 484
  • 4
  • 15
2
votes
1 answer

How to set Jasper to use XSSF?

In a existing system already use jasper 5.0 and as I know it use poi HSSF to generate xls data, but now as the application grow up, the report have a problem with a big count transaction to generate. I have search for the solution and found POI…
Angripa
  • 159
  • 2
  • 4
  • 14
2
votes
1 answer

How to count rows and Columns of excel sheet in Java

Is there a way to count the number of rows and columns in an excel table in Java? I am using XSSF workbook to import and parse the data into the program. . There are no empty cells until after the last row or column. For example if there was a…
Tim R
  • 514
  • 1
  • 8
  • 24
2
votes
1 answer

Unable to simply create Theme in new ApachePOI XSSFWorkbook

Is it is possible to create empty Theme if I create XSSFWorkbook by constructor XSSFWorkbook()? I can create new Theme, but not completely. I can create two entries in files content_types.xml and /xl/_rels/workbook.xml.rels: XSSFWorkbook…
Piotr
  • 23
  • 3
2
votes
2 answers

Merge cells having the same value in excel Java

I generated excel document from Postgres database, using POI API. The first column "Ordre" have many same values. However i want to merge this cells having the same values. I want follow this algorithm : loop through the field "ordre" put a…
Saa El
  • 21
  • 1
  • 3
2
votes
1 answer

Apache poi XSSF Creating Excel Files - Create returns empty file with format or file extension not valid?

The relevant part of the Controller class: @RequestMapping(value = "/DBCompare/download", method = RequestMethod.GET) public void handleDownloadDBCompareReportGet(HttpServletResponse response, Model…
pluralton
  • 65
  • 1
  • 11
2
votes
1 answer

Apache POI: comments in empty cells in an empty row

I have a big problem with Apache POI. A B C D 1 text text text text 2 comment 3 text text text text In this example row 2 is empty, C2 has no text, but a comment. If I want to…
Smoothi
  • 283
  • 1
  • 3
  • 15
2
votes
0 answers

Apache POI: Diagonal border in XSSFWorkbook

I found the XSSFCellBorder to support diagonal border styles as well and I want to use them, but I haven't found any way to get a XSSFCellBorder from an XSSFCellStyle so I can apply them in the usual way. How can I set the diagonal border for a…
AlexR
  • 2,412
  • 16
  • 26
2
votes
1 answer

Is it possible to set the "spans" attribute of a row in the "worksheet#.xml" using Apache POI

this is a "worksheet#.xml" inside a .xlsx file I created with MS Office Excel.
sEbR
  • 33
  • 3
2
votes
1 answer

can not read last column data from excel file

I am reading data from Excel file for the salary generation in that column is empcode, emp_name,working_days,overtime_hour when reading data from excel file i am read only first three column means i am read only working days i can not read…
fanky
  • 515
  • 4
  • 14
2
votes
1 answer

when creating an excel file from java do i need office installed on my system

When creating an excel file from java do i need office installed on my system? I think java using its API must be able to create the .xls or .xlsx file. We will just not be able to open it? If anyone know the answer please let me know.
Vikram
  • 21
  • 6
2
votes
1 answer

Can I create a freeze pane and a split pane in the same sheet at once using Apache POI?

I am using Apache POI XSSF and HSSF API. If I do this, it only freezes the pane (no split): sheet1.createSplitPane(8000, 5000, 0, 0, Sheet.PANE_LOWER_RIGHT); sheet1.createFreezePane(0, 1); and if I do this, it only splits the pane (no…
Tejus Prasad
  • 6,322
  • 7
  • 47
  • 75
1 2 3
…
32 33