Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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?
[shmem]: LanX: now I have to find a succinct transformation FOOL => MONK
[LanX]: yeah but Marto already proposed a new "Lex Sun-D" ...
[karlgoethebier]: the word really exists: http://www. urbandictionary. com/define.php? term=fool
[shmem]: ...possibly involving RTFM
[karlgoethebier]: big surprise!
[Eily]: LanX I try to avoid answering, but I did feel that this one post was going into much detail to prove a false claim (that SHA-1 is secure, I was just wrong about how insecure it is)
[LanX]: ironically...
[LanX]: yeah whatever ... I'm in the favorable condition to already autohiding him ... how can I judge the poor FOOLs who still see his contributions xD
[Eily]: he's been pretty saavy about threads that were implictly about him in the past. I think he might have deliberatly avoiding mentioning it for some reason (he got tired?)
[Eily]: he did mention one of his propositions: basically make it possible to ignore downvotes, by separating them more from the upvotes

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (8)
As of 2017-07-24 17:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (356 votes). Check out past polls.