How to open a specific EXCEL sheet with the function _fopen_?
63 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi everyone,
I would like to use the function fopen to open a xlsx file using:
fid=fopen('filename.xlsx')
Is it possible to specify the excel sheet I would like to open since my file has several sheets (and since the first sheet has a special xls "table style")?
Thanks a lot for your help!
0 comentarios
Respuestas (2)
Iain
el 28 de Ag. de 2013
fopen opens files for binary or string access.
An excel file is a binary file in a format that is not easily defined, so reading it with fopen and the various reading commands is on to a loser.
The function "xlsread", with the right inputs will open the file and give you out the contents of the sheet you actually care about.
0 comentarios
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!