C# 实现将excel (2007版的)数据导入界面或者datatable中,在将数据保存到数据库。求源代码,
谢谢!
谢谢!
解决方案 »
- 高手说下
- winform中notifyIcon控件每弹出一个窗体就多一个图标
- 新手求助,用C#做了个winform程序,现在要实现读卡器刷卡功能,不知道如何下手了。求各位高手帮忙
- C#WinForm中怎么使用ActiveX
- 熟悉Chart控件的高手,帮帮忙!!!
- 向自己的的网站添加信息的程序
- 急!谁会用SharpZipLib下的Encryption?
- ComboBox跑焦点的问题
- 关于TFS2010:*.vspscc以及*.vssscc被提交到代码管理服务器上是否正常??!
- 客户端(Customer 不同的Nat)如何实时获取到后台(java Server端)推送的消息内容
- JS中将\替换成/,JS改变图片src
- 急急急!安装vs2010 老提示需要windows service pack 3
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
strExcel = "select * from [Sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds);
http://download.csdn.net/source/3034170
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
strExcel = "select * from [Sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
DataSet ds = new DataSet();
myCommand.Fill(ds);--------------------
dataset 值为空,我用的是offic 2007的
vs2008打开vs2010的解决方案
打开了,谢谢。高手啊,我是初学者,你有msn号活着QQ号吗,发邮箱 [email protected].
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";Provider=Microsoft.Jet.OLEDB.4.0;是不能使用的
http://www.microsoft.com/downloads/zh-cn/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891
Dim strConn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & excelpath & ";Extended Properties='Excel 8.0;HDR=yes'" '''这个适用于2007
Dim myda1 As OleDbDataAdapter
Dim MyConnection As OleDbConnection
Dim myds1 As DataSet
MyConnection = New OleDbConnection(strConn)
myda1 = New OleDbDataAdapter("select * from [sheet1$]", MyConnection)
myds1 = New DataSet()
'If CD1.ShowDialog() = System.Windows.Forms.DialogResult.Cancel Then ''''这样做有一点小bug
If r = System.Windows.Forms.DialogResult.Cancel Then
MsgBox("您选择了取消!")
Exit Sub
Else
myda1.Fill(myds1, "[sheet1$]")
MyConnection.Close()
DataGridView1.DataSource = myds1.Tables(0)
End If
却最多只能显示255列,可能是数据引擎的原因,有哪位大侠帮个忙解决下???谢谢