search through an excel file, and save sheet and cells as variables
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
avram alter
el 28 de En. de 2020
Respondida: avram alter
el 29 de En. de 2020
I have an excel file that wil have up to 15 sheets in it. I have added a small example here that demonstrates what it looks like. basically, each sheet has 4x8 cells filled with an alphanumeric codes, with no codes repeating. Is there a way to enter one of the codes, and then matlab will search through the excel file, returning the sheet name and row to be saved in a variable?
for example, in the file I added here, Sheet2, row 4 begins with qwwj8434. for example
code = input('please enter code: ', 's');
>> qwwj8434
Sheet_name = Sheet2
Row_name = 4
I would specifically just be looking for the first code per row, if that helps at all.
Any help would be much appreciated.
2 comentarios
Mohammad Sami
el 29 de En. de 2020
The data needs to be loaded into Matlab first, before you can actually search the string you are looking for.
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!