Output to Specific Range (Repaired & Read-only mode)

Question

Hi All,

I am trying to Write the file to Specific range through Output Tool, successfully i wrote to the file. But the when i open the excel it shows as Repaired file and opening as read only (Locked for editing) excel. Can someone help me how to resolve this issue?

DanielG · Answer

PS - the start and end tags matched in my XML as far as I could tell.  I opened the Excel files as XML files using 7-zip file manager.

DanielG · Answer

@Nelson_D  and @Qiu   -- just wanted to pass along additional information I just figured out after a long day of trail and error work on this.  But when you're file gets locked up like that it might actually have nothing to do with the data you are passing in from Alteryx to the range.  I had been scouring my data for special characters to find anything that could have thrown off the Excel XML causing the lock-outs that I had been getting.  It was cryptically showing information like this in the repair logs.

What it turns out the issue was the name of the tab which included special characters, even though I am not altering the name of the tab anywhere in the workflow...  I had a tab name like "2b - blah & blah" and that was causing the issue even though it is perfectly fine to have that in Excel.

Hoping that just maybe it gets @Nelson_D a little closer to fixing the original issue.

I will keep posting if I discover anything else.  🙂

Nelson_D · Answer

@DanielG  i tried all your above possibilities but it didnt work 😞 i even tried through Binary version but it say DataWrap2OleDb error.