iceberg Posted August 14, 2008 Share Posted August 14, 2008 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. Link to comment Share on other sites More sharing options...
iceberg Posted August 14, 2008 Author Share Posted August 14, 2008 i searched for _ExcelSheetUsedRangeGet. where to I get it? mouse not found....scroll any mouse to continue. Link to comment Share on other sites More sharing options...
picaxe Posted August 14, 2008 Share Posted August 14, 2008 You need the udf EXCELCOM_UDF.au3 from here not EXCEL.au3. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now