working with excel in MATLAB code

10 次查看（过去 30 天）

显示更早的评论

amirmasoud kochakzadeh 2020-1-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498661-working-with-excel-in-matlab-code

回答： amirmasoud kochakzadeh 2020-1-4

采纳的回答： Walter Roberson

test1.xlsx

Hi every one,

I am working on an excel file that I attach it, and I want to compare two columns of that file and check if the value of them and if they are not equals, return 1. The excel file is not regular and number of rows are variable in each section and some empty cells are between the two sections. Now I want to know that how can I do this?

Thanks so much.

2 个评论
显示无隐藏无

Walter Roberson 2020-1-2

Excel Reader warns me that the sheet has formulas with circular references.

amirmasoud kochakzadeh 2020-1-2

Hi i fix it again

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2020-1-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498661-working-with-excel-in-matlab-code#answer_408403

在 MATLAB Online 中打开

Col1 == Col2 | (isnan(Col1) & isnan(Col2))

2 个评论
显示无隐藏无

amirmasoud kochakzadeh 2020-1-2

thanks alot Sr.

but aother qustion how can i change the double form matrix to table form

Walter Roberson 2020-1-2

array2table

Or these days it often makes sense to use readtable() instead of xlsread()

请先登录，再进行评论。

更多回答（1 个）

amirmasoud kochakzadeh 2020-1-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498661-working-with-excel-in-matlab-code#answer_408643

thanks alot

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

请先登录，再进行评论。

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

MATLAB

Community Treasure Hunt

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

Translated by