permaculture playing cards
The moose likes Other Open Source Projects and the fly likes Creating Workbook with .xlsx file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Reply locked New topic

Creating Workbook with .xlsx file

mamata surapaneni

Joined: Jul 24, 2007
Posts: 10

I am using the code

file = new File(fileName);
workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);

The code is working fine for .xls (Excel 2003) and not working for .xlsx ( Excel2007). Is that anythin extra need for .xlsx files.Please help me.

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
Currently, Apache POI supports the Office binary formats, not the Office Open XML formats. See the paragraph "Office Open XML Support" here for further information.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
Please do not post the same question to multiple forums: CarefullyChooseOneForum. Having multiple redundant conversations wastes people's time.

Let's continue the discussion in this duplicate thread.
I agree. Here's the link:
subject: Creating Workbook with .xlsx file
It's not a secret anymore!