IniFileUtils类见本博客下,其他博客文章!!!
记得在调用方法前加上:
EApp.DisplayAlerts = false;
EApp.ScreenUpdating = false;
方法调用
记得在调用方法后加上:
EApp.DisplayAlerts = true;
EApp.ScreenUpdating = true;
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;
public Excel.Application EApp = new Excel.Application();
public Excel.Workbook wb;
public Excel.Worksheet ws;
/// <summary>
/// Excel导入数据到DataGridView
/// </summary>
/// <returns></returns>
private bool GetDataFromExcel()
{
string storypath = IniFileUtils.ReadIni("ExcelInfo", "storyopenpath", "");
if (string.IsNullOrEmpty(storypath))
{
storypath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);