ActiveQt + Excel

[wysota]

Your questions are a bit out of scope of this forum. You're asking for information about Excel API, which has nothing to do with Qt and I'm afraid we're simply not qualified to answer them.


BTW. Shouldn't you iterate starting from 0 instead of 1?

[nile.one]

ok, sorry for offtopic

BTW. Shouldn't you iterate starting from 0 instead of 1?

No, Micro$oft starts counting from 1

[bst]

Hi,

you can only fill a horizontal range with an 1-dim Array, for a vertical range you need a 2-dim array.

And, also M$ often counts beginning with 1, here that shouldn't matter.

In VBA you could code it like this.

HTH, Bernd
--

Option Explicit
 
Sub x()
   Dim i%, arHor(22 To 25), arVer(10 To 12, 99 To 99)
 
   For i = 22 To 25
      arHor(i) = i
   Next
   Range("A1:D1") = arHor
 
   For i = 10 To 12
      arVer(i, 99) = i
   Next
   Range("A2:A4") = arVer
End Sub

Option Explicit

Sub x()
   Dim i%, arHor(22 To 25), arVer(10 To 12, 99 To 99)
   
   For i = 22 To 25
      arHor(i) = i
   Next
   Range("A1:D1") = arHor
   
   For i = 10 To 12
      arVer(i, 99) = i
   Next
   Range("A2:A4") = arVer
End Sub

To copy to clipboard, switch view to plain text mode 

[nile.one]

Thanks, but unfortunately QAxObject doesn't support 2-dimensional arrays (i.e. QVariant doesn't support)

[jpn]

Actually you can make QVariant support basically anything.. See Q_DECLARE_METATYPE for more details.