Post reply

xlsx error: “Removed Records: Named range from /xl/workbook.xml part” when tried to resolve errors

  • August 30, 2013 at 12:48 pm

    #149919

    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

  • August 30, 2013 at 2:07 pm

    #1646482

    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.

  • February 21, 2019 at 1:40 pm

    #2022601

    Thanks trailblazer... I know it has been six years since your posting but yours was what solved my issue.

    My problem was that my .XLSX tabs had spaces in the names.  I replaced all of the spaces with underscores and the SSIS job and .XLSX output file work perfectly now.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply