Excel Question

[iceberg]

hi guys,

this is what I have so far....

#include <Excel.au3>

$sFilePath1 = @ScriptDir & "\Test.csv"
$oExcel = _ExcelBookOpen($sFilePath1, 0, True)

For $i = 2 To 100
    $sCellValue = _ExcelReadCell($oExcel, 1, $i)
    MsgBox(0, "", "The Cell Value is: " & @CRLF & $sCellValue, 2)
Next

_ExcelBookClose($oExcel, 0, 0)

depending on the CSV file, the FOR function needs to be flexible...meaning how do I determine the last data entered column on row 1?

thanks.

[iceberg]

i searched for _ExcelSheetUsedRangeGet.

where to I get it?

[picaxe]

You need the udf EXCELCOM_UDF.au3 from here not EXCEL.au3.