extract values from specific cells in excel

Question

olu 2013-8-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83788-extract-values-from-specific-cells-in-excel

编辑： Carlos GU 2022-7-30

Hi, I would like to values from specific cells in excel file>>>>>>. Please help me with script to do that. for example, I would like to copy values from cells A1, A6, A11,..A1501....and cells B1, B6, B11,.....B1501 ( as shown in the attached file) into another excel file format. Please note that the reoccurence could be more than the 5 cells in this example. That is it could be A1, A11, A21 (10 cells jump)...or A1, A33, A65,..(32 cells jump) etc. but in all cases reoccurence is always constant.

Thanks for helping

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

请先登录，再进行评论。

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

Answer 1

Caroline 2013-8-1

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/83788-extract-values-from-specific-cells-in-excel#answer_93362

You can use xlsread:

http://www.mathworks.com/help/matlab/ref/xlsread.html

For example: num = xlsread(filename,sheet,xlRange) and you can specify xlRange to be whatever columns you want to read and it will save all of the values in the cell array num. Then you could possibly index into that cell array and get the values that you need and save those values in a new array.

The you can use xlswrite:

http://www.mathworks.com/help/matlab/ref/xlswrite.html

xlswrite(filename,A,sheet,xlRange)

where A would be the array that you created

4 个评论
显示 2更早的评论隐藏 2更早的评论

olu 2013-8-1

Hi Caroline, thanks so much for this. It has helped me solve my problem. You are a life saver.

cheers

C G 2018-4-5

How do I combine the values from columns A and B? For example, I would like a new variable with the values from A1 and B1 in the same variable? Then have a new variable containing the values of A2 and B2 in the new variable... and so on.

请先登录，再进行评论。