i have a excel file which is almost 7000 kb and having some formulas inside…my problem is that i am getting error(could not read range A:XFD) while in reading the sheet in “read range workbook” and “read range” of excel…both.
what should i do? i cant remove or edit the excel sheet.
What’s the error that you’re getting?
could not read range A:XFD
Kill the excel by using the kill activity and then before going to open the same excel give some delay and open it.
I guess some is open so you are getting that error in this case you should close the excel manualy
Same error I was facing with the modern Excel activities. When I removed the custom cell styles like color grading it worked perfectly.