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

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
      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?
choroba likes the story at the end of the node
[choroba]: reminds me of the days at the bank
[Corion]: Lady_Aleena: Hehe ;-D
[Lady_Aleena]: Corion, it was PerlMonks who kept pushing me to get Linux, so now I know some of the commands to use in word play.
[Corion]: Lady_Aleena: :-D
[Lady_Aleena]: Corion, so do you think the gods would be open to taking over Cookies should I disappear for too long a time?

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2017-04-26 08:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (471 votes). Check out past polls.