Excel 2007 : xlsx being saved as xlsb?

**ajmas** · 04-17-2010, 05:47 PM

I have written an application in Java that used POI to import Excel files, in either Office 2003 format or Office 2007 xlsx (OOXML) format. The issue I have run into is that some files that have the 'xlsx' extension appear to be in 'xlsb' format, this despite the user having specified the file to be saved in 'xlsx' format. I would like to understand why this is happening.

Can anyone tell me whether there are any reasons that would cause Excel 2007 to save the file in the binary format, rather than the OOXML format? I don't if it is any indication, but when trying to open the file in Office 2008 (Mac) I get told that the workbook contains unsupported "OLE DB query tables" content. I am reaching the conclusion that this is the binary format, because the file data does not start with "PK" characters and saving another file in xlsb shows the same general pattern.

**tony h** · 04-19-2010, 01:50 PM

just thought I would bump this

**ajmas** · 04-19-2010, 03:00 PM

Originally Posted by tony h

just thought I would bump this

You've run into the same issue?

**dibnado** · 08-27-2012, 10:57 AM

Originally Posted by ajmas

You've run into the same issue?

heyyy please can you send to me your java code...i need it for my project...thank youuuu

**arlu1201** · 08-27-2012, 11:00 AM

Dibnado,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.