代码:
/// <summary>
/// 打开Excel文件
/// </summary>
/// <param name="ExcelFileName">文件名</param>
private void OpenExcelFile(string ExcelFileName)
{
Excel.Application App = new Excel.Application();
if (App == null)
{
return; //Excel尚未安装
}
Excel.Workbook workbook = App.Workbooks.Open(@ExcelFileName,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
try
{
App.Visible = false;
App.DisplayAlerts = false;
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
ProcessExcelData(workbook);
}
finally
{
App.
