Forum Discussion

rraghvani's avatar
rraghvani
Champion Level 3

I was hoping you can share the scripts, so that I don't have to type this out to test it!

 

You are still not indenting your code!

ḥari's avatar
ḥari
Frequent Contributor
2 years ago

Expected. I can type and send, could you please change the excelFile name and folder as per the screenshot please. The below code is executed fine it's fetching the url

 

Using mobile for typing sorry for not indenting code here

Function excelTest() {
envVarfolder = "C:\\Temp"
Var excelFile = Excel. Open (envVarfolder + "Test.xlsx")
Var excelSheet = excelFile.SheetByTitle(" Rate")
Let RowCount = excelSheet. RowCount
Let ColumnCount = excelSheet. ColumnCount

For(let i = 1; i<=RowCount; i ++)
Let url = ""
For (let j= 1;j<=ColumnCount;j++)
url = (varToString(excelSheet.cell(j, i). Value))

Browsers. Item(browser[chrome]). Run(url) 
Var page = Sys.Browsers(browsers[chrome].page("*")) ;
}