I am adding data to excel daily. Originally I would add a new row to the end to many excel files and sheets using xlswrite.
- For example: if there are 200 rows, I run the code and it adds a row in the 201st spot.
I am making plots of all of this data in the excel files/sheets but unfortunately when I add a row at the end the plots wont update. If I add a row anywhere else before the end, the plots recognize it and will update. My only job now would be to sort the data in each file/sheet vs updating various parameter ranges for every plot in each file/sheet.
- For example: I would like to add a row to A1 and shift the existing 200 rows down for a total of 201 rows.
