MATLAB command to replace 0 in Excel

2020 8 26
1 个回答
回答已采纳
更新时间：2020 8 31
1 次查看（30 天）

0 个投票

I have a 27 x 68 matrix written in excel using MATLAB. The cells in excel with value 0 needs to be replaced with a blank for a selected range of "C16:AC83".
Can you please suggest a command to do this.
I am using----- Excel = actxserver('Excel.Application');
so far i have found the command --- Excel.Activesheet.Cells.Replace(65535,[ ],[ ],1);
What is the applicable syntax?

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

 采纳的回答

Alan Moses
Alan Moses 2020-8-31

0 个投票

Hi Akshay,
You can use the readcell function to read a range of values and use the cellfun command to replace the zeros with blanks. You can then use the writecell function to update the excel sheet. For example:
T = readcell('myTable.xls','Range','C16:AC83');
C = cellfun(@(x)x(logical(x)),T,'uni',false);
writecell(C,'myTable.xls','Range','C16:AC83');
Hope this helps!

更多回答（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