I have an excel sheet that is created once a week from a reporting system. It will always look like below screenshot (Headers start on cell B6 and the row count will be different each time. The columns will always be the same.).
What I need to do is grab only the information in the table, including the headers and copy it to another worksheet. The last row will always contain the “grand totals”. I do not need the title “Sales Reports” nor the “selection criteria” row. How would I get only the data and the headers?
In read range activity you can mention range. Give “B6” Range in read range and the excel data will be copied to a datatable. later you can write this datatable to any other sheet or workbook using write range activity.
Thank you, I tried this but when I write the output to excel, it includes the last row with “selection criteria” which I do not want. It is also not preserving the format of some columns even after clicking “preserve format”?
@balupad14 If I’m using your “Change Cell Type” activity multiple times, should I include a long delay after each? I notice it’s only performing the activities in debug mode on slow step, but not when I actually run the process. No errors, the robot just stays running but does nothing.