Excel: 2.20 BIFF (Binary File Format) Information

Last reviewed: April 3, 1997
Article ID: Q51057
2.20 MACINTOSH kbother

SUMMARY

BIFF (binary file format) is the file format in which Microsoft Excel 2.20 documents are saved to disk. A BIFF file is a complete description of a Microsoft Excel document. BIFF files consist of a specific sequence of variable-length records. There are many different types of BIFF records. For example, one record type describes a formula contained in a cell, another describes the size and location of a window into a document, and another describes the format of a picture.

Within a BIFF file, a certain type of record is repeated as necessary to complete the Microsoft Excel document description. For example, a spreadsheet row that contains 10 formulas will have 10 formula-type records in the BIFF file. Records within the BIFF file are arranged by type in a specific order.

MORE INFORMATION

This information was taken from the "Macro Tips" section on page 8 of the "Microsoft Excel Technical Reference for the Macintosh." The "Microsoft Excel Technical Reference for the Macintosh" is part of the Microsoft Excel Development Kit. To obtain this kit, call Microsoft End User Sales and Services at (800) 426-9400.


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.