Fichiers binaires xlsb

Le
pascal58
Bonjour à tous,
Les fichiers binaires xlsb sont plus petits et plus rapides à
l'ouverture.
Néanmoins, il y a-t-il un ou des inconvénients à son utilisation ?

Merci,
Pascal
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
MichD
Le #24374751
Bonjour,

Émanant de cette adresse : http://msdn.microsoft.com/en-us/library/ff726673.aspx#FileFormatsPerfSize

'----------------------------------
Excel File Formats Performance and Size


Starting in Excel 2007, Excel contains a wide variety of file formats compared to earlier versions. Ignoring the Macro,
Template, Add-in, PDF, and XPS file format variations, there are three main formats: XLS, XLSB, and XLSX.

XLS Format
The XLS format is the same format as earlier versions. When you use this format, you are restricted to 256 columns and 65,536
rows. When you save an Excel 2007 or Excel 2010 workbook in XLS format, Excel runs a compatibility check. File size is almost
the same as earlier versions (some additional information may be stored), and performance is slightly slower than earlier
versions. Any multi-threaded optimization Excel does with respect to cell calculation order is not saved in the XLS format.
Therefore, calculation of a workbook can be slower after saving the workbook in the XLS format, closing, and re-opening the
workbook.

XLSB Format
XLSB is the binary format starting in Excel 2007. It is structured as a compressed folder that contains a large number of
binary files. It is much more compact than the XLS format, but the amount of compression much depends on the contents of the
workbook. For example, ten workbooks show a size reduction factor ranging from two to eight with an average reduction factor
of four. Starting in Excel 2007, opening and saving performance is only slightly slower than the XLS format.

XLSX Format
XLSX is the XML format starting in Excel 2007, and is the default format starting in Excel 2007. The XLSX format is a
compressed folder that contains a large number of XML files (if you change the file name extension to .zip, you can open the
compressed folder and examine its contents). Typically, the XLSX format creates larger files than the XLSB format (1.5 times
larger on average), but they are still significantly smaller than the XLS files. You should expect opening and saving times
to be slightly longer than for XLSB files


Un peu de lecture ici :
http://blogs.msdn.com/b/davbosch/archive/2006/08/29/730183.aspx

Un commentaire lu sur le web :
These files are typically smaller than .xlsx files with the same contents (maybe 2/3 the size) and typically load faster than
an .xlsx file. If users have a performance problem with their huge, calculation-dense workbook, one of the easiest things you
can recommend is "try saving it as an .xlsb."



MichD
------------------------------------------
pascal58
Le #24387351
On 3 avr, 21:40, "MichD"
Bonjour,

Émanant de cette adresse :http://msdn.microsoft.com/en-us/library/ff726 673.aspx#FileFormatsPerf...

'----------------------------------
Excel File Formats Performance and Size

Starting in Excel 2007, Excel contains a wide variety of file formats com pared to earlier versions. Ignoring the Macro,
Template, Add-in, PDF, and XPS file format variations, there are three ma in formats: XLS, XLSB, and XLSX.

XLS Format
The XLS format is the same format as earlier versions. When you use this format, you are restricted to 256 columns and 65,536
rows. When you save an Excel 2007 or Excel 2010 workbook in XLS format, E xcel runs a compatibility check. File size is almost
the same as earlier versions (some additional information may be stored), and performance is slightly slower than earlier
versions. Any multi-threaded optimization Excel does with respect to cell calculation order is not saved in the XLS format.
Therefore, calculation of a workbook can be slower after saving the workb ook in the XLS format, closing, and re-opening the
workbook.

XLSB Format
XLSB is the binary format starting in Excel 2007. It is structured as a c ompressed folder that contains a large number of
binary files. It is much more compact than the XLS format, but the amount of compression much depends on the contents of the
workbook. For example, ten workbooks show a size reduction factor ranging from two to eight with an average reduction factor
of four. Starting in Excel 2007, opening and saving performance is only s lightly slower than the XLS format.

XLSX Format
XLSX is the XML format starting in Excel 2007, and is the default format starting in Excel 2007. The XLSX format is a
compressed folder that contains a large number of XML files (if you chang e the file name extension to .zip, you can open the
compressed folder and examine its contents). Typically, the XLSX format c reates larger files than the XLSB format (1.5 times
larger on average), but they are still significantly smaller than the XLS files. You should expect opening and saving times
to be slightly longer than for XLSB files

Un peu de lecture ici :http://blogs.msdn.com/b/davbosch/archive/2006/08/2 9/730183.aspx

Un commentaire lu sur le web :
These files are typically smaller than .xlsx files with the same contents (maybe 2/3 the size) and typically load faster than
an .xlsx file. If users have a performance problem with their huge, calcu lation-dense workbook, one of the easiest things you
can recommend is "try saving it as an .xlsb."

MichD
------------------------------------------



Bonjour MichD,
Tes lectures furent fort intéressantes, une fois traduites :-)
Et donc on peut même en déduire que le format binaire est
recommandable ?

Merci et bien à toi,
Pascal
Publicité
Poster une réponse
Anonyme