SetRows方法在哪里? [英] Where's the SetRows method ?
问题描述
鉴于我有一组存储在Variant Array中的记录。
可以说,这些值是通过API调用获得的。
没有有效的方法可以将这些值放到新表中?
IOW,我是否必须使用.AddNew逐列逐行迭代? (呃)
我看到了GetRows,但遗憾的是没有SetRows方法!
如果我可以添加2000个新行,然后拨打一个SetRows方法,
表格将在一次通话中更新!
我也在考虑削减和 - 粘贴......但是我看不出它是怎么做的。
想点什么?
Given I have a set of records stored in a Variant Array.
Suffice to say, these values were obtained via an API call.
Is there no efficient method to blow these values into a fresh table ?
IOW, do I have to iterate column by column and row by row using .AddNew ? (Ughh)
I saw GetRows, but sadly there is no SetRows method !
If I could just add 2000 new rows, and then make one call to a SetRows method,
the table would be updated in one call !
I was also thinking of cut-and-paste....but I don't see how it can be done.
Ideas anyone ?
推荐答案
你想要像smth一样Excel中的.CopyFromRecordset?我还不知道,但问题很有趣。
Do you want smth like .CopyFromRecordset in Excel? I have no idea yet but the question is interesting.
这篇关于SetRows方法在哪里?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!