Hello,
I am using ActiveX to write data of various types to an Excel file. The data will consist of strings, individual numeric values, numeric arrays, and bitmaps.
Is there a way to use the "Range" function to write an array directly? At the moment I am finding that it is necessary to write each individual value of the array to a specific cell using a FOR loop, rather than specifying a range and then wiring the array into "Value2".
I've attached two pictures. When I run the code in the first picture, which uses the FOR loop, the array gets written correctly to the spreadsheet. When I run the code in the second picture, the first element in the array is written to all of the cells in the specified range. (In the examples that ship with LabVIEW, each array element is processed individually using a FOR loop.)
What am I doing wrong in the second picture? Or is it really necessary to write each individual array element to each individual cell in the spreadsheet?
Please do not tell me to use the "Array to spreadsheet string" function. I already know how to do that. I want to know if there is a way to efficiently write the array using ActiveX functions. If not, that's life...but it never hurts to ask!
