您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Import units from excel sheet

1 次查看（过去 30 天）

显示更早的评论

Aikaterini Mountraki 2019-8-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet

评论： dpb 2019-8-22

I want to import values and units separately from an excel file:

How can I identify the units and relate them to the values?

Instead of writing COST.u.EUR, is it possible to have it as [COSTvalue Costunits] but identified from the input file?

10 个评论
显示 8更早的评论隐藏 8更早的评论

dpb 2019-8-14

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_735112

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_735112

Attach the file (or a short section of one)

Jyotsna Talluri 2019-8-20

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737126

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737126

Is that a dropdownlist in the currency column??

Aikaterini Mountraki 2019-8-20

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737134

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737134

编辑：Aikaterini Mountraki 2019-8-20

Yes, it is a dropdown list. The excel is my input file, so I have restricted the possible options with dropdown lists.

dpb 2019-8-20

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737195

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737195

Again I reiterate once more..."attach the file"

Aikaterini Mountraki 2019-8-21

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737420

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737420

编辑：Adam Danz 2019-8-21

在 MATLAB Online 中打开

the script goes like this:

------------

% Import Data Files
RawCCostData = readtable('UserData.xlsx',"Sheet",'CCost');
% Identify Parameters
Process_i = categorical(RawCCostData.Process)
cost = RawCCostData.Cost
syms  u1 u2
u = symunit;
u1 = isUnit( RawCCostData(:,2) );
u2 = isUnit( RawCCostData{:,3} );

-----------------

So when I want to convert unit systems I usually do:

Cost = unitConvert(Cost,u.USD)

But my problem is that since cost and units (currency) are inserted by different columns, they are not related together in the input file. So, how can I relate those two?

Thanks for the help

Adam Danz 2019-8-21

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737496

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737496

编辑：Adam Danz 2019-8-21

I believe dpb was refering to the excel file UserData.xlsx.

Aikaterini Mountraki 2019-8-21

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737504

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737504

UserData.xlsx

Here is the input file

dpb 2019-8-21

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737689

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737689

Ah! I was thinking the problem had to do with importing the spreadsheet owing to the dropdown boxes or somesuch...not to using symbolic TB and the symbolic names feature. Since I don't have that TB, not much I can actually do but to note that in the table the variables are associated by row index across all variables so reference a specific row or set of rows and you'll have all the associated data with it. I dunno how the symbolic variables interact with a table, but I'd probably convert the Currency variable to categorical as well.

To convert to another set of units in a table you would have to either pull out the data to convert to the symbolic form (and I have no idea how it would deal with currency conversion given the rate of conversion isn't a fixed number as with physical units) or have a function that uses the table data and "knows" how to do the allowable conversions of which column is associated with the column containing the currency specification.

Don't know that there is a canned solution.

Aikaterini Mountraki 2019-8-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737844

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_737844

I will give it a try. Thanks

dpb 2019-8-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_738162

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476118-import-units-from-excel-sheet#comment_738162

If you had the financial toolbox, perhaps there's something in it dealing with currency conversions??? I don't know that, just a guess that's where something like that might reside if it exists...

请先登录，再进行评论。

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