Extracting 2 columns from a excel file and send them to an own matrix file
Show older comments
Hello, I have an XLS file that I need to extract two columns from, and send them in the Workspace to an own file.
I do on the xlsx file:
D=readtable('tempDataTrollhFlygpl.xlsx', 'NumHeaderLines', 10) % anger 10 rubrikrader slik at jeg kan ekstrahere kolonne entries mer effektivt
timetemp = D;({:,3}{:,4})
timetempdouble = str2double(D{:,3},{:,4});
In order to get the file called timetempdouble as an own file, with readable double-format. But this does not work. How can I extract those two columns, and what is the general command to say extract "n" columns from a xlsx file and convert it to doubles?
Thanks!
1 Comment
VBBV
on 16 Feb 2024
Use writematrix function with the desired filename and extension
Accepted Answer
Star Strider
on 16 Feb 2024
Edited: Star Strider
on 16 Feb 2024
Perhaps something like this —
opts = detectImportOptions('tempDataTrollhFlygpl.xlsx', 'NumHeaderLines', 9, 'VariableNamingRule','preserve');
opts = setvartype(opts, 4, 'double');
D=readtable('tempDataTrollhFlygpl.xlsx', opts) % anger 10 rubrikrader slik at jeg kan ekstrahere kolonne entries mer effektivt
ismt6 = all(cellfun(@(x)isempty(x),D{:,6})); % Check 6 (Seems To Be Empty)
if ismt6
D = removevars(D, 6); % If 'Var6' Is Empty, Remove It (Optional)
end
D % Edited 'D'
timetemp = D(:,[3 4]) % Create 'timetemp' From Variables 3 & 4
EDIT — (16 Feb 2024 at 19:13)
.
4 Comments
Askic V
on 16 Feb 2024
@Star Strider How did you manage to read from the file and execute code without using load and websave? Is there any other way we can read from the attached files here on the discussion threads?
Sorry for being off topic.
Star Strider
on 16 Feb 2024
I used the ‘paperclip’ icon on the top toolbar and then checked the appropriate box (only one here, clicking on the top one next to ‘Attachment name’ checks all of them) in the ‘Link from this thread’ tab, then clicked on ‘Submit’. The files then attach automatically to the Comment or Answer window that originates them.
The paperclip icon is also used to upload files from the user’s computer, as it was previously.
Sergio
on 17 Feb 2024
Star Strider
on 17 Feb 2024
As always, my pleasure!
More Answers (1)
Hello,
I would do something like this to extract the data, and then I would used writematrix like VBBV suggested to write into new file.
A = readtable('tempDataTrollhFlygpl.xlsx');
Values = str2double(A{4:end, 4});
Dates = datetime(A{4:end, 3}, 'InputFormat','dd-MMM-yyyy');
plot(Dates, Values)
Categories
Find more on Spreadsheets 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!
