.net缂栫▼瀵筗ORD/EXCEL鍐呭杩涜鏇挎崲

鏂囩珷鎽樿:0 Object Library锛� 2銆佸湪鏂囦欢鐨刄SING閮ㄥ垎鍔犲叆浠ヤ笅鍛藉悕绌洪棿锛� using Microsoft. Missing. Value, Missing. Missing. Value , Missing. Missing. Value, Missing. Missing. Value , Missing. Missing. Value, Missing. Missing. Value, Missing. Missing. Value, Missing.
一流信息监控拦截系统提醒您：很抱歉，由于您提交的内容中或访问的内容中含有系统不允许的关键词或者您的IP受到了访问限制，本次操作无效，系统已记录您的IP及您提交的所有数据。请注意，不要提交任何违反国家规定的内容！本次拦截的相关信息为：googlesyndication
欢鍚�

Workbook wb = excel.Workbooks._Open(modelFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value

, Missing.Value, Missing.Value, Missing.Value, Missing.Value

, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

Worksheet xSheet = (Worksheet)wb.Sheets[1];

int icount = wb.Sheets.Count;

for (int i = 1; i <= icount; i++)

{

(鐢佃剳琛� http://www.computerj.com娆㈣繋鎮ㄣ��)try

{

xSheet = (Worksheet)wb.Sheets[i];

object what = strOld; //鏌ユ壘瀛楃涓�

object retxt = strNew; //鏇挎崲瀛楃涓�

xSheet.Cells.Replace(what, retxt, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

}

catch

{

}

}

wb.Save();

NAR(xSheet);

wb.Close(false, Missing.Value, Missing.Value);

NAR(wb);

excel.Quit();

NAR(excel);

System.GC.Collect();

}

private void NAR(object o)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseComObject(o);//寮哄埗閲婃斁涓�涓璞�

}

catch

{

}

finally

{

o = null;

}

}