Looking for a string in Excel file with multiple sheets
2 ビュー (過去 30 日間)
古いコメントを表示
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
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?
採用された回答
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 件のコメント
その他の回答 (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!