从Excel工作表中读取数据并插入到SQL Server中
问题描述：
你好，
我想从.xls文件中的不同工作表中读取数据.我还需要对照同一文件中的其他工作表来验证此数据.
然后，我需要将一些数据存储在veriables中，并相应地生成更多数据.
在asp.net中编程时，我从未使用过.xls.请指导我.
(我正在使用asp.net 3.5)
提前谢谢..
Hello,
I want to read data from different worksheets in a .xls file. I also need to verify this data against other worksheets in same file.
Then i need to store some of the data in veriables and generate some more data accordingly.
I have never worked with .xls while programming in asp.net. Please guide me..
(I am using asp.net 3.5)
Thanks in advance..
答
检查这些链接..
从excel中读取数据 [ http://www.spreadsheetgear.com/support/samples/excel.aspx [ ^ ]
check these links..
Read Data from excel[^]
http://www.spreadsheetgear.com/support/samples/excel.aspx[^]
请参阅此链接可能会帮助您...
[ ]
http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx [ ^ ]
Refer this link it may help you...
[]
http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx[^]