MATLAB Answers

0

Replace NaN value to blank in excel

Asked by joo tan on 19 Oct 2012
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?

  0 Comments

Sign in to comment.

2 Answers

Answer by Sachin Ganjare on 19 Oct 2012

I think this what you need:
Hope it helps!!

  2 Comments

This script will perform required operations.
For Example:
Data = readfromexcel(File,'All');
Data = cellNaNReplace (Data,0);

Sign in to comment.


Answer by Azzi Abdelmalek
on 19 Oct 2012

num=xlsread('YourFileName.xls');
num(:,3)=[]

  0 Comments

Sign in to comment.