Alteryx Excel Import, Is there a way to bring through the calculation for the cell?

[TheOC]

Hey,
I'm just looking for a little help regarding an excel import. I have the following file:

Field 3 is populated by a calculation, as you can see, 1+2. Is there a way to bring that calculation through to Alteryx, rather than just the value of the cell?
The data is brought into Alteryx as such:

I've attached the spreadsheet if it helps investigate.
Cheers!
TheOC

[JokeFun]

Now I have set the field length as 10000 and just had two columns in the file. And then another message: Error: XML Parse (24): unexpected end of input at Line:1 and Column:100001

[JokeFun]

I have a file with more than 10K rows where the field contains text string, as well as some rows with formulas like =-@ abcd.

The purpose is to identify rows with such formulas and replace by abcd (removing =-@).

However, I was seeing this error message.

Error: XML Parse (24): input ended before all started tags were ended; last tag started is 'row' at Line:1 and Column:100001

Then I set the field length to be 10000000000 something like that, even larger. Then it works.

[caltang]

Hi @AngelosPachis 

Sorry to revive an old thread from 2021 - but this is exactly what I need.

May I ask, what do these extract file boxes represent?

@TheOC - I wonder if this can be made into a Universal Tool that can be shared to the Community. What do you think?