MATLAB: How to use ‘textscan’ to read data from Sheet2 of an Excel file textscan As said in question, want to know if textscan can be used to scan data from Sheet2 of an Excel file? Thanks for any help. Best Answer Try readtable( _______, 'DatetimeType', 'exceldatenum' );See the documentation. Related SolutionsMATLAB: Problem opening excel csv file using xlsread for CSV file you should use readtable() or csvread(). MATLAB: How do i read an excel file with differnt sheets in an easy way xlsinfo can be used to find the name of the sheets or the number of sheets. After that you loop reading one sheet at a time.Or if you already know the names of the sheets, just make four xlsread() calls passing in the appropriate sheet information. Related QuestionExtracting Names from ExcelRemove weekends and holidays data from excel fileHow to import this CSV file
Best Answer