Write operation using Activexserver command

I have 4 array, a = [1 2 3] b=[4 5 6] c=[8 9 10], text=[num1 num2 num3]

I need to write to excel sheet where a in sheet1, b in sheet2, c in sheet3 and i also should have header for three sheet as it is mentioned in text?

How can I do this?

Thanks a lot

Answer 1

[Thomas Koelen]

ws = wb.Worksheets.Item('sheetname');

Insert this before you put something in the sheet, that way it will in what sheet to put it. 'sheetname' is the name of the sheet you are trying to change, you can get these sheets with the xlsinfo command (or do it manually).