int rowIndex=0,colIndex=0,iExcelStartCol=0;
ApplicationClass myApp=null;
Workbook myBook=null;
Worksheet mySheet=null;
myApp= new ApplicationClass();
myApp.Visible=true;
object oMissiong=System.Reflection.Missing.Value;
try
{
myApp.Workbooks.Open(outFilePath,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong);
myBook=myApp.Workbooks[1];
mySheet=(Worksheet)myBook.ActiveSheet;
Range range = (Excel.Range)mySheet.Cells[1,1];
//
//取得表格中的数据
//
rowIndex=8;
foreach(DataRowView row in dv)
{
if(rowIndex!=8)
{
range.Insert(Type.Missing); // 插入一行新的
rowIndex=8;
}
iExcelStartCol=1;
colIndex = 1;
foreach(DataColumn col in dv.Table.Columns)
{
range = (Excel.Range)mySheet.Cells[rowIndex,iExcelStartCol];
range.Value2=row[col.ColumnName].ToString();