Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: How to modify column in WriteExcel?

by poj (Abbot)
on Mar 13, 2019 at 10:42 UTC ( [id://1231211]=note: print w/replies, xml ) Need Help??


in reply to Re^2: How to modify column in WriteExcel?
in thread How to modify column in WriteExcel?

#!perl use strict; use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new('Report.xls'); my $worksheet = $workbook->add_worksheet("DTicket"); #my $url = $sth->fetchall_arrayref([0]); my $url = [['10000516'],['10000512'], ['10000514'],['10000513'],['10000515']]; my $rowno = 2; for my $row (@$url ){ my $url = 'http://example.com/index.pl?TNumber='.$row->[0]; $worksheet->write_url($rowno++,0, $url, $row->[0]); }
poj

Replies are listed 'Best First'.
Re^4: How to modify column in WriteExcel?
by vserzh (Novice) on Mar 13, 2019 at 11:01 UTC
    It's works thank you very match!

      You don't need to run another query, you can use $data in the loop

      for my $row (@$data ){
      poj
        Ok, I understood thanks!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1231211]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2024-04-22 16:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found