Replace NaN value to blank in excel

10 次查看（过去 30 天）
joo tan
joo tan 2012-10-19
I have excel file with 3 column. The third column has NaN value. i need to replace the NaN value to blank...I not familiar with using excel in matlab .Can help me?

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

回答（2 个）

Sachin Ganjare
Sachin Ganjare 2012-10-19
I think this what you need:
http://www.mathworks.com/matlabcentral/fileexchange/10847
Hope it helps!!
  2 个评论
Sachin Ganjare
Sachin Ganjare 2012-10-19
This script will perform required operations.
For Example:
Data = readfromexcel(File,'All');
Data = cellNaNReplace (Data,0);

请先登录，再进行评论。

Azzi Abdelmalek
Azzi Abdelmalek 2012-10-19
num=xlsread('YourFileName.xls');
num(:,3)=[]

类别

在 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