03-30-2012 11:56 AM
I need to put zero to the empty cells of an column in excel.
My code updates the the column of an excel with the some values but some rows will be empty which dont have values.
So how can i put zero's to the rows once i update my excel coulmn with figures.
I am using %openexcel;
put statement to put the values..
So how can i do it?
04-03-2012 01:39 PM
My excel file is like this
My code is
put unquote(bquote("select(R&rowC&col)");PUT unquote(bquote("&value");
like wise my code updates the excel,but for some there wont be a value so in that place i need to put zero
How can i do this?