How can I reshape the given file into excel file ?
Show older comments
i want this file data into [68*1080] excel sheet , so that i can proceed for further calculation, please help me with matlab code.
Answers (2)
KALYAN ACHARJYA
on 4 Apr 2022
#Let's suppose final name is Test_CSV.csv
data=readmatrix('Test_CSV.csv');
xlswrite('test_data.xlsx',data);
You may extract the required data sizes using array indexing.
Like
data(1:68,1:1080)
There are so many related threads, please do search in MATLAB Answer.
1 Comment
Deepesh Kumar Gupta
on 4 Apr 2022
Voss
on 4 Apr 2022
Here's one way to do that:
C = readcell('matlab.csv');
C = cellfun(@str2num,C,'UniformOutput',false);
C(cellfun(@isempty,C)) = [];
M = cell2mat(reshape(C,68,[]));
writematrix(M,'matlab_reshape.csv');
1 Comment
Deepesh Kumar Gupta
on 4 Apr 2022
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!