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 连接的表达式:

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:

xml文件的内容是

<?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:outputdocumentId-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>

我无法弄清楚究竟是什么导致了这个错误.任何帮助将不胜感激.TIA

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

推荐答案

解决了.我真的不知道原因.做了一些研究，发现与标签名称相关的东西会导致这个问题.我不得不使用诸如tab"和tab(2)"之类的名称来标记.可能 xlsx 将它们视为相同的名称.

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屋！