MATLAB: Import multiple excel sheets with multiple columns each into variables

importing excel data

Hey, I would like to import data from excel with multiple sheets. Every sheets has 2 columns and I would like to create a variable of every column in every sheet. How can I do this in Matlab?

Best Answer

You can use xlsread(xls_file,sheet_no) to read from particular sheet, refer documentation. It will return data in matrix form. Once you have that, use array indexing to extract individual columns ,Matrix(:,col) gives column 'col' of 'Matrix'.

Using xlsread, loop through all the sheets to get data from individual sheets.

Related Solutions

MATLAB: How to change a variable’s name to an excel sheet name

Don't do that. isempty() is a built-in function. There is no way you should override this function with anything.

Nor do you want to create variables with names derived/determined by some cell contents of the workbook. How would you know how to reference those variables later in your program if you don't know their name until runtime? This is a bad idea.

MATLAB: I want to take difference of column A (first column in sheet_1) and column B (also first column in sheet_2). Output should be file C in workspace.

So you have excel file containing two sheets. And you want to:

subtract numbers in column A in sheet_2 from numbers in column A in sheet_1
save (just) these differences to excel file named 'C.xlsx'

Is that right? Then you can do this:

A = xlsread('myFile.xlsx', 'sheet_1');
B = xlsread('myFile.xlsx', 'sheet_2');
xlswrite('C.xlsx', A(:,1)-B(:,1) );

In this case input file is 'myFile.xlsx' and names of first and second sheet are sheet_1 and sheet_2. If you don't know exact names, but you know that it's always first and second sheet, you can replace names with their numbers.

xslread documentation

Best Answer

Related Solutions

MATLAB: How to change a variable’s name to an excel sheet name

MATLAB: I want to take difference of column A (first column in sheet_1) and column B (also first column in sheet_2). Output should be file C in workspace.

Related Question