How can I reshape the given file into excel file ?

2 次查看(过去 30 天)
i want this file data into [68*1080] excel sheet , so that i can proceed for further calculation, please help me with matlab code.

回答(2 个)

KALYAN ACHARJYA
KALYAN ACHARJYA 2022-4-4
#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 2022-4-4
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');

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by