Sign in to follow this  
Followers 0
iceberg

Excel Question

3 posts in this topic

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.


mouse not found....scroll any mouse to continue.

Share this post


Link to post
Share on other sites



i searched for _ExcelSheetUsedRangeGet.

where to I get it?


mouse not found....scroll any mouse to continue.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0