Looking for a string in Excel file with multiple sheets

1 vue (au cours des 30 derniers jours)

Afficher commentaires plus anciens

Swasti Khuntia le 6 Nov 2012

0
Lien

Utiliser le lien direct vers cette question

https://fr.mathworks.com/matlabcentral/answers/52965-looking-for-a-string-in-excel-file-with-multiple-sheets

Réponse acceptée : David Barry

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 commentaires
Afficher AucuneMasquer Aucune

David Barry le 6 Nov 2012

Modifié(e) : David Barry le 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?

Swasti Khuntia le 7 Nov 2012

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.

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponse acceptée

David Barry le 7 Nov 2012

0
Lien

Utiliser le lien direct vers cette réponse

https://fr.mathworks.com/matlabcentral/answers/52965-looking-for-a-string-in-excel-file-with-multiple-sheets#answer_64664

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.