Sign in to follow this  
Followers 0
GauravM

need help in getting reading data from excel and then to firefox

5 posts in this topic

#1 ·  Posted (edited)

hi, I need help in understanding how I can read data from excel and pass it on to Mozilla firefox. the data i need to get from excel is url,

username and password.  tried below code but not sure about it.

#include <Excel.au3>
Local $oExcel = _Excel_BookOpen(@ScriptDir & "workbookinfo.xlsx", 0, 0)
 
$sCellValue = _Excel_RangeRead($oExcel, "B2")
$sCellValue2 = _Excel_RangeRead($oExcel, "C2")
$sCellValue3 = _Excel_RangeRead($oExcel, "D2")
 
$FF = @ProgramFilesDir & "Mozilla Firefoxfirefox.exe"
 
If FileExists($FF) Then
 
<stuck here> ?????
 
 
Else
 
MsgBox ($IDOK (1),"","no Firefox in this machine")
 
EndIf
Edited by GauravM

Share this post


Link to post
Share on other sites



also tried this code, not sure how i can capture value from excel and pass it  as URL and login info in browser 

#include <Excel.au3>
Local $oExcel = _Excel_BookOpen(@ScriptDir & "workbookinfo.xlsx", 0, 0)
 
$sCellValue = _Excel_RangeRead($oExcel, "B2")
$sCellValue2 = _Excel_RangeRead($oExcel, "C2")
$sCellValue3 = _Excel_RangeRead($oExcel, "D2")
 
 
ShellExecute(@ProgramFilesDir & "Mozilla Firefoxfirefox.exe",$sCellValue,"","open",@SW_HIDE)

Share this post


Link to post
Share on other sites

A backslash is missing, _Excel_Open is missing and _Excel_BookOpen needs an additional parameter.

Be aware that with AutoIt 3.3.12.0 a fully rewritten Excel UDF is being provided. Function names AND parameters have changed.

Local $oExcel = _Excel_Open()
Local $oBook = _Excel_BookOpen($oExcel, @ScriptDir & "\workbookinfo.xlsx", 0, 0)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Thank you sir :) 

Share this post


Link to post
Share on other sites

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - 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  
Followers 0