Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

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

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2018-06-22 00:36 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (120 votes). Check out past polls.