9 posts in this topic
I am a beginner and I am currently learning and practicing what Autoit can do, so kindly pardon if it sound's silly.
What my program does ----> I had written a program where I have a FOR (i=0 to n) loop which is running for n times. Inside the FOR loop, contents of array is written into excel using _Excel_RangeWrite .
_Excel_RangeWrite($oExcelDoc, $oExcelDoc.Activesheet, $arrayname, "A1") Problem ------> During every loop run the contents of column A is only altered
What i intend to do ------> For every loop run (i=0,1,2,3...) I want to write the array contents into respective next adjacent excel columns
i.e) For i=0 loop, every array content should be written in A Column of excel
For i = 1 loop, every array content should be written in B Column of excel.
Can anyone give me an idea of how can i do this? Thanks
First, I thank you for all the help I received here with Excel UDFs and COM objects in the last few days/week.
I would like to "pimp" my output excel a bit, and for that I would like to write some results Bold.
How do I do that?
I tried a few things but most return errors, or doesn't do a thing seemingly.
My code right now, this does run, but doesn't make the inserted results bold. (by inserted I mean what I write with _Excel_RangeWrite)
_Excel_RangeWrite($ExcelObject, $ExcelObject.Activesheet, "=" & $OSSZEGoszlop & $CellaOlvasoSzamlalo & "*" & String($ArfolyamArray[$DateArrayTimeIndex]) & "", String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo) $ExcelObject.Activesheet.Range(String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo).Bold = True Thank you for the help!
Edit: I leave this here, added the bold tag, maybe someone find it usefull