读取Excel文件,加载数据到DataGridView
来源:互联网 发布:mac词典词库下载 编辑:程序博客网 时间:2024/05/17 23:35
今天看到个好帖子,感觉很有用,很新鲜,贴出来备忘。代码未经测试,领会精神。
Public Class Form1Class Form1
Private Sub Button1_Click()Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim tb As DataTable = Nothing
Using dlg As New OpenFileDialog
With dlg
.Filter = "*.xls|*.xls"
.Multiselect = False
If .ShowDialog = Windows.Forms.DialogResult.OK Then
Dim db As New LzmTW.Data.ExcelDatabase(.FileName)
Dim tables As DataTable = db.GetConnectionSchema("Tables")
'只取第一个
Dim firstSheet As String = tables.Rows(0)("TABLE_NAME").ToString
tb = db.GetDataTable("[" & firstSheet & "]")
End If
End With
End Using
If Not tb Is Nothing Then
Me.DataGridView1.DataSource = tb
End If
End Sub
End Class
Private Sub Button1_Click()Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim tb As DataTable = Nothing
Using dlg As New OpenFileDialog
With dlg
.Filter = "*.xls|*.xls"
.Multiselect = False
If .ShowDialog = Windows.Forms.DialogResult.OK Then
Dim db As New LzmTW.Data.ExcelDatabase(.FileName)
Dim tables As DataTable = db.GetConnectionSchema("Tables")
'只取第一个
Dim firstSheet As String = tables.Rows(0)("TABLE_NAME").ToString
tb = db.GetDataTable("[" & firstSheet & "]")
End If
End With
End Using
If Not tb Is Nothing Then
Me.DataGridView1.DataSource = tb
End If
End Sub
End Class
- 读取Excel文件,加载数据到DataGridView
- Excel中数据读取到datagridview
- winform打开Excel读取数据并显示到datagridview中
- winform打开Excel读取数据并显示到datagridview中
- C# 读取excel到datagridview
- NPOI读取EXCEL到datagridview
- 用c#读取excel文件,写到datagridview控件中
- DataGridView导出数据到Excel
- datagridview数据导出到excel
- 保存DataGridView数据到excel
- DataGridView数据导出到Excel
- DataGridView数据显示到Excel
- DataGridView导出数据到Excel
- 导入excel文件到datagridview
- lua加载文件 读取数据到C
- VB.NET 打开Excel文件,读取Excel内容,添加到DataGridView中并显示
- VB.NET 打开Excel文件,读取Excel内容,添加到DataGridView中并显示
- EXCEL:读取多个EXCEL文件数据到WORD文档
- 【转】Subsonic的添加和更新、删除操作
- 【zz】进程间通讯的方法
- PPTP client config on Fedora 7 and 8
- 生成验证码图片(.net2005/c#)
- Squid配置详解
- 读取Excel文件,加载数据到DataGridView
- ITSM的自助服务--小记remedy7.0的SRMITSM
- OWC绘图控件研究
- 如何成为一个受欢迎的项目经理
- SEO资料的迷思
- 一个可以可以把cpu主频长时间占用到100%的pl sql
- 黑客帝国,社会化网络
- IT职业规划之从开发人员到行业专家
- JSON入门