GeeCON Prague 2014*
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
Author

Creating Workbook with .xlsx file

mamata surapaneni
Greenhorn

Joined: Jul 24, 2007
Posts: 10
Hi,

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.

Thanks,
Mamata
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42047
    
  64
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.


Ping & DNS - my free Android networking tools app
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42047
    
  64
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.
 
GeeCON Prague 2014
 
subject: Creating Workbook with .xlsx file