Excel output error: Replaced Part: /xl/worksheets/sheet1.xml part with XML error.

Hi everyone, I have a workflow which output needs to replicate a template's format, so I used blob tools for that.

The workflow run without errors doing what it's suppose to do. But, when I open the excel output, file is blank and gives me this error: Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Whitespace expected.

Found on the web that the issue might be related to frozen panes in excel. So I checked the template file (the one that feeds the blob to replicate the format), removed the frozen pane it had, tried again but same results.

Any ideas on how to fix it? Thanks

Workflow

Error Message

Output

Accepted answers

abcy

I am embarrassed and at the same time relieved at myself, haha. My error was generating an incorrect file name reference on a formula tool that was feeding the Output blob. Ran the workflow and it worked.

Lesson learned...

All comments

Samantha_Jayne

Hi @abcy I would definitely check your template, perhaps even make a new fresh simpler one to rule out if its that, then build up the complexity. Are you using any named ranges or just pushing to sheets?

abcy

Thank you @Samantha_Jayne I tried simplifying my template without any luck. I am using a range, the template and workflow outputs have matching columns.

When I changed the output sheet name I runs fine but of course does not copy the template's format.

abcy

Lesson learned...

Samantha_Jayne

Easily done @abcy glad you managed to spot it 😊

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335