How to write a .m script that can read .xlsx file?

3 views (last 30 days)
Hi, I'm a newbie to matlab. I'm thinking of writing a simple .m script that can read an .xlsx file on another location. I don't know how to start writing the script (like what should be included on the top section and end section of the script). Here's an example of the scenario:
.xlsx Filename = test1.xlsx
Location of .xlsx = C:\Users\SamanthaTzeeSan\Documents\MATLAB\Example 1
.m script name = matlabTest1.m
Location of .m = C:\Users\SamanthaTzeeSan\Documents\MATLAB

Answers (1)

Walter Roberson
Walter Roberson on 31 Oct 2015
num = xlsread( fullfile('C:\Users\SamanthaTzeeSan\Documents\MATLAB\Example 1', 'test1.xlsx') );

Tags

Community Treasure Hunt

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

Start Hunting!