How can I reshape the given file into excel file ?

조회 수: 2 (최근 30일)
Deepesh Kumar Gupta
Deepesh Kumar Gupta 2022년 4월 4일
댓글: Deepesh Kumar Gupta 2022년 4월 4일
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에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by