62,254
社区成员
发帖
与我相关
我的任务
分享导入excel的标题行到datagrid
读取一个excel文件，把其中一个sheet的标题行所有字段读取到datagrid中，现在可以做到读取 excel的sheet，可以采集标题行区域，例如：a1:g1,得到sql语句:Select * from [Sheet1$A1:G1],就是不知道怎样读里面的标题行到datagrid中去，用oledb连接excel，程序用vb.net，请指教
...全文
请发表友善的回复…
发表回复
littlekeen 2005-10-19
- 打赏
- 举报
up
hxc0906 2005-10-19
- 打赏
- 举报
我这里的标题行不一定是第1行，导入标题行之前由客户先指定，例如：a4:g4，表示这一行是标题行
孟子E章 2005-10-19
- 打赏
- 举报
和你的连接字符串写的有关系
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
hxc0906 2005-10-19
- 打赏
- 举报
简单来说，就是知道excel文件的路径已经sheet名称，怎么样把sheet里的标题行导入到listbox里面去绑定？
