Skip Menu |

This queue is for tickets about the Excel-Template CPAN distribution.

Report information
The Basics
Id: 11518
Status: resolved
Priority: 0/
Queue: Excel-Template

People
Owner: RKINYON [...] cpan.org
Requestors: MidLifeXis-ExcelTemplate [...] wightmanfam.org
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.20
Fixed in: (no value)



Subject: Bug with worksheet NAME parameter
HP-UX 11.0 Perl 5.6.1 Excel-Template-0.20 Spreadsheet::WriteExcel 2.02 It looks like there is a bug in implementing the NAME parameter to the worksheet element. Example: ================================================= test.xml ================================================= <workbook> <worksheet name="foobar"> <ROW><CELL>MidLifeXis</CELL></ROW> </worksheet> </workbook> ================================================= ================================================= test.cgi ================================================= use Excel::Template; my $t = Excel::Template->new(filename=>'test.xml') or die "$!"; print "Content-type: application/vnd.ms-excel\r\n\r\n"; print $t->output; ================================================= If you remove the NAME attribute from the xml file, it works. There are no error messages reported, just a corrupted xls file is generated. If you need any more information, let me know. MidLifeXis
From: MidLifeXis-exceltemplate [...] wightmanfam.org
[guest - Tue Feb 15 17:05:47 2005]: Also see this template..... <workbook> <loop name="sheets"> <worksheet name=""> <row><cell>hello world</cell></row> </worksheet> </loop> </workbook> Without the name="" stuff in the worksheet element, you end up generating an invalid xls file as well. MidLifeXis
Have tried code presented in the bug report and it worked fine on my system. Am following up with requestor to determine if an underlying system issue is the root cause. Rob
Looks to have been a Unicode issue with 5.6 on HP/UX. If the problem reappears, let me know. Thanks, Rob