I want to automate excel data into a desktop application.
I see that you have entered sheet1 instead of “sheet1”
You need to place quotes on the word if they are of string data type.
Sheet1, B1 that you entered denotes a variable
Just simply put double quotes on them and it’ll be sorted
Give Sheet Name and Range in Double quotes(") like “Sheet1” .
If you want to read the data from particular column and row you need to mention that column number and row number as for ex: “B1”
If you want to read the total sheet then leave the Range as blank or give “”
I hope you understand!!
If you got the solution for your question please mark it as solution to close the thread.
Thank you forum members for giving replies with love. At first I’m afraid that I would be scolded alike in StackOverflow. I am delighted that this forum treats rookies with respect…
Remain that when you are passing the file path, sheet name and range in the workbook activities, excel activities, pdf activities, word activities with in double quotes only because those are in string format.
Hope you understand!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.