什么时候应该使用xlsm或xlsb格式? [英] When should the xlsm or xlsb formats be used?

查看:548
本文介绍了什么时候应该使用xlsm或xlsb格式?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

自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 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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆