Need to write pre-written excel sheet using xlswrite or other function

3 次查看（过去 30 天）
Bhatu
Bhatu 2015-4-29
评论： Bhatu 2015-5-4
For one of my application I want to write specific row & column in excel sheet. My question is with related to "xlswrite" function. My excel is pre-loaded with some data like test report where we mention test case details, description etc.In front of that I want to write a result in the form of PASS or FAIL. Could you please suggest solution how to write specific row column with out deleting other data.

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

采纳的回答

Shrirang
Shrirang 2015-4-29
Hi, 1) You can import the excel sheet in Matlab using xlswrite. Calculate the status of TC and write it in corresponding cell in Matlab and after updating all the cells in Matlab write the whole Matrix in xls using xlswrite function. 2) OR you can just calculate the status of all TC and just write the TC result in xls by specifying the range in xlswrite function. Hope this helps you...

更多回答（1 个）

KL
KL 2015-4-29
You can also use table functions. For example
T = readtable('Book.xlsx')
newdata = [6 6 6 6 6 6 6 6 6 6];
newdata = newdata';
C =array2table(newdata);
T = [T C];
writetable(T,'Book.xlsx');
  1 个评论
Bhatu
Bhatu 2015-5-4
Thanks for reply, I am using 2010a where this function is not available. But I found another solution suggested by Mr. Shrirang.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by