Hi,
I need to fill data into multiple sheets (through script), each with a 2D Table whose columns and rows are limited to 14 and 16 respectively. The values in these columns will come from channels in the Data Portal. I have taken a rather round-about way to accomplish this. I create a new group and copy 16 values from selected channels into channels in this group. I then fill these values into the table, then create another set of channels for the next 16 values, fill them out into the next sheet and so on. But this is a cumbersome process, especially when the data size is large and I will have hundreds of sheets to fill out. Finally, when I delete the temporary channels, all the data in the tables simply disappears !
I believe there must be an easier way to do this. Could you please enlighten me on this asap?
Thanks in advance
Venkatesh Murthy B.L.