Hi!
Im trying, as many other programmers, to r/w to an Excel file. I saw Alain Samoun's example, it was pretty good. Prob is that following his example, EXCEL.EXE remains resident into memory which can lead to a total server crash.
I also want a listing of all functions & methods of COM objects for handling Excel files. For example, how can I know when I hit the end of a column? Each blank spaces are returned as 0 by $cell->value. Prolly there's like a $cell->Min (would be A1) and $cell->Max (would be, "AF35").
Thanks.