Hi,
I have a source Excel spreadsheet that contains a lot of formulas and formats and I want to update data in a column for a selected account based on some calculations performed in related Datatables. I don’t want to load the spreadsheet via the generic Read Range activity as when I do a Write Range all formatting is lost.
I have a value (account number) saved in a string variable that I want to search for in Column A of the source spreadsheet and then update the string value in Column K for the selected row.
Thanks
Craig…