• Sign In
 
  • MSDN Blogs
  • Microsoft Blog Images
  • More ...
Search
  • Advanced search options...
Tags
  • .NET
  • Altova
  • blogging
  • code samples
  • Codeplex
  • Custom XML
  • DII
  • DIS29500
  • ECMA-376
  • IBM
  • Java
  • Monarch
  • ODF
  • Office 2007
  • OpenXMLDeveloper.org
  • PHP
  • Redmond
  • SharePoint
  • System.IO.Packaging
  • TechEd
  • UOF
  • VSTO
  • Windows
  • WordprocessingML
  • workshops
Archives
Archives
  • January 2012 (1)
  • October 2011 (1)
  • July 2011 (2)
  • April 2011 (1)
  • March 2011 (3)
  • December 2010 (1)
  • August 2010 (1)
  • June 2010 (1)
  • May 2010 (1)
  • April 2010 (3)
  • March 2010 (1)
  • November 2009 (4)
  • October 2009 (1)
  • September 2009 (2)
  • July 2009 (2)
  • June 2009 (4)
  • May 2009 (5)
  • April 2009 (4)
  • March 2009 (4)
  • February 2009 (2)
  • January 2009 (4)
  • December 2008 (4)
  • November 2008 (3)
  • October 2008 (4)
  • September 2008 (3)
  • August 2008 (2)
  • July 2008 (5)
  • June 2008 (7)
  • May 2008 (5)
  • April 2008 (8)
  • March 2008 (14)
  • February 2008 (15)
  • January 2008 (13)
  • December 2007 (12)
  • November 2007 (5)
  • October 2007 (9)
  • September 2007 (6)
  • August 2007 (10)
  • July 2007 (9)
  • June 2007 (8)
  • May 2007 (12)
  • April 2007 (14)
  • March 2007 (12)
  • February 2007 (10)
  • January 2007 (17)
  • December 2006 (14)
  • November 2006 (10)
  • October 2006 (11)
  • September 2006 (12)
  • August 2006 (12)
  • July 2006 (12)
  • June 2006 (23)
  • May 2006 (14)
Common Tasks
  • Blog Home
  • Email Blog Author
  • About
  • RSS for comments
  • RSS for posts

New Binary File Format for Spreadsheets

Doug Mahugh - Office Interoperability
MSDN Blogs > Doug Mahugh > New Binary File Format for Spreadsheets

New Binary File Format for Spreadsheets

Doug Mahugh
22 Aug 2006 12:32 PM
  • Comments 3

With the upcoming release of the 2007 Microsoft Office System, much attention has been focused on the new Open XML file formats. But there is also another new file format for Excel spreadsheets that you'll want to take a look at if you're building unusually large or complex spreadsheets: the new XLSB binary format. Like Open XML, it's a full-fidelity file format that can store anything you can create in Excel, but the XLSB format is optimized for performance in ways that aren't possible with a pure XML format. The Excel team blog has some information about the various formats supported by Excel 2007.

The XLSB format (also sometimes referred to as BIFF12, as in "binary file format for Office 12") uses the same Open Packaging Convention used by the Open XML formats and XPS. So it's basically a ZIP container, and you can open it with any ZIP tool to see what's inside. But instead of .XML parts within the package, you'll find .BIN parts as shown to the right.

The format of .BIN parts will be thoroughly documented around the time of the Office 2007 release, but in the meantime there's no documentation available for the details of those binary components. In the last few weeks, however, software developer Stephane Rodriguez has embarked on an ambitious project to analyze the contents of .BIN parts and document them. He posted a great article yesterday entitled "Office 2007 .bin file format" that shows in great detail how some of the records are structured within the .BIN parts and how to work with them programmatically.

Stephane's article is very interesting reading for anyone who wants to get a head-start on understanding the new XLSB format before the official documentation is available. Thanks, Stephane!

  • 3 Comments
Excel
Comments
  • David Boschmans Weblog
    29 Aug 2006 12:20 PM
    A couple of months ago while I was attending TechEd US, I created quite a lot of Microsoft Office Excel...
  • Doug Mahugh
    30 Jun 2008 2:19 PM

    We have announced today the release of version 1.0 of technical documentation for a variety of protocols

  • Julien Chable
    30 Jun 2008 6:41 PM

    Doug Mahugh l’annonce aujourd’hui dans son post : la documentation technique des protocoles utilisé par

Page 1 of 1 (3 items)
  • © 2012 Microsoft Corporation.
  • Terms of Use
  • Trademarks
  • Privacy Statement
  • Report Abuse
  • 5.6.402.223