How to save certain parts of cleaned data from Excel Spreadsheet?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Anne Nguyen
am 27 Okt. 2019
Beantwortet: Walter Roberson
am 27 Okt. 2019
What I have so far is:
filename = 'quiz_results.xlsx';
sheet = 1;
[nums,txt,raw] = xlsread(filename);
[nums1,txt1,raw1] = xlsread(filename,sheet,'G2:W2');
[nums2,txt2,raw2] = xlsread(filename,sheet,'B3:B103');
answerKey = txt1;
studentID = txt2;
[nums3,txt3,raw3] = xlsread(filename,sheet,'E3:E103');
essay = nums3;
[nums4,txt4,raw4] = xlsread(filename,sheet,'G3:W103');
multipleChoice = txt4;
save('filename.mat',answerKey,studentID,essay,multipleChoice); % this is resulting in an error saying "Error using save
Must be a string scalar or character vector."
I would only like to save the new data I collected which is "answerKey, studentID, essay, and multipleChoice". How do I do this? Thank you!
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 27 Okt. 2019
save('filename.mat', 'answerKey', 'studentID', 'essay', 'multipleChoice');
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!