怎么把一个cvs文件的sheet内容复制到一个Excel模板文件中?

Question

目前有个cvs文件,想把它里面的表格内容都复制到一个定义好了的Excel模板文件中,这样就可以定制模板格式了.我用了Excel.Worksheet的copy函数,但看来 没有用,cvs的表格内容并没有复制到模板文件中.不知道应该怎么做?请各位高手指点,谢谢 :)

Answer 1

下面就是我的程序,我发现temp,temp1得到的值都是System.__ComObject,这是不是说明我根本就没有读取到这两个excel文件里面的内容啊?cvs文件能够用这种方式打开吗?
Excel.Application app = new Excel.ApplicationClass();
app.Visible = true;
object missing = System.Reflection.Missing.Value;  
HttpContext hCurrent = HttpContext.Current;
string TemplateFile =hCurrent.Request.PhysicalApplicationPath  + @"Template\\Temp.xls"; Excel.Workbook workCvs = app.Workbooks.Open("D:\\test.xls",missing,missing,missing,missing,missing,
missing,missing,missing,missing,missing,missing,missing);  //打开模板文件，得到WorkBook对象
Excel.Workbook workBook = app.Workbooks.Open(TemplateFile,missing,missing,missing,missing,missing,
missing,missing,missing,missing,missing,missing,missing);  //templetFile 模板文件路径
 
//得到WorkSheet对象
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);
Excel.Worksheet cvsSheet = (Excel.Worksheet)workCvs.Sheets.get_Item(1); string temp = cvsSheet.Cells[1,2].ToString();
string temp1= workSheet.Cells[1,2].ToString();

workSheet.Copy(missing,workCvs.Sheets.get_Item(1));
workBook.SaveAs("d:\\test2.xls",missing,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlNoChange,missing,missing,missing,missing);

//workBook.Close(null,null,null);
workBook.Close(false,missing,missing);
app.Workbooks.Close();
app.Application.Quit();
app.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(workSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(app); workSheet=null;
workBook=null;
app=null; GC.Collect();