Question about excel automation with VC++
-
Hi, I have read some of microsoft tutorial about office automation. Now, i would like to fill a set of range with my application, a dialog box application. I have a set of data which are put into a dynamic array, and i would like to read all the value of the array in excel. Could i do it simply without use the expressions Range("A1")... but something like in VBA cells(i,j)? thanks in advance for your answers gerald
-
Hi, I have read some of microsoft tutorial about office automation. Now, i would like to fill a set of range with my application, a dialog box application. I have a set of data which are put into a dynamic array, and i would like to read all the value of the array in excel. Could i do it simply without use the expressions Range("A1")... but something like in VBA cells(i,j)? thanks in advance for your answers gerald
Range("xy") *IS* cells(x,y). I don't see your point.
sometimes it helps to look at the IL generated code a MS guy on develop.com "answering" .NET issues
-
Range("xy") *IS* cells(x,y). I don't see your point.
sometimes it helps to look at the IL generated code a MS guy on develop.com "answering" .NET issues
if you want to fill cells with a for loop, how we could do that? for(i=1;i<= Bound;i++) { . . } where the term "Bound" could be different for different test( it could be equal to 20 or 10 or another number) If the size of your set of data is always the same, i know i could do it: range.GetRange(COleVariant("A1")),COleVariant("B20")) range.SetValue(COleVariant("2")) and you will see in each cell of the area A1:B20, the number "2". So, know if the width and/or the height change dynamically, how could i fill the set of cells i need? :confused: