in reply to Recover Excel datas

Isn't this essentially the same as the issue reported in Recover Excel data from cells with Foreach loop?

Replies are listed 'Best First'.
Re^2: Recover Excel datas
by Perlchaoui (Sexton) on Nov 14, 2018 at 14:16 UTC

    Hi Marto

    I am not totally agree. Here i am just trying to retrieve a simple data ( a string like "Test") from a cell in an Excel file. I don't want to recover an URL. I just don't understand why i got an URL linked error.

    But maybe i am wrong.

    Thanks again

[reply]

      "I am not totally agree."

      Both errors you report are the same:

      C:\Users\User1\Documents\TESTPERL>perl TEST.pl
Error while executing command: invalid argument: 'url' must be a strin
+g
  (Session info: chrome=70.0.3538.77)
  (Driver info: chromedriver=2.43.600210 (68dcf5eebde37173d4027fa8635e
+332711d2874a),platform=Windows NT 6.1.7601 SP1 x86_64) at C:/Strawber
+ry/perl/site/lib/Selenium/Remot
e/Driver.pm line 391.
 at C:/Strawberry/perl/site/lib/Selenium/Remote/Driver.pm line 348.

      [download]

      and

      C:\Users\user1\Documents\TESTPERL>perl TEST6.pl
Error while executing command: invalid argument: 'url' must be a strin
+g
  (Session info: chrome=70.0.3538.77)
  (Driver info: chromedriver=2.43.600210 (68dcf5eebde37173d4027fa8635e
+332711d2874a),platform=Windows NT 6.1.7601 SP1 x86_64) at C:/Strawber
+ry/perl/sit
e/lib/Selenium/Remote/Driver.pm line 391.
 at C:/Strawberry/perl/site/lib/Selenium/Remote/Driver.pm line 348.

      [download]

      "Here i am just trying to retrieve a simple data ( a string like "Test") from a cell in an Excel file."

      This isn't what the code you posted does. You should ask who ever wrote the code for you.

[reply]
[d/l]
[select]

        Marto

        Thanks. I finally found the issue. Indeed the output is the same but the code is a little bit different. I just forgot to delete a line in the code.

        Thanks for your feedback

[reply]

      If you want a string from an Excel file, why do you need Selenium, and Google?

[reply]

      Hi,

      "I just don't understand why i got an URL linked error."

      Because you place the value "Test" into the variable $data and then tell the Selenium Driver to get it.

      Hope this helps!


      The way forward always starts with a minimal test.
[reply]
[d/l]
[select]

        Thanks lnickt

        indeed. in fact i forgot to delete a line.. I am beginner in Perl and i am coding in parallel in Java. Sometimes it doesn't help to see clearly the things

        Thanks for the support. Appreciated

[reply]

In Section Seekers of Perl Wisdom