110,534
社区成员
发帖
与我相关
我的任务
分享
namespace ConsoleApplication
{
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;
internal class Program
{
internal static void Main(string[] args)
{
try
{
ExcelOperation(args[0]);
}
finally
{
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
}
}
private static void ExcelOperation(string filename)
{
// 这里使用Excel对象
Excel.Application excelApplication = new Excel.Application();
object missing = System.Reflection.Missing.Value;
try
{
excelApplication.Workbooks.Open(
filename,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing,
missing);
// 一些操作
}
finally
{
excelApplication.Workbooks.Close();
excelApplication.Quit();
}
}
}
}
excelApplication = null;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();