reading excel and doing computation on the same excel with .exe created for the .m file

1 次查看（过去 30 天）

显示更早的评论

Akshay Ratnaparkhe 2017-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333776-reading-excel-and-doing-computation-on-the-same-excel-with-exe-created-for-the-m-file

回答： Akshay Ratnaparkhe 2017-4-10

采纳的回答： ES

Hello, Please suggest thoughts on below:- I am looking for an executable file from the .m file which can allow me to take excel file as input from the user. In the same .m file I am doing some computation and displaying results. Currently I can take the excel file through the .exe using below command:-

[filename, pathname] = uigetfile({'*.xlsx'},'File selector');

After this I am adding both pathname and filename and using as address for the xlsread command like below- a = strcat(pathname, filename) data = xlsread('a','A3:A121')

but I failed to read the excel. Please let me know anything I am missing/doing wrong.

Thank you, Akshay

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

ES 2017-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333776-reading-excel-and-doing-computation-on-the-same-excel-with-exe-created-for-the-m-file#answer_261842

在 MATLAB Online 中打开

data = xlsread('a','A3:A121') Why is a in quotes here??? It should be like below.

data = xlsread(a,'A3:A121')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

更多回答（1 个）

Akshay Ratnaparkhe 2017-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333776-reading-excel-and-doing-computation-on-the-same-excel-with-exe-created-for-the-m-file#answer_262464

Thank you Smith.. Its working now. Thanks again

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Translated by