Re: How to modify column in WriteExcel?

Replies are listed 'Best First'.
Re^2: How to modify column in WriteExcel? by vserzh (Novice) on Mar 13, 2019 at 10:27 UTC
As I understand I get exactly what I need, but.. :) `$VAR1 = [ [ '10000516' ], [ '10000512' ], [ '10000514' ], [ '10000513' ], [ '10000515' ] ];` [download]	[reply] [d/l]
Re^3: How to modify column in WriteExcel? by poj (Abbot) on Mar 13, 2019 at 10:42 UTC
`#!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]); }` [download] poj	[reply] [d/l]
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!	[reply]
Re^5: How to modify column in WriteExcel? by poj (Abbot) on Mar 13, 2019 at 11:18 UTC
Re^6: How to modify column in WriteExcel? by vserzh (Novice) on Mar 13, 2019 at 11:40 UTC
Re^3: How to modify column in WriteExcel? by hdb (Monsignor) on Mar 13, 2019 at 10:32 UTC
If this is the output of `print Dumper $url;` then you need to use `$url->[0][0]` instead of `$url->[0]` (the latter being the same as `${$url}[0]`). Update: or `${${$url}[0]}[0]` if you prefer.	[reply] [d/l] [select]
Re^4: How to modify column in WriteExcel? by vserzh (Novice) on Mar 13, 2019 at 10:45 UTC
Yes, that output and thank you $url->[0][0] is works, link are valid now. Could you explain me why is two pointers here [0][0]? And another question can I use for/foreach to modify every row in that column?	[reply]
Re^5: How to modify column in WriteExcel? by hdb (Monsignor) on Mar 13, 2019 at 12:03 UTC
Re^6: How to modify column in WriteExcel? by vserzh (Novice) on Mar 13, 2019 at 12:18 UTC


Just another Perl shrine
	PerlMonks