Sign in to follow this  
Followers 0
darkshark

Excel?

1 post in this topic

#1 ·  Posted (edited)

|Coluna 1 |Coluna 2|

|Valor 1 |Valor 1|

|Valor 2 |Valor 2|

|Valor 3 |Valor 3|

|Valor 4 |Valor 4|

|Valor 5 |Valor 5|

|Valor 6 |Valor 6|

|Valor 7 |Valor 7|

|Valor 8 |Valor 8|

|Valor 9 |Valor 9|

|Valor 10 |Valor 10|

|Valor 11 |Valor 11|

|Valor 12 |Valor 12|

|Valor 13 |Valor 13|

|Valor 14 |Valor 14|

|Valor 15 |Valor 15|

how to i return all coluns to array?

i've tested this but... dont work =/

local $excel
Local $oExcel = _ExcelBookOpen($sFile, $sExcelReadmode)
    If @error ThenbReturn @error
$excel = _ExcelSheetActivate($oExcel, "1")

thanks in advance

edit:

i've done!

ty ppl!

Func ExceltoArray($sFile, $excelreadmode = 0)
    Local $oExcel = _ExcelBookOpen($sFile, $excelreadmode)
    If @error Then
        $oExcel.application.quit
        Return SetError(0)
    EndIf
    Local $sArray = _ExcelReadSheetToArray($oExcel, 1, 1, 0, 2, True)
    If @error Then
        $oExcel.application.quit
        Return SetError(1)
    EndIf
    $oExcel.application.quit
    Return $sArray
EndFunc   ;==>ExceltoArray
Edited by darkshark

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