Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

biffview for .xlsb??

Status
Not open for further replies.

drdad5727

Programmer
Feb 28, 2005
28
US
Is there something like biffview for displaying the logical structure of .xlsb files?

Context: I've been asked to adapt some old code that can produce Excel spreadsheets to produce one with more than 64K rows. B-( Am I right that I have to write .xlsb? And that .xlsb doesn't look much like .xls?

Thanks!

 
>.xlsb doesn't look much like .xls?
Correct

>some old code that can produce
I'm guessing that this knew how to work with BIFF8. Somewhere inside xlsb files you will find BIFF, but it is BIFF12 which is significantly different ...

>to produce one with more than 64K rows
Excel 2007 sheets can have 1048576 rows, so maybe this won't be an issue
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top