How to make the code read excel file?

2020 5 16
1 个回答
回答已采纳
更新时间：2020 5 16
4 次查看（30 天）

0 个投票

This is my code:
it calculate y when the user give the input value.
clear
clc
prompt = 'What is the temperature value (in C)? \n.\n.\n ';
temperature = input(prompt)
y = abs(0.5*(temperature /15)*1.225*0.8*3.14*5^2*((2*9.8*200*((abs(15-temperature))/temperature))^0.5)^3)
how can I make matlab code real excel file and the excel file has a values and I want to make each one of these values is the tempreture, and then export new file with given new values.

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

 采纳的回答

Star Strider
Star Strider 2020-5-16

0 个投票

Use the readmatrix function (or xlsread if you do not have readmatrix). There are also others, such as readtable, depending on what you want to do.
Do the calculations, then use the corresponding write functions (linked to in the pages I linked to here) to write the results.

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Ibrahim AlZoubi
Ibrahim AlZoubi 2020-5-16
I'm not familiar with xlsread ... how can i make matlab apply calculations on excel cells and then the result save it as new xlsx file?
I think these two lines will help
filename ='myExample.xlsx'; %creat a new file
xlswrite (myExample,mydata); % Save data to new file.
Star Strider
Star Strider 2020-5-16
You cannot do it in Excel with MATLAB. You need to read the Excel file into your MATLAB workspace, do the calculations, then write what you want to a new Excel file. The xlswrite function is appropriate for that.
Ibrahim AlZoubi
Ibrahim AlZoubi 2020-5-16
I see... but the thing that I can't do is the calculations part how to to the calculations for all cells?
Ibrahim AlZoubi
Ibrahim AlZoubi 2020-5-16
in other words lets assume table name is t:
when I multiply:
t*2
result:
Undefined operator '*' for input arguments of type 'table'
Star Strider
Star Strider 2020-5-16
If you read your data in as a table, in order to multiply all the elements in the table, you would need to do something like this:
t2a = table2array(t);
ax2 = t2a*2;
a2t - array2table(ax2);
then use the writetable function to write it to a file.
Ibrahim AlZoubi
Ibrahim AlZoubi 2020-5-16
great now how to write a code converts from a2t to excel file?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by