数据导入excel中速度的问题?为什么很慢,而且cpu占用很多?
奈伊组特 2004-10-18 03:33:22 我是这样写的:
Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "路径")
conn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "路径")
conn.Open()
Dim da As New OleDb.OleDbDataAdapter("select * from TABLE", conn)
Dim ds As New DataSet
da.Fill(ds, "table")
Dim xsheel As New Excel.Application
xsheel.Workbooks.Open("c:\data.xls")
xsheel.Visible = True
Dim rowIndex As Integer
Dim colIndex As Integer
Dim Col As DataColumn
Dim Row As DataRow
rowIndex = 3
colIndex = 1
'得到的表所有行,赋值给单元格
For Each Row In temptable.Rows
rowIndex = rowIndex + 1
colIndex = 0
For Each Col In temptable.Columns
colIndex = colIndex + 1
xsheel.Cells(rowIndex, colIndex) = Row(Col.ColumnName)
Next
Next
ds.Dispose()
conn.Close()
这样数据只有五百左右就很慢了,而且cpu占用是100% 怀疑是for循环的问题. 但是我是需要把数据导入已建表中 行和列都要定位,有什么办法能使cpu不占用那么多,最好速度也能快一点.不过关键是不要100%的占用cpu,否则就像死机一样. 请指教,谢谢!