MATLAB Answers

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

223 views (last 30 days)
GANTY
GANTY on 28 Aug 2013
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 Comments

Sign in to comment.

Answers (2)

Iain
Iain on 28 Aug 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 Comments

Sign in to comment.



Translated by