Hi Reza,
You could change zeroes to missing values (is that what you mean by remove?) in all book/sheets using script such as below.
Copy and paste all lines to script window, then highlight all lines and press Enter to execute.
The wreplace X-Function used in this script is same as the dialog that opens from the Worksheet: Replace menu
Easwar
OriginLab
// Loop over all workbooks
doc -e W {
type Processing book: %(page.name$);
// Loop over all sheets in current book
doc -e LW {
type " Processing sheet: %(layer.name$)";
// Replace 0 with missing values in current sheet using wreplace X-Function
wreplace rng:=!(1:end) type:=num find_value:=0 cond_value:=eq replace_value:=0/0;
}
}
Find & Replace in all worksheets
Posted - 06/22/2009 : 05:34:57 AM
