1、c#打开EXCEL文件
方法一:(调用Excel的COM组件)
按钮的点击事件如下:
private void button1_Click(object sender, EventArgs e)
{
Excel.Application excel = new Excel.Application(); //引用Excel对象
Excel.Workbook book = excel.Application.Workbooks.Add("c:\\test.xls"); //引用Excel工作簿
excel.Visible = true; //使Excel可视
}
方法二:利用命令行,我们在开始→运行里输入c:\\test.xls,后如果电脑安装有Excel的话他也会自动的打开这个文件,代码如下:
private void button1_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("c:\\test.xls");
}
2、c#连接EXCEL文件
public void OpenExcel(string excelPath)
{
string path = excelPath.Trim();
// string strConn = "provider = Microsoft.jet.oledb.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0\"";//打开2003
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=YES\";";//打开2007
OleDbConnection oleConn = new OleDbConnection(strConn);
try
{
oleConn.Open();
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
}