HTML文件不是Excel文件,对吧?

时间:2022-11-19 23:17:06

we use an application that has an "export to excel" feature that doesn't work on PC's that done have outlook express installed.

我们使用的应用程序具有“导出到excel”功能,该功能在安装了Outlook Express的PC上不起作用。

i know, you're thinking "WTF does outlook express have to do with excel files?"

我知道,你在想“WTF的Outlook Express是否与excel文件有关?”

i asked the same thing, and here's what i found:

我问了同样的事情,这就是我发现的:

  • the file being generated is actually one of those Microsoft Single File Web Pages (.mht) and NOT an excel file
  • 生成的文件实际上是Microsoft单文件网页(.mht)之一,而不是excel文件
  • you need to have outlook express installed to actually view a .mht file.
  • 您需要安装Outlook Express才能实际查看.mht文件。

i've explained to their support people that just because you can slap a .xls on a file and excel will open it does not mean its an excel file, and does not mean that this is the right way to do it.

我向他们的支持人员解释说,仅仅因为你可以在文件上打一个.xls而excel会打开它并不意味着它是一个excel文件,并不意味着这是正确的方法。

how would you explain that this is not proper?

你怎么解释这不合适?

4 个解决方案

#1


3  

Many people (especially managers) confuse Excel files with reporting files. In my opinion, a file is only qualified as an Excel file if it meets all of these conditions:

许多人(尤其是经理)将Excel文件与报告文件混淆。在我看来,如果文件满足所有这些条件,则它只被限定为Excel文件:

  1. Is a spreadsheet formatted in one of the many Microsoft Excel formats.
  2. 是一种以多种Microsoft Excel格式之一格式化的电子表格。
  3. Can be opened in the most recent version of Microsoft Excel.
  4. 可以在最新版本的Microsoft Excel中打开。
  5. Is editable in Microsoft Excel.
  6. 可在Microsoft Excel中编辑。

In your case, I'm guessing only condition #3 is met, so it's no Excel file. But your support people may still call it a reporting file.

在你的情况下,我猜测只满足条件#3,所以它不是Excel文件。但您的支持人员仍可将其称为报告文件。

#2


3  

If a clean Windows image with only Excel installed can't open it, then it isn't in Excel format. Period.

如果只安装了Excel的干净Windows映像无法打开它,则它不是Excel格式。期。

#3


0  

If a Windows machine with Outlook Express, but without Excel can open it (if you change the extension) then it can't be an Excel file. I'd combine that with Ignacio's suggestion for a slam-dunk.

如果使用Outlook Express但没有Excel的Windows计算机可以打开它(如果更改扩展名),则它不能是Excel文件。我将这与伊格纳西奥关于扣篮的建议结合起来。

Plus, surely if it's MHT, then you can't actually do spreadsheet operations on it? Or am I misunderstanding how it works?

另外,当然如果它是MHT,那么你实际上无法对其进行电子表格操作?或者我误解它是如何工作的?

#4


0  

I don't think your statements are correct. Excel (2007) has import and export filters for single-file HTML documents (.mht) even if there is no Outlook Express installed. However, this is not a native format and worksheet features such as formulas cannot be retained (see http://office.microsoft.com/en-us/excel/HP100141051033.aspx#7)

我不认为你的陈述是正确的。 Excel(2007)具有单文件HTML文档(.mht)的导入和导出过滤器,即使没有安装Outlook Express也是如此。但是,这不是本机格式,并且无法保留公式等工作表功能(请参阅http://office.microsoft.com/en-us/excel/HP100141051033.aspx#7)

So what you should make clear to your customers is that there is a difference between an applications native file format and a format which isn't designed to contain spreadsheet functionality and that is only supported via an import/export filter.

因此,您应该向客户说明的是,应用程序本机文件格式与不包含电子表格功能的格式之间存在差异,并且仅通过导入/导出过滤器支持。

#1


3  

Many people (especially managers) confuse Excel files with reporting files. In my opinion, a file is only qualified as an Excel file if it meets all of these conditions:

许多人(尤其是经理)将Excel文件与报告文件混淆。在我看来,如果文件满足所有这些条件,则它只被限定为Excel文件:

  1. Is a spreadsheet formatted in one of the many Microsoft Excel formats.
  2. 是一种以多种Microsoft Excel格式之一格式化的电子表格。
  3. Can be opened in the most recent version of Microsoft Excel.
  4. 可以在最新版本的Microsoft Excel中打开。
  5. Is editable in Microsoft Excel.
  6. 可在Microsoft Excel中编辑。

In your case, I'm guessing only condition #3 is met, so it's no Excel file. But your support people may still call it a reporting file.

在你的情况下,我猜测只满足条件#3,所以它不是Excel文件。但您的支持人员仍可将其称为报告文件。

#2


3  

If a clean Windows image with only Excel installed can't open it, then it isn't in Excel format. Period.

如果只安装了Excel的干净Windows映像无法打开它,则它不是Excel格式。期。

#3


0  

If a Windows machine with Outlook Express, but without Excel can open it (if you change the extension) then it can't be an Excel file. I'd combine that with Ignacio's suggestion for a slam-dunk.

如果使用Outlook Express但没有Excel的Windows计算机可以打开它(如果更改扩展名),则它不能是Excel文件。我将这与伊格纳西奥关于扣篮的建议结合起来。

Plus, surely if it's MHT, then you can't actually do spreadsheet operations on it? Or am I misunderstanding how it works?

另外,当然如果它是MHT,那么你实际上无法对其进行电子表格操作?或者我误解它是如何工作的?

#4


0  

I don't think your statements are correct. Excel (2007) has import and export filters for single-file HTML documents (.mht) even if there is no Outlook Express installed. However, this is not a native format and worksheet features such as formulas cannot be retained (see http://office.microsoft.com/en-us/excel/HP100141051033.aspx#7)

我不认为你的陈述是正确的。 Excel(2007)具有单文件HTML文档(.mht)的导入和导出过滤器,即使没有安装Outlook Express也是如此。但是,这不是本机格式,并且无法保留公式等工作表功能(请参阅http://office.microsoft.com/en-us/excel/HP100141051033.aspx#7)

So what you should make clear to your customers is that there is a difference between an applications native file format and a format which isn't designed to contain spreadsheet functionality and that is only supported via an import/export filter.

因此,您应该向客户说明的是,应用程序本机文件格式与不包含电子表格功能的格式之间存在差异,并且仅通过导入/导出过滤器支持。