Looking for a string in Excel file with multiple sheets
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
David Barry
am 6 Nov. 2012
Bearbeitet: David Barry
am 6 Nov. 2012
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?
Akzeptierte Antwort
David Barry
am 7 Nov. 2012
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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!