Hello @eric-cheng
Many thanks for helping me out here. Yes, i am able to download and export the data in a two column table within an excel instance. Problem i am facing now is one column is header and the other column is its corresponding value which i need to copy and paste in another excel instance if the headers string matches the header string in other column. Using If else sounds very tedious in this case since if the value of strings do not match then i need insert "0" int since the values column contains only int cells in its rows.
Then using if and else through 15 rows will make the flow very long.
Agreed OCR did not worked at all for me.
Regarding Salesforce regularly breaking the layout, is true as i had noticed that several times, do not know how they are managing to do it, i hope not some condition on number of requests to load the page or etc.
But if you happen to have any knowledge regarding Looping through multiple columns in excel for each cell please do help.
What i want is to read the text from a row and a cell in one excel instance and then match that text with my downloaded from salesforce excel header column, if Yes then copy the value next to that header cell as it must be an int only accepted in to my first excel instance specified row cell. This for all the 15 rows.
Bundle of thanks in advance 🙏
