How to open Excel file

[efi]

Hi,

I am trying to open Excel file but unsuccessfully. Could somebody help me about that?

Local $sFilePath1 = “C\Efi\AutoIt\\All orcad parts and libs _ for play.xlsx" ;This file already exists!

Local $oExcel = _ExcelBookOpen($sFilePath1)

Thanks

ipb.global.registerReputation( 'rep_post_977523', { domLikeStripId: 'like_post_977523', app: 'forums', type: 'pid', typeid: '977523' }, parseInt('0') );

[DCCD]

Did you get any error messages?

Try this

#include <Excel.au3>
Local $sFilePath1 = @ScriptDir & "zzzzd.xls" ;This file should already exist
If Not FileExists($sFilePath1) Then
MsgBox(16, '', 'Does NOT exists')
Exit
EndIf
Local $oExcel = _ExcelBookOpen($sFilePath1)

[water]

You have two backslashes in your filename and the drive letter is incomplete:

“C:EfiAutoItAll orcad parts and libs _ for play.xlsx"

[Cooler]

If the excel consists of many sheets (Eg: Sheet 1, Sheet 2, Sheet 3, etc.,). I want to open Sheet 2. How'll i get that..!

 

[Nine]

You can't just open one sheet out of the workbook.  But you can activate that one sheet you want like this :

Local Const $ExcelFile = "YourFile.xls", $TargetSheet = "Sheet2"
$oExcel = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error starting", "@error = " & @error)
$oWorkbook = _Excel_BookOpen($oExcel, $ExcelFile)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error opening workbook","@error = " & @error)
Sleep (1000)
$oWorkbook.Sheets($TargetSheet).Activate

 

[water]

@Cooler
Please do not necro a 7 years old thread. Open a new one and you will get much more attention