显示excel在datagridview以及在spreedsheet显示excel(office2010)

在这里我提供两种显示excel数据的方式，虽然这些都已经不符合微软官方的要求，但是给其他一些做项目的小朋友一些参考意见，至少不会不知道怎么去解决客户交代的需求。首先先介绍如何在spreedsheet中展示该数据，先要下载安装微软office 2003的add-ins,链接地址是

http://www.microsoft.com/downloads/en/details.aspx?familyid=7287252c-402e-4f72-97a5-e0fd290d4b76&displaylang=en

其次把该控件拖到winform窗体上，接着使用下列代码：

string strFileName = Environment.CurrentDirectory + @"/1.xlsx"; if (System.IO.File.Exists(strFileName)) OpenXmlMethod.ShowExcelInControl(strFileName, SpreadsheetResult); else MessageBox.Show("This file don't exist,please click /"OpenXmlCreateExcelFile/" Button firstly");

 

OpenXmlMethod.ShowExcelInControl是这样的：

Microsoft.Office.Interop.Excel.Application ThisApplication = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook ThisWorkBook; object missing = System.Reflection.Missing.Value; ThisWorkBook = ThisApplication.Workbooks.Open(txtExcelFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); Microsoft.Office.Interop.Excel.Worksheet ThisSheet = (Microsoft.Office.Interop.Excel.Worksheet)ThisWorkBook.Sheets[1]; ThisApplication.Visible = false; // Read data from template ThisSheet.Cells.Select(); ThisSheet.Cells.Copy(); Result.ActiveSheet.Cells.Select(); Result.ActiveSheet.Cells.Paste(); // Release resource about Excel application. ThisWorkBook.Close(null, null, null); ThisApplication.Workbooks.Close(); ThisApplication.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisApplication); System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisSheet); System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWorkBook); ThisSheet = null; ThisWorkBook = null; ThisApplication = null; GC.Collect();

 

记住最后要gc释放，否则任务管理器一直会保留excel进程。

 

第二种办法是用datagridview显示execl2010数据，也先要去安装一个有Microsoft.ACE.OLEDB.12.0，地址在

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en

 

 

这个安装好了就能用一下代码去显示数据了.

string strFileName = Environment.CurrentDirectory + @"/1.xlsx"; string Path = "c:/Book1.xlsx"; string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [mySheet$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new DataSet(); myCommand.Fill(ds, "table1"); MessageBox.Show(ds.Tables["table1"].Rows.Count.ToString()); dg.DataSource = ds.Tables[0];

 

这种办法虽然能够显示数据，但是不能够显示数据的格式，所以最好用webbrowse，但是有没有做技术的兄弟知道如何用webbrowse显示excel2010数据的，有的话不吝赐教。