Bonjour =E0 tous,
Les fichiers binaires xlsb sont plus petits et plus rapides =E0
l'ouverture.
N=E9anmoins, il y a-t-il un ou des inconv=E9nients =E0 son utilisation ?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
MichD
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 ------------------------------------------
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."
É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
On 3 avr, 21:40, "MichD" wrote:
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
On 3 avr, 21:40, "MichD" <michde...@hotmail.com> wrote:
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 ?
É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 ?
