Looking for a string in Excel file with multiple sheets

1 次查看（过去 30 天）
Swasti Khuntia
Swasti Khuntia 2012-11-6
Hello,
I want to read an Excel file with multiple sheets. From the file, I want to search for a particular string.
How shall I do it?
Any ideas?
Thanks
  2 个评论
David Barry
David Barry 2012-11-6
编辑：David Barry 2012-11-6
Is this a one off task or are you looking to automate for many spreadsheets? When you say "search for a particular string", what exactly are you looking to return?
Swasti Khuntia
Swasti Khuntia 2012-11-7
Hello David,
I mean, if I found the particular string, then I'll be extracting the information from a particular row.
I hope it's clear to you now.

请先登录，再进行评论。

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

采纳的回答

David Barry
David Barry 2012-11-7
You should try looking up the xlsread, strmatch, find and strncmp functions in the help. There are comprehensive examples that should demonstrate what you need to do.
If you are still struggling then please upload some sample data.

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by