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

65 次查看（过去 30 天）
GANTY
GANTY 2013-8-28
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by