Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Excel::Writer::XLSX write urls greater than 255 characters

by david2008 (Scribe)
on Jun 30, 2013 at 11:27 UTC ( #1041573=perlquestion: print w/ replies, xml ) Need Help??
david2008 has asked for the wisdom of the Perl Monks concerning the following question:

Hi all,

I have the following question.
I have an excel with very long urls.(length>255)
When i use the normal write function it does not work.
This is a known issue as explained in
So i have to resort to the write_string function.
The problem is that the url is html encoded. For example & is converted into &. is converted into

When i read the url back from excel with another program i have to decode the url which is an ugly workaround.
Is there a better way to handle this problem?

Thanks, David

Comment on Excel::Writer::XLSX write urls greater than 255 characters
Select or Download Code
Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel write urls greater than 255 characters
by rpnoble419 (Pilgrim) on Jun 30, 2013 at 12:37 UTC

      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.

        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?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1041573]
Approved by Happy-the-monk
Front-paged by ww
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (14)
As of 2015-10-13 17:45 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (311 votes), past polls