如何将Excel数据导入列表视图 [英] How to inport Excel data into listview

问题描述

我现在已经将XML文件转换为Excel工作表...
我想将Excel工作表转移到列表视图中.....
plz help

I have converted XML files into Excel sheet now...
I want to transfer Excel sheet into listview.....
plz help

推荐答案

您实际上可以读取excel表，就像读取数据库表一样.使用oleDB提供程序和正确的连接字符串(例如"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = MyFile.xls; Extended Properties = Excel 8.0;").并且几乎就像数据库一样进行操作.

在 MSDN

You can actually read excel sheet just like you read a database table. Use an oleDB provider and a proper connectionstring (like "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MyFile.xls;Extended Properties=Excel 8.0;"). And do almost the same as if it was a database.

Read more at MSDN

中了解更多信息，但是整个单元格的值都无法读取...
一些值变为空....
在此类问题上该怎么办.

But whole cells values are not reading...
Some values coming null....
what to do on such problem..

这篇关于如何将Excel数据导入列表视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！