How can I reshape the given file into excel file ?

2 views (last 30 days)
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
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.

Voss
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');

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!