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

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 http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.69/lib/Excel/Writer/XLSX.pm#LIMITATIONS
So i have to resort to the write_string function.
The problem is that the url is html encoded. For example & is converted into &.

www.example.com?a=b&c=d is converted into www.example.com?a=b&c=d

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
Re: Spreadsheet::WriteExcel write urls greater than 255 characters
by rpnoble419 (Pilgrim) on Jun 30, 2013 at 12:37 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
Node Status?
node history
Node Type: perlquestion [id://1041573]
Approved by Happy-the-monk
Front-paged by ww
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (17)
As of 2014-07-30 08:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (229 votes), past polls