Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

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

Report information
The Basics
Id: 77668
Status: resolved
Priority: 0/
Queue: Excel-Writer-XLSX
People
Owner: Nobody in particular
Requestors: Robert.Holder [...] idt.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Jun 06 11:51:22 2012 Robert.Holder [...] idt.com - Ticket created
Subject: worksheet_add
Date: Wed, 6 Jun 2012 15:51:03 +0000
To: "bug-Excel-Writer-XLSX [...] rt.cpan.org" <bug-Excel-Writer-XLSX [...] rt.cpan.org>
From: "Holder, Robert" <Robert.Holder [...] idt.com>
Hi, I am getting an error with Excel-Writer-XLSX-0.47<http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.47/> I am running perl - v5.8.8 built for x86_64-linux-thread-multi From - Linux SMP Mon Sep 20 07:12:06 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux When I use - "my $worksheet = $workbook->add_worksheet();" everything works fine, but if I write my "$worksheet = $workbook->add_worksheet('MySheet');" the browser can't open the file. The error I get reads - Excel cannot open the file "Weekly_CV_Charts[1].xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. Your help is very much appreciated. Thanks, Robert Holder Sr. Business Systems Analyst 512.330.3191 work 512.658.3187 cell Integrated Device Technology, Inc. 6024 Silver Creek Valley Road San Jose, CA 95138 www.IDT.com<http://www.IDT.com> NASDAQ: IDTI CONFIDENTIAL COMMUNICATION: This email and any attachments thereto may contain private and confidential material for the sole use of the intended recipient. Any review, copying, or distribution of this email (or any attachments thereto) by others is strictly prohibited. If you are not the intended recipient, please contact the sender immediately and permanently delete the original and any copies of this email and any attachments thereto.
  Sat Jun 16 08:12:22 2012 jmcnamara [...] cpan.org - Correspondence added
On Wed Jun 06 11:51:22 2012, Robert.Holder@idt.com wrote: Show quoted text
> When I use - "my $worksheet = $workbook->add_worksheet();" everything > works fine, but if I write my "$worksheet = $workbook-
> >add_worksheet('MySheet');" the browser can't open the file.
> The error I get reads - > Excel cannot open the file "Weekly_CV_Charts[1].xlsx" because the file > format or file extension is not valid. Verify that the file has not > been corrupted and that the file extension matches the format of > the file.
Hi Robert, I cannot replicate that issue. Based on the details you gave I create the following program and was able to open the file in Excel 2007 on Windows and Excel 20011 on the Mac. #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'Weekly_CV_Charts[1].xlsx' ); my $worksheet = $workbook->add_worksheet('MySheet'); __END__ Can you verify the results with the above program and let me know. Regards, John. --
  Sat Jun 16 08:12:23 2012 The RT System itself - Status changed from 'new' to 'open'
  Sat Jun 16 10:16:06 2012 Robert.Holder [...] idt.com - Correspondence added
Subject: RE: [rt.cpan.org #77668] worksheet_add
Date: Sat, 16 Jun 2012 14:15:54 +0000
To: "bug-Excel-Writer-XLSX [...] rt.cpan.org" <bug-Excel-Writer-XLSX [...] rt.cpan.org>
From: "Holder, Robert" <Robert.Holder [...] idt.com>
Thanks for your reply, This works. This was programmer error. Sorry to bug you. Thanks, Robert Holder Sr. Business Systems Analyst 512.330.3191 work 512.658.3187 cell Integrated Device Technology, Inc. 6024 Silver Creek Valley Road San Jose, CA 95138 www.IDT.com NASDAQ: IDTI CONFIDENTIAL COMMUNICATION: This email and any attachments thereto may contain private and confidential material for the sole use of the intended recipient. Any review, copying, or distribution of this email (or any attachments thereto) by others is strictly prohibited. If you are not the intended recipient, please contact the sender immediately and permanently delete the original and any copies of this email and any attachments thereto. Show quoted text
-----Original Message----- From: John McNamara via RT [mailto:bug-Excel-Writer-XLSX@rt.cpan.org] Sent: Saturday, June 16, 2012 7:12 AM To: Holder, Robert Subject: [rt.cpan.org #77668] worksheet_add <URL: https://rt.cpan.org/Ticket/Display.html?id=77668 > On Wed Jun 06 11:51:22 2012, Robert.Holder@idt.com wrote:
> When I use - "my $worksheet = $workbook->add_worksheet();" everything > works fine, but if I write my "$worksheet = $workbook-
> >add_worksheet('MySheet');" the browser can't open the file.
> The error I get reads - > Excel cannot open the file "Weekly_CV_Charts[1].xlsx" because the file > format or file extension is not valid. Verify that the file has not > been corrupted and that the file extension matches the format of > the file.
Hi Robert, I cannot replicate that issue. Based on the details you gave I create the following program and was able to open the file in Excel 2007 on Windows and Excel 20011 on the Mac. #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'Weekly_CV_Charts[1].xlsx' ); my $worksheet = $workbook->add_worksheet('MySheet'); __END__ Can you verify the results with the above program and let me know. Regards, John. --
  Sun Jun 17 11:09:20 2012 jmcnamara [...] cpan.org - Correspondence added
Hi, In that case I'll close the issue. Regards, John. --
  Sun Jun 17 11:09:21 2012 jmcnamara [...] cpan.org - Status changed from 'open' to 'resolved'