how to trim Col0&Row0

[inote]

#include
#include

$sFilePath1 = @ScriptDir & "\TEP.HD#1.xlsx" ;This file should already exist
$oExcel = _ExcelBookOpen($sFilePath1,@SW_MAXIMIZE)
Send("{CTRLDOWN}{PGDN}{CTRLUP}")
sleep (1000)

$aArray = _ExcelReadSheetToArray($oExcel,1,1,41,4) ;Using Default Parameters
_ArrayDisplay($aArray, "Array using Default Parameters")
MsgBox(0, "Exiting", "Press OK to Save File and Exit")

_ArrayToClip($aArray)
ClipGet()

_ExcelBookClose($oExcel) ; And finally we close out
If @error = 1 Then
MsgBox(0, "Error!", "Unable to Create the Excel Object")
Exit
ElseIf @error = 2 Then
MsgBox(0, "Error!", "File does not exist - Shame on you!")
Exit
EndIf

Here is my Array result

How can I ?

- want to trim Row[0] and Col[0] that's added , i want to use only my data (Col1 Row 1)

- Copy Array to Clipboard

PS. i try to use

_ArrayToClip($aArray)
ClipGet()

and Paste on Notepad but nothing there

Thx so much

Edited April 22, 2013 by inote

[water]

What is

Send("{CTRLDOWN}{PGDN}{CTRLUP}")

supposed to do?

[inote]

What is

Send("{CTRLDOWN}{PGDN}{CTRLUP}")

supposed to do?

In Excel i've 2 sheet >>> so i send this for go to 2nd sheet

[water]

- want to trim Row[0] and Col[0] that's added , i want to use only my data (Col1 Row 1)

Try

$aArray = _ExcelReadSheetToArray($oExcel,1,1,41,4, True) ;Using Default Parameters

Edited April 22, 2013 by water

[water]

In Excel i've 2 sheet >>> so i send this for go to 2nd sheet

Use

_ExcelSheetActivate($oExcel, 2)

to make it more reliable.

[inote]

Try

$aArray = _ExcelReadSheetToArray($oExcel,1,1,41,4, True) ;Using Default Parameters

that's the same result

[inote]

Use

_ExcelSheetActivate($oExcel, 2)

to make it more reliable.

Thx so much

[water]

- Copy Array to Clipboard

You have to use function "ClipPut" to write the array to the clipboard.

[water]

To delete the first row you need to use

$aArray = _ExcelReadSheetToArray($oExcel,1,1,41,4) ;Using Default Parameters
_ArrayDelete($aArray, 0)

[inote]

You have to use function "ClipPut" to write the array to the clipboard.

so i've to use ClipPut($aArray) , isn't it ?

[water]

ClipPut expects a string. In a perfect world you would use _ArrayToString to convert the array to a string. Unfortunataley _ExcelSheetReadToArray returns a two-dimensional array. _ArrayToString only allows one-dimensional arrays.

You either have to search the forum for a version of _ArrayToString that supports 2D-arrays or write it yourself.

[inote]

To delete the first row you need to use

$aArray = _ExcelReadSheetToArray($oExcel,1,1,41,4) ;Using Default Parameters
_ArrayDelete($aArray, 0)

Nothing change there's still 1st row

ClipPut expects a string. In a perfect world you would use _ArrayToString to convert the array to a string. Unfortunataley _ExcelSheetReadToArray returns a two-dimensional array. _ArrayToString only allows one-dimensional arrays.

You either have to search the forum for a version of _ArrayToString that supports 2D-arrays or write it yourself.

i'm a newbie that's too hard for me , i don't understand

but I've search and find How can i use it for my code

[water]

Nothing change there's still 1st row

But the row saying "41 4" is gone?

[inote]

But the row saying "41 4" is gone?

No ,