这是什么.xlsx文件格式? [英] What .xlsx file format is this?

问题描述

使用现有的SSIS包，我试图导入从客户端收到的.xlsx文件.我收到错误消息:

Using an existing SSIS package, I was trying to import .xlsx files we received from a client. I received the error message:

外部表的格式不正确

External table is not in the expected format

• 这些文件将以XL打开
• 当我使用XL(当前为XL2010)来另存为... 文件时，没有进行任何更改:
  • 新文件导入就很好
  • 新文件的大小为原始文件的330％
  • 将.xlsx更改为.zip并使用WinZip调查内容时:
    • 原始文件只有4个.xml文件和 _rels 文件夹(带有2个.rels文件):
    • 新文件具有预期的.xlsx内容:
    • These files will open in XL
    • When I use XL (currently XL2010) to Save As... the file without making any changes:
      • The new file imports just fine
      • The new file is 330% the size of the original file
      • When changing .xlsx to .zip and investigating the contents with WinZip:
        • The original file only has 4 .xml files and a _rels folder (with 2 .rels files):
        • The new file has the expected .xlsx contents:

        有人知道这可能是哪种文件吗?

        Does anyone know what kind of file this could be?

        最好开发我的SSIS包以使用这些原始文件，而无需打开和重新保存每个文件.文件只有12个，因此，如果没有其他选择，打开/保存每个文件没什么大不了的...我可以使用VBA使其自动化.

        It would be nice to develop my SSIS package to work with these original files, without having to open and re-save each file. There are only 12 files, so if there are no other options, opening/saving each file is not that big of deal...and I could automate it with VBA going forward.

        感谢任何人都可以提供的帮助，

        Thanks for any help anyone can provide,

        CTB

        推荐答案

        有许多您尝试导入的文件可能具有另一种excel格式，但扩展名已更改为 .xlsx (可以由其他人编辑)，或者可以用其他Excel版本创建.

        The file you are trying to import may have another excel format but the extension is changed to .xlsx (it could be edited by someone else) , or it could be created with a different Excel version.

        有一个名为 TridNet文件标识符的第三方应用程序，它是一个实用程序旨在从其二进制签名中识别文件类型.您可以使用它来指定指定文件的实际扩展名.

        There is a Third-Part application called TridNet File Identifier which is an utility designed to identify file types from their binary signatures. you can use it to specify the real extension of the specified file.

        在外部表上进行的简单搜索后，其格式不是预期的格式之后，当连接字符串中支持的excel文件的定义(或版本)与所选文件不同时，将引发此错误.检查excel连接管理器中使用的连接字符串.识别文件的版本可能会有所帮助.

        Also after a simple search on External table is not in the expected format this error is thrown when the definition (or version) of the excel files supported in the connection string is different from the file selected. Check the connection string used in the excel connection manager. It might help to identify the version of the file.

        这篇关于这是什么.xlsx文件格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！