Excel Udf Help

[litlmike]

I have taken a look at the Excel UDF, and can't make much sense of it.

1) How do I create and excel file?

2) How do I create a worksheet on that excel file?

3) How do I add data to a worksheet on that excel file?

Thanks in advance.

[big_daddy]

1) How do I create and excel file?

_XLCreateBlank($s_FilePath)

2) How do I create a worksheet on that excel file?

This is only needed if you wish to create an additional sheet.

_SheetAdd($sFilePath, $Sheet, $ExcelValue)

3) How do I add data to a worksheet on that excel file?

_XLwrite($sFilePath, $Sheet, $Column, $Row, $ExcelValue)

Here is an example:

#include <ExcelCom.au3>

$FilePath = @ScriptDir & "\Test.xls"
_XLCreateBlank($FilePath)
_XLWrite($FilePath, 1, "A", 1, "This", "Visible")
_XLWrite($FilePath, 1, "A", 2, "is", "Visible")
_XLWrite($FilePath, 1, "A", 3, "a", "Visible")
_XLWrite($FilePath, 1, "A", 4, "test", "Visible")

Edit:Added an example

Edited April 19, 2006 by big_daddy