Read all Excel cells between two strings

1 次查看（过去 30 天）

mark 2022-7-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1756805-read-all-excel-cells-between-two-strings

评论： dpb 2022-7-10

Hi,

I have an Excel sheet which contains 4 sheets and in each of these sheets, there are 3 occasions where the words 'Interval 1' and 'Interval 2' appear (each of them is in it's own cell). I would like to write a code that finds these two words/strings and reads in all of the cells inbetween these two strings (the two strings and the data inbetween them are all on the same row in the excel sheet) and store the end result in a 4x3 cell array, where each cell in this array contains all of the data inbetween these two strings. I'm very puzzled on how to approach this (maybe use strcmp?). Any help would be very appreciated!

Thank you