Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Spreadsheet::WriteExcel write urls greater than 255 characters

by rpnoble419 (Pilgrim)
on Jun 30, 2013 at 12:37 UTC ( [id://1041582]=note: print w/replies, xml ) Need Help??


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

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
      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1041582]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2024-03-28 18:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found