xlsx错误：“已删除的记录：来自/xl/workbook.xml部分的命名范围”当尝试解决错误 [英] xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

问题描述

我有一个我使用SSIS生成的xlsx文件。该文件的数据是通过数据流任务编写的，其中xlsx文件是oledb目标。我使用以下连接字符串作为OLEDB连接的表达式：

 Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ @ [User :: ExcelPath] +; 
扩展属性= \Excel 12.0 Xml; HDR = YES\; 
  

在数据流任务之前，文件打开正常。在数据流任务之后，我得到如下对话框：

当我点击是，我收到另一个消息：

xml文件的内容是

 <？xml version =1.0encoding =UTF-8standalone =yes？> 
< recoveryLog xmlns =http://schemas.openxmlformats.org/spreadsheetml/2006/main> < logFileName> error072840_02.xml< / logFileName>< summary>在文件'C：\output\documentId-1.xlsx'< / summary>< removedRecords summary =中检测到错误删除的记录：>< removedRecord>删除的记录：来自/xl/workbook.xml部分（Workbook）的命名范围< / removedRecord>< / removedRecords>< / recoveryLog> 
  

我无法弄明白导致此错误的原因。任何帮助将不胜感激。 TIA

解决方案

得到解决。我真的不知道原因。做了一些研究，并且知道与标签名有关的事情可能导致这个问题。我不得不使用tab和tab（2）这样的名称。可能xlsx将它们视为相同的名称。

I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task where the xlsx file is the oledb destination. I have used the following connection string as an expression for the OLEDB connection:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ @[User::ExcelPath] +";
Extended Properties=\"Excel 12.0 Xml;HDR=YES\";"

The file opens just fine before the data flow task. After the data flow task, I get a dialog as follows:

When I click yes, I get another message:

The contents of the xml file are

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">       <logFileName>error072840_02.xml</logFileName><summary>Errors were detected in file   'C:\output\documentId-1.xlsx'</summary><removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Named range from /xl/workbook.xml part (Workbook)</removedRecord></removedRecords></recoveryLog>

I am not able to figure out what exactly is causing this error. Any help will be appreciated. TIA

解决方案

Got it resolved. I don't really know the reason. Did some research and came to know that something related to tab names can cause this issue. I had to tabs with names like 'tab' and 'tab(2)'. May be possible that xlsx treats them as same names.

这篇关于xlsx错误：“已删除的记录：来自/xl/workbook.xml部分的命名范围”当尝试解决错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！