What is the simplest way to export Excel data to Matlab?
What is the simplest way to programmatically export Excel data to Matlab?
excel matlab export
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
add a comment |
What is the simplest way to programmatically export Excel data to Matlab?
excel matlab export
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
add a comment |
What is the simplest way to programmatically export Excel data to Matlab?
excel matlab export
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
What is the simplest way to programmatically export Excel data to Matlab?
excel matlab export
excel matlab export
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
asked Oct 13 '08 at 18:38
DegvikDegvik
1,40551820
1,40551820
add a comment |
add a comment |
5 Answers
5
active
oldest
votes
If you are running Matlab on Windows with Excel installed, try XLSREAD.
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
add a comment |
If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
add a comment |
In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.
add a comment |
For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
add a comment |
As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f198568%2fwhat-is-the-simplest-way-to-export-excel-data-to-matlab%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
5 Answers
5
active
oldest
votes
5 Answers
5
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you are running Matlab on Windows with Excel installed, try XLSREAD.
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
add a comment |
If you are running Matlab on Windows with Excel installed, try XLSREAD.
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
add a comment |
If you are running Matlab on Windows with Excel installed, try XLSREAD.
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
If you are running Matlab on Windows with Excel installed, try XLSREAD.
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
answered Oct 13 '08 at 19:07
Jouni K. SeppänenJouni K. Seppänen
28.1k46292
28.1k46292
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
add a comment |
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
The xlsread function that Jouni mentioned works well. If you want some finer control over Excel consider using ActiveX to interact with the Excel file. Check out the MATLAB help for COM client support. I've used this approach to create Excel files but you could also use it to implement advanced programmatic reading of files.
– b3.
Oct 13 '08 at 19:44
1
1
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
Note that having Excel installed is no longer a requirement. mathworks.nl/help/matlab/ref/xlsread.html
– Dennis Jaheruddin
Aug 14 '13 at 9:46
add a comment |
If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
add a comment |
If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
add a comment |
If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
If there's not much text annotation in the Excel file, save it as a csv, then use the MATLAB function csvread.
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:39
Scottie TScottie T
7,05293956
7,05293956
add a comment |
add a comment |
In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.
add a comment |
In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.
add a comment |
In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.
In more recent Matlab releases there are also csvread() and writetable() that work with csv which can easily be opened in Excel.
answered Mar 9 '16 at 21:51
user6041892
add a comment |
add a comment |
For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
add a comment |
For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
add a comment |
For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
For a bit of $$$, you can get the MATLAB add-on Excel Link, which provides a nice clean interface for transferring data back and forth between the two programs.
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
answered Oct 13 '08 at 18:41
Scottie TScottie T
7,05293956
7,05293956
add a comment |
add a comment |
As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
add a comment |
As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
add a comment |
As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
As has been said, XLSREAD is the right function for the job. On a non-Windows system it will also work without Excel installed. However, it supposedly lacks some of Excels advanced features.
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
answered Oct 18 '08 at 0:44
bastibebastibe
6,7682172115
6,7682172115
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f198568%2fwhat-is-the-simplest-way-to-export-excel-data-to-matlab%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
