_Excel_RangeDelete Syntax

[Hoth2001]

I'm a newbie. And after watching an online tutorial for automating Excel  I've written some simple code to open an excel workbook

#include<Excel.au3>

Local $oExcel_1 = _Excel_Open()
Local $sWorkbook = "C:\Users\User\Desktop\CPMautomatorTest.csv"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)

Next thing I want to do is delete Rows 2 through 10 in the workbook I've just opened.

I'm not clear about the syntax and referring to the right objects.

I Tried with this code:

#include<Excel.au3>

Local $oExcel_1 = _Excel_Open()
Local $sWorkbook = "C:\Users\User\Desktop\CPMautomatorTest.csv"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)

Local $oWorkbook = _Excel_RangeDelete($oExcel_1, "2:10")

Which opens the workbook but does not delete the rows I want.

 

Please help with the syntax error

[Bowmore]

Have another read of the help file for _Excel_RangeDelete() It takes a worksheet object as the first parameter

 

#include<Excel.au3>

Local $oExcel_1 = _Excel_Open()
Local $sWorkbook = "C:\Users\User\Desktop\CPMautomatorTest.csv"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)

Local $result = _Excel_RangeDelete($oWorkbook.Worksheets("Sheet1"), "2:10") ;Deletes Rows 2 to 10 on Sheet1