以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 批量写入table (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=190711) |
-- 作者:puma -- 发布时间:2024/2/29 9:05:00 -- 批量写入table 我从文件夹里循环获取了信息,一个一个写入table有点慢。 可以先读取数组或者list 一次性写入talbe吗? Dim t As Table = Tables("测试表") Dim num(, ) As Integer = {{1, 2, 3} , {4, 5, 6}, {7, 8, 9}} Dim colName As String For i As Integer = 0 To 2 Dim r As Row = t.AddNew() For j As Integer = 0 To 2 If j = 0 Then colName = "第一列" Else If j = 1 Then colName = "第二列" Else colName = "第三列" End If r(colName) = num(i, j) \' r(j - 1) = num(i, j) Next Next
|
-- 作者:有点蓝 -- 发布时间:2024/2/29 9:10:00 -- 没看懂这个代码和文件夹有啥关系 其次数组集合也是要遍历,一样是属于一个一个写入 |