Jump to content

How to open Excel file


 Share

Recommended Posts

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') );

Link to comment
Share on other sites

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)
Link to comment
Share on other sites

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

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

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

  • 7 years later...

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

 

Link to comment
Share on other sites

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

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...