经过.NET能够操作Excel，如新建文件，新建Workbook，设置单元格等等。下面就介绍一些常用的.NET Excel操作技巧。

1. 创立一个新Excel的Application:

Applicationexc=newApplication(); 
if(exc==null){ 
Console.WriteLine("ERROR:EXCELcouldn'tbestarted"); 
return0; 
}

2. 让这个工程可见:

exc.set_Visible(0,true);

3. 获取WorkBooks调集:

Workbooksworkbooks=exc.Workbooks;

4. 参加新的WorkBook:

_Workbookworkbook=workbooks.Add(XlWBATemplate.xlWBATWorksheet,0);

5. 获取WorkSheets调集:

_Worksheetworksheet=(_Worksheet)sheets.get_Item(1); 
if(worksheet==null){ 
Console.WriteLine("ERRORinworksheet==null"); 
}

6. 给单元格设置变量：

Rangerange1=worksheet.get_Range("C1",Missing.Value); 
if(range1==null){ 
Console.WriteLine("ERROR:range==null"); 
} 
constintnCells=1; 
Object[]args1=newObject[1]; 
args1[0]=nCells; 
range1.GetType().InvokeMember("Value",BindingFlags.SetProperty,null,range1,args1);

.NET Excel操作技巧例程:

usingSystem; 
usingSystem.Reflection; 
usingSystem.Runtime.InteropServices; 
usingExcel; 
classExcel{ 
publicstaticintMain(){ 
Applicationexc=newApplication(); 
if(exc==null){ 
Console.WriteLine("ERROR:EXCELcouldn'tbestarted!"); 
return0; 
} 
exc.set_Visible(0,true); 
Workbooksworkbooks=exc.Workbooks; 
_Workbookworkbook=workbooks.Add(XlWBATemplate.xlWBATWorksheet,0); 
Sheetssheets=workbook.Worksheets; 
_Worksheetworksheet=(_Worksheet)sheets.get_Item(1); 
if(worksheet==null){ 
Console.WriteLine("ERROR:worksheet==null"); 
} 
Rangerange1=worksheet.get_Range("C1",Missing.Value); 
if(range1==null){ 
Console.WriteLine("ERROR:range==null"); 
} 
constintnCells=1; 
Object[]args1=newObject[1]; 
args1[0]=nCells; 
range1.GetType().InvokeMember("Value",BindingFlags.SetProperty,null,range1,args1); 
return100; 
} 
} 

现在咱们来看看怎么运用数组，他有些类似于设置单元格。仅仅需求的改动仅仅args2[0] = array2;

constintnCell=5; 
Rangerange2=worksheet.get_Range("A1","E1"); 
int[]array2=newint[nCell]; 
for(inti=0;i<array2.GetLength(0);i++){ 
array2[i]=i+1; 
} 
Object[]args2=newObject[1]; 
args2[0]=array2; 
range2.GetType().InvokeMember("Value",BindingFlags.SetProperty,null,range2,args2);

以上就介绍了一些常用的.NET Excel操作技巧，期望对我们有所协助。

【修改引荐】

1. 将查询数据经过C#导入Excel表的简略办法
2. C# Excel COM组件的运用
3. C# 操作Excel之写入Excel操作浅析
4. C# 操作Excel根底实例浅析
5. C# 操作Excel之Excel操作办法调用