Jump to content
Sign in to follow this  
efi

How to open Excel file

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

Share this post


Link to post
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)

Share this post


Link to post
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 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

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..!

 

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
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 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-30 - Version 1.6.2.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...