How to open a specific EXCEL sheet with the function _fopen_?

61 次查看(过去 30 天)
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!

回答(2 个)

Iain
Iain 2013-8-28
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.

Pramit Biswas
Pramit Biswas 2013-8-28

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by