Bugzilla – Attachment 143778 Details for
Bug 118946
XLSX file generated from perl script does not import formulas correctly
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
perl script to create XLSX with formula
bugreport.pl (text/plain), 746 bytes, created by
Thomas Seeling
on 2018-07-26 10:16:29 UTC
(
hide
)
Description:
perl script to create XLSX with formula
Filename:
MIME Type:
Creator:
Thomas Seeling
Created:
2018-07-26 10:16:29 UTC
Size:
746 bytes
patch
obsolete
>#!/usr/bin/perl -w > >use strict 'refs'; >use strict 'vars'; > >use utf8; >use Excel::Writer::XLSX; > >my $excelout = 'bugreport.xlsx'; >my $workbook = Excel::Writer::XLSX->new($excelout); > >my $lookupfrm=qq{=IFERROR(VLOOKUP(A%d,\$Lookup.\$%s\$1:\$%s\$10000,%d,FALSE),"")}; > >my $worksheet; >my @u=("root","*",0,0,"no gecos","/root","/bin/sh"); >my $row=0; > >print STDERR "# write Excel unix users\n"; >$worksheet=$workbook->add_worksheet('unix users'); >$worksheet->keep_leading_zeros(); > >$u[4]=sprintf($lookupfrm,1+$row,"A","B",2), >$worksheet->write($row, 0, \@u); >print STDERR "# unix user @u\n"; > >$worksheet=$workbook->add_worksheet('Lookup'); >my @l=("root","root user"); > >$worksheet->write($row, 0, \@l); >print STDERR "# lookup @l\n"; > >$workbook->close(); >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=143778">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 118946
:
143777
| 143778 |
143786