C# 打开EXCEL 如何保存

m_objExcel = new Excel.Application();
m_objExcel.Visible = true;

Excel.Workbook m_objBook = m_objExcel.Application.Workbooks.Add(FileWrite);
m_objBook = m_objExcel.Workbooks.Add(Missing.Value);

Excel.Worksheet m_objSheet = (Excel.Worksheet)(m_objBook.Worksheets[1]);


m_objRange = m_objSheet.get_Range("A5", Type.Missing);

//存放报表数据的二维数组
object[,] objdate = new object[rownum, 9];

.......................

.......................
m_objRange = m_objSheet.get_Range("A5", Missing.Value);
m_objRange = m_objRange.get_Resize(rownum, 9);
//水平对齐--右对齐
m_objRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;
//文本格式
m_objRange.NumberFormat = "@";
m_objRange.Value2 = objdate;

//保存并施放EXECL资源

m_objBook.Saved = true;
m_objExcel.DisplayAlerts = false;

m_objSheet._Saves (FileWrite,Missing.Value,Missing.Value,Missing.Value,Missing.Value, 
        Missing.Value,Missing.Value,Missing.Value,Missing.Value);       
m_objBook.Close(false, Missing.Value, Missing.Value);
if (m_objExcel != null)
{
m_objExcel.Workbooks.Close();
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
System.GC.Collect();
}

if (m_objSheet != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
System.GC.Collect();

GC.Collect();

这样写可以 VS2008测试通过

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值