什么时候应该使用xlsm或xlsb格式? [英] When should the xlsm or xlsb formats be used?
问题描述
自Excel 2007以来,Microsoft将古典 .xls
格式分割成多种格式(特别是 .xlsx
, .xlsm
, .xlsb
)。我没有问题了解 .xlsx
格式的使用和目的,但我仍然在想知道我们是否应该使用 .xlsm
或$ code> .xlsb 格式创建一个包含一些VBA的文件。
Since Excel 2007, Microsoft has split the classical .xls
format to several formats (in particular, .xlsx
, .xlsm
, .xlsb
). I've got no problem to understand the use and purpose of .xlsx
format but I am still wondering whether we should use a .xlsm
or a .xlsb
format when creating a file containing some VBA.
当然可以例如:
- on Microsoft答案论坛
- on 微软博客指向上一个链接(但我已经解析直到没有找到
.xlsb
的引用<10> 页面 - 另一个论坛的主题
- on Microsoft answers forum
- on Microsoft blog that was pointed in the previous link (yet I've parsed until the 10th page without finding a ref to
.xlsb
) - this topic from another forum
我从最后一个链接中了解到的是 .xlsm
是某种XML格式,因此需要用于自定义功能区选项卡。
What I've understood from this last link is that .xlsm
is some kind of XML format and thus, needed for custom ribbon tab.
除了概念之间的格式( .xlsm
基于 XML VS .xlsb
是一个二进制文件)使用任何这个文件(除了功能区定制)之间有什么区别吗?
使用任何这些格式时,您曾见过任何真正的区别吗?
Beyond the conceptual difference between the format (.xlsm
is based on XML VS .xlsb
is a binary file), is there any practical difference when using any of this file (apart from the ribbon customization)?
Have you ever seen any real difference when using any of these formats?
推荐答案
他们都是类似的,因为它们本质上是包含实际文件组件的zip文件。只需用.zip替换扩展名并打开它们即可看到内容。与xlsb的区别似乎是组件不是基于XML的,而是二进制格式:据说这对于使用大文件是有益的。 http://blogs.msdn.com/b/dmahugh/archive/2006/ 08/22 / 712835.aspx
They're all similar in that they're essentially zip files containing the actual file components. You can see the contents just by replacing the extension with .zip and opening them up. The difference with xlsb seems to be that the components are not XML-based but are in a binary format: supposedly this is beneficial when working with large files. http://blogs.msdn.com/b/dmahugh/archive/2006/08/22/712835.aspx
这篇关于什么时候应该使用xlsm或xlsb格式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!