Read all Excel cells between two strings

1 次查看（过去 30 天）
mark
mark 2022-7-10
评论： 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
  1 个评论
dpb
dpb 2022-7-10
Read the full sheets as string arrays and use the fancy new extractBetween function sounds like the meal ticket.
But, you'll have a lot more success in somebody writing some directly applicable code if you attach one of the files...

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by