Looking for a string in Excel file with multiple sheets
조회 수: 1 (최근 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!