Output Excel File Error Repaired XML - ALTERYX TEAM PLEASE FIX THIS

Greetings everyone.

I come once again here to express my frustration with this OLD BUG that alteryx has when trying to preserve the format of excel sheets with multiple outputs.

This is a bug known for 3 years already and there are still people like me suffering with it.

"We found a problem with some content...Do you want to try to recover as much as we can?' Once I click yes, I then receive this pop up: 'Removed Records: Cell Information from /xl/worksheets/sheet12.xml part'"

This just BROKE my excel with all my formulas and now I have to start all over again.

Is there any prospected target fix date or any workarounds that work? On many posts here there are no solutions for this yet.

Thanks

Workflow

Accepted answers

flying008

Hi,@Joker_Hazard

Base your xlsx file, the output kept cell's formatting like "0.000000" in columns C/D/E/F . (myabe you can use alteryx v2022.1 to try it.)

All comments

IraWatt

Hey @Joker_Hazard

As a workaround you could try using the python tool to write to the cells directly excel - Write values to a particular cell in a sheet in pandas in python - Stack Overflow. Also don't know if it is causing the issue but you could move all the calculation to Alteryx instead of DAX formulas in Excel?

All the best,

Ira

Joker_Hazard

Hi Ira.

I cant move to alteryx those formulas and even if I did, what is causing this error is the formatting. Alteryx is not able to read properly formatted excels.

Unfortunatelly alteryx team for some reason is not present on those posts when we need them. I am really frustrated and sad. Been 4 years already paying this expensive license and no solution so far.

flying008

Hi, @Joker_Hazard

I've had a similar problem, so if you'd like, please submit one sample data.xlsx file with formatting & formulas and let's try a workaround?

ID	Description	Version	Issue Status
TPM-399	The Output tool "Preserve Formatting on Overwrite" setting for XLSX files behaves inconsistently depending on whether the XLSX was last saved by Designer or Excel.	2021.3.4.00445	Fixed

Joker_Hazard

Hey mate. Thanks for the help.

Here you go, sample data exported to excel.

Sample Data exported into excel sheets.xlsx

flying008

Hi, @Joker_Hazard

I didn't save the file. As you can see, there is no special setup for the workflow, I just think individual versions have good compatibility in preserving formats, while most versions maybe have bugs. because I have done comparative experiments long times. (If you can, please try the v2022.1.1 now for test it.)

jcheming

I am also encountering this issue when writing function strings containingXLOOKUP(). I've attached a sample workflow that demonstrates the output tool injecting an "@" into the string of the Excel formula with XLOOKUP().

XLOOKUP Bug.yxmd

flying008

Hi, @jcheming

Maybe the stick like ms365 and array formula, so if you can, please try other office version[e.g. 2016] to valid it again.

pall

I was also facing the same issue - you can modify the Paper Size settings - use custom size and then work backwards and adjust it as per your content to avid getting the error

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703