Forum Discussion
rraghvani
Champion Level 3
Using a single-backslash is used for escaping certain characters. A double-backslash returns a single slash. Also, the example shows
Are you calling the Open method more than once?
I'm curious to know, what is the full path if you were to run,
fileLocation = Project.Path + "Test Data\DataSheet.xlsx"
Log.Message(fileLocation)
//excelFile = Excel.Open(fileLocation+"Test Data\DataSheet.xlsx")
//excelSheet = excelFile.SheetByTitle["Test Data"]
csachanandani
2 years agoOccasional Contributor
excelFile = Excel.Open("C:\\Automation\\Test Data\\DataSheet.xlsm") didnt work either. Also, Open method is called only once and then we read data from different sheets.
Related Content
- 10 months ago
Recent Discussions
- 13 hours ago
- 2 days ago