I have a datatable with the count of records close to 50k
i am trying to write this into a sheet in an excel file using write range activity.
In between, one cell has value starting with ‘=’ symbol and the activity stops here and gives an error “Could not write the datatable starting with cell A1”
All the data prior to that cell is written into the sheet perfectly.
How do I get this sorted ?
Another peculiar thing is i have 2 cells which starts like this - "========== User’s Account Details ============myID: " [quotes excluded]
1 cell is written to the sheet but the other cell isnt
Even 1 more excel file stops because write range isnt able to write the values starting with ‘=’ symbol
Any leads here would be highly appreciated.
Thanks in advance!