How to read data from a Excel file and insert data within each sheet in a already created cell array

Question

Behrooz Daneshian 2023-2-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1906560-how-to-read-data-from-a-excel-file-and-insert-data-within-each-sheet-in-a-already-created-cell-array

评论： Sulaymon Eshkabilov 2023-2-4

Hi all,

Temperature data for 333 weather stations in Alaska state are stored in an Excel file(each sheet in this file represents data for one weather station). I want to insert data within each sheet of this Excel file in column 8 of an already-created cell array. Please note that I want data within each sheet to be inserted in the cell array as a table. There are already tables in column 8 of the array but these data have missing values, and I want them to be replaced by the data in the Excel file.

It should also be noted that I was not allowed to upload files larger than 5 MB. Hence, I just created representative files( actually, the main Excel file has 333 pages and the main mat file has 333 rows, but here I have just brought 5 stations to show you the concept of my problem).

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sulaymon Eshkabilov 2023-2-4

在 MATLAB Online 中打开

This is how it can be attained:

load('Test.mat')            % 
FName ='Test.xlsx';  
S_names = sheetnames(FName);
for ii=1:numel(S_names)
    D{ii}=readtable(FName, 'Sheet', S_names(ii));   % Data read as a table array
   stations11{ii,8} = D{ii};                        % Inserted in column 8 of the existing variable: stations11   
end