MATLAB: Create a table in MatLab with specific data in different spreadsheets in one Excel File.

excel spreadsheetimporting excel data

Hello together,

I have an Excel File with 10 spreadsheets and I want to import data (always range: A2:K7) from every spreadsheet into a table in MatLab. I want to create a Loop so that the data is displayed beneath one another.

Thank you for your support!

Best Answer

Use the sheet option from the readtable function to loop through the single sheets. Indexing the values correctly in the table you create will let the data appear the way you want. in the given link you also find how to select the range of the Excel document.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Index in position 2 exceeds array bounds.

For some reason, the value in your excel file are stored as text instead of numeric values. The best solution is to fix the excel file. The following code shows how you can read your current excel file in MATLAB

% Proses membaca data latih dari excel
filename = 'CurahHujan.xlsx';
sheet = 2;
xlRange = 'D8:P19';
 
Data = table2cell(readtable(filename, 'Sheet', sheet, 'Range', xlRange));
Data = cellfun(@str2double, Data);
data_latih = Data(:,1:12)';
target_latih = Data(:,13)';
[m,n] = size(data_latih);

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Index in position 2 exceeds array bounds.

Related Question