兩個excel的問題，簡單 ~~~

Question

private void CreateExcelFile(string fileName,string caption,string[,] data)
{
Excel.Application myExcel = new Excel.ApplicationClass();
try
{
if(File.Exists(fileName))
{
object missing =Missing.Value;
myExcel.Application.Workbooks.Open(fileName,missing,missing,
missing,missing,missing,missing,missing,missing,missing,missing,
missing,missing);
myExcel.Visible=true;
myExcel.Cells[1,4] = caption;
for(int i=0;i<=data.GetUpperBound(0);i++)
{
for(int j=0;j<=data.GetUpperBound(1);j++)
{
myExcel.Cells[2+i,1+j]="'"+data[i,j];
}
}
myExcel.Workbooks[1].Save();
myExcel.Workbooks.Close();
}
else
{
myExcel.Application.Workbooks.Add(true);
myExcel.Visible=true;
myExcel.Cells[1,4] = caption;
Excel.XlSaveAsAccessMode asm = Excel.XlSaveAsAccessMode.xlShared;
object Nothing = System.Reflection.Missing.Value;
for(int i=0;i<=data.GetUpperBound(0);i++)
{
for(int j=0;j<=data.GetUpperBound(1);j++)
{
myExcel.Cells[2+i,1+j]="'"+data[i,j];
}
}

myExcel.Workbooks[1].SaveAs(fileName,Nothing,Nothing,Nothing,Nothing,
Nothing,asm,Nothing,Nothing,Nothing,Nothing);
myExcel.Workbooks.Close();
} }
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine("创建Excel文件错误:"+ex.Message);
throw(ex);
}
finally
{
myExcel.Quit();
GC.Collect();

}

}

Answer 1

xlSheet = ( Excel.Worksheet ) xlBook.Worksheets.Add( System.Reflection.Missing.Value ,System.Reflection.Missing.Value ,System.Reflection.Missing.Value ,System.Reflection.Missing.Value  );