in reply to Excel::Writer::XLSX write urls greater than 255 characters

Have you tried the new replacement module Excel::Writer::XLSX?

According to http://office.microsoft.com/en-us/excel-help/get-external-data-from-a-web-page-HA010218472.aspx#BMcreate_a_web_query the length of the url is still limited to 255 characters.

You may need to use a web shorting service to do what you want

  • Comment on Re: Spreadsheet::WriteExcel write urls greater than 255 characters

Replies are listed 'Best First'.
Re^2: Spreadsheet::WriteExcel write urls greater than 255 characters
by david2008 (Scribe) on Jun 30, 2013 at 13:06 UTC
    Hi,

    I had a typo and the subject should be really Excel::Writer::XLSX.
    The web shortening service is not applicable because of the internal businees logic of our process.

    Thanks,
    David
[reply]
      How about building your own internal URL shortening service, using CGI::Shorten, which claims:
      This module may help you to build a personal shortening-link service. Feeding the long, verbose, and tedious url, it can return you a shortened one. And it can also print out redirection header in you CGI script.

                   My goal ... to kill off the slow brain cells that are holding me back from synergizing my knowledge of vertically integrated mobile platforms in local cloud-based content management system datafication.

[reply]

In Section Seekers of Perl Wisdom