efi Posted April 8, 2012 Share Posted April 8, 2012 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 More sharing options...
DCCD Posted April 8, 2012 Share Posted April 8, 2012 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) [u][font=Arial Black]M[/font]y Blog, AVSS Parts[/u][font=Arial Black]Else[/font][font=Arial Black]L[/font]ibya Linux Users Group Link to comment Share on other sites More sharing options...
water Posted April 8, 2012 Share Posted April 8, 2012 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 - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Cooler Posted April 16, 2019 Share Posted April 16, 2019 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..! Link to comment Share on other sites More sharing options...
Nine Posted April 16, 2019 Share Posted April 16, 2019 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 “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
water Posted April 16, 2019 Share Posted April 16, 2019 @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 - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now