如何利用后期绑定 Excel 打开或保存文件? http://search.microsoft.com/search/results.aspx?na=84&st=a&View=msdn&qu=save+excel+in+c%23&qp=&qa=&qn=&c=4&s=2看看这里面有没有你需要的! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参考代码:[主题]:OLE Excel 删除Excel Sheet(使用的是office 2003,Excel经过转换了的)[作用]:打开excel文档,删除一个sheet,然后保存 Object refmissing = System.Reflection.Missing.Value; Excel._Application exc = new Excel.ApplicationClass(); exc.Visible = true; Excel.Workbooks workbooks = exc.Workbooks; workbooks._Open("c:\\test.xls",refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing); Excel.Worksheet sheet = (Excel.Worksheet)exc.Worksheets.get_Item(1); sheet.Delete(); exc.Save(refmissing); MessageBox.Show("ok"); 文件远程复制问题,请高手解答! comboBox1和数据库读出来的问题 ultrawinGrid 求助 找不到 Microsoft.Web.Management文件. c#windows 请问:Oracle中如何取记录呢,我的程序有记录,为何出错! 求救 wpf treeview 小组开发的问题! VS.NET中VC#建的ASP.NET解决方案,在启动后,生成的网页中,看不到WEB控件 c#.net中如何自定义datagrid样式。 为何richTextBox1.Lines[i]取行的效率很低,有什么好的办法?
[主题]:OLE Excel 删除Excel Sheet(使用的是office 2003,Excel经过转换了的)
[作用]:打开excel文档,删除一个sheet,然后保存 Object refmissing = System.Reflection.Missing.Value;
Excel._Application exc = new Excel.ApplicationClass();
exc.Visible = true;
Excel.Workbooks workbooks = exc.Workbooks;
workbooks._Open("c:\\test.xls",refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing,refmissing);
Excel.Worksheet sheet = (Excel.Worksheet)exc.Worksheets.get_Item(1);
sheet.Delete();
exc.Save(refmissing);
MessageBox.Show("ok");