Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

This queue is for tickets about the Spreadsheet-ParseExcel-Simple CPAN distribution.

Report information
The Basics
Id: 17914
Status: open
Priority: 0/
Queue: Spreadsheet-ParseExcel-Simple

People
Owner: Nobody in particular
Requestors: schmidl [...] webdynamite.com
Cc:
AdminCc:

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



X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
X-Mailer: Microsoft Office Outlook 11
Received-SPF: neutral (x1.develooper.com: local policy)
content-type: text/plain; charset="utf-8"
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id 266394D831E for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 1 Mar 2006 07:49:35 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id AD2024D831B for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 1 Mar 2006 07:49:34 -0500 (EST)
Received: (qmail 5926 invoked by alias); 1 Mar 2006 12:49:33 -0000
Received: from moutng.kundenserver.de (HELO moutng.kundenserver.de) (212.227.126.187) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 01 Mar 2006 04:49:30 -0800
Received: from [193.178.208.6] (helo=RLYEH) by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis), id 0MKxQS-1FEQlf0xao-0005d3; Wed, 01 Mar 2006 13:49:23 +0100
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: Spreadsheet::ParseExcel::Simple and Unicode
Return-Path: <schmidl [...] webdynamite.com>
Thread-Index: AcY9LoynQo4oOaCeR1e7eXi+EnLOtw==
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Wed, 1 Mar 2006 13:49:17 +0100
X-Provags-Id: kundenserver.de abuse [...] kundenserver.de login:789f1266f4012cbb59f16712be3f2045
Message-Id: <003701c63d2e$8d806630$6c21cf2b [...] RLYEH>
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
To: <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "DI Gunther Schmidl" <schmidl [...] webdynamite.com>
X-RT-Original-Encoding: iso-8859-1
Content-Length: 591
Download (untitled) / with headers
text/plain 591b
Hi, I've extended Spreadsheet::ParseExcel::Simple to allow using Spreadsheet::ParseExcel's Unicode formatter by simply adding a parameter like this: my $xls = Spreadsheet::ParseExcel::Simple->read('file.xls', 1); If you're interested in adding this to the CPAN distribution, I can send you the source code or a diff. Regards, -- Gunther Show quoted text
_________________________________________ DI Gunther Schmidl (Consultant) WebDynamite IT Solutions GmbH Landstraße 49, A-4020 Linz, Austria http://www.webdynamite.com +43 / 732 / 777 810 - 16 (fixed) +43 / 732 / 777 810 - 50 (fax)
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-3293-1141217386-94.17914-4-0 [...] rt.cpan.org>
Content-Disposition: inline
Received-SPF: pass (x1.develooper.com: local policy)
References: <RT-Ticket-17914 [...] rt.cpan.org> <003701c63d2e$8d806630$6c21cf2b [...] RLYEH> <rt-3.5.HEAD-3293-1141217386-94.17914-4-0 [...] rt.cpan.org>
Reply-To: tony [...] kasei.com
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: us-ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id DE8F34D8341 for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 1 Mar 2006 11:30:50 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 6E18E4D8340 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 1 Mar 2006 11:30:49 -0500 (EST)
Received: (qmail 12097 invoked by alias); 1 Mar 2006 16:30:48 -0000
Received: from soto.kasei.com (HELO soto.kasei.com) (80.76.206.154) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 01 Mar 2006 08:30:46 -0800
Received: by soto.kasei.com (Postfix, from userid 1011) id B9EC31C3F4; Wed, 1 Mar 2006 16:30:38 +0000 (GMT)
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: Re: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
User-Agent: Mutt/1.5.5.1+cvs20040105i
Return-Path: <tony [...] kasei.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Date: Wed, 1 Mar 2006 16:30:38 +0000
Message-Id: <20060301163038.GC26469 [...] soto.kasei.com>
To: DI Gunther Schmidl via RT <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
From: Tony Bowden <tony [...] kasei.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-3303-1141230656-44.17914-0-0 [...] rt.cpan.org>
Content-Length: 655
Download (untitled) / with headers
text/plain 655b
On Wed, Mar 01, 2006 at 07:49:46AM -0500, DI Gunther Schmidl via RT wrote: Show quoted text
> I've extended Spreadsheet::ParseExcel::Simple to allow using > Spreadsheet::ParseExcel's Unicode formatter by simply adding a parameter > like this: > my $xls = Spreadsheet::ParseExcel::Simple->read('file.xls', 1);
I don't really like "magic number" parameters. If this could be modified to be a hashref of options: e.g. my $xls = Spreadsheet::ParseExcel::Simple->read('file.xls', { unicode_formatter => 1, }); then I'd be more inclined to include it. (Feel free to suggest a better name for the option too) Do you also have a test case for this? Thanks, Tony
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-3303-1141230656-44.17914-6-0 [...] rt.cpan.org>
X-Mailer: Microsoft Office Outlook 11
Received-SPF: neutral (x1.develooper.com: local policy)
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: iso-8859-1
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id 777DB4D8256 for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 22 Mar 2006 09:22:56 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 209D34D80B4 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 22 Mar 2006 09:22:55 -0500 (EST)
Received: (qmail 7875 invoked by alias); 22 Mar 2006 14:22:51 -0000
Received: from moutng.kundenserver.de (HELO moutng.kundenserver.de) (212.227.126.186) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 22 Mar 2006 06:22:47 -0800
Received: from [193.178.208.6] (helo=RLYEH) by mrelayeu.kundenserver.de (node=mrelayeu10) with ESMTP (Nemesis), id 0ML31I-1FM4ES2WIt-0003cz; Wed, 22 Mar 2006 15:22:40 +0100
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: AW: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
Return-Path: <schmidl [...] webdynamite.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Thread-Index: AcY9TYUDKbOVoOxMSE+LY7W82w3zDAQbNldw
Date: Wed, 22 Mar 2006 15:22:34 +0100
Message-Id: <007b01c64dbc$10aad7a0$a821cf2b [...] RLYEH>
X-Provags-Id: kundenserver.de abuse [...] kundenserver.de login:789f1266f4012cbb59f16712be3f2045
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
To: <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: "DI Gunther Schmidl" <schmidl [...] webdynamite.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-19746-1143037381-624.17914-0-0 [...] rt.cpan.org>
Content-Length: 1598
Download (untitled) / with headers
text/plain 1.5k
Tony, it's been a while since your reply and I've only now had time to do this, but: Tony Bowden via RT wrote: Show quoted text
> On Wed, Mar 01, 2006 at 07:49:46AM -0500, DI Gunther Schmidl via RT > wrote:
>> I've extended Spreadsheet::ParseExcel::Simple to allow using >> Spreadsheet::ParseExcel's Unicode formatter by simply adding a >> parameter like this: my $xls = >> Spreadsheet::ParseExcel::Simple->read('file.xls', 1);
> > I don't really like "magic number" parameters. > > If this could be modified to be a hashref of options: > > e.g. > > my $xls = Spreadsheet::ParseExcel::Simple->read('file.xls', { > unicode_formatter => 1, > }); > > > then I'd be more inclined to include it.
I've changed the parameter. This reads a file as Unicode: my $xls = Spreadsheet::ParseExcel::Simple->read("test.xls", {as_unicode => 1}); These work as previously: my $xls = Spreadsheet::ParseExcel::Simple->read("test.xls"); my $xls = Spreadsheet::ParseExcel::Simple->read("test.xls", {as_unicode => 0}); Show quoted text
> > Do you also have a test case for this? >
I'm afraid I don't -- the Unicode-related errors come directly from Spreadsheet::ParseExcel, so there's really no way of testing this other than looking at the console output and not seeing the gigantic bunch of warnings one usually gets. Let me know if you're still interested. Thanks, -- Gunther Show quoted text
_________________________________________ DI Gunther Schmidl (Consultant) WebDynamite IT Solutions GmbH Landstraße 49, A-4020 Linz, Austria http://www.webdynamite.com +43 / 732 / 777 810 - 16 (fixed) +43 / 732 / 777 810 - 50 (fax)
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-19746-1143037381-624.17914-5-0 [...] rt.cpan.org>
Content-Disposition: inline
Received-SPF: pass (x1.develooper.com: local policy)
References: <RT-Ticket-17914 [...] rt.cpan.org> <rt-3.5.HEAD-3303-1141230656-44.17914-6-0 [...] rt.cpan.org> <007b01c64dbc$10aad7a0$a821cf2b [...] RLYEH> <rt-3.5.HEAD-19746-1143037381-624.17914-5-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: us-ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id 15BC74D824B for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 22 Mar 2006 09:33:43 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id A3DAB4D80B4 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 22 Mar 2006 09:33:42 -0500 (EST)
Received: (qmail 12107 invoked by alias); 22 Mar 2006 14:33:38 -0000
Received: from soto.kasei.com (HELO soto.kasei.com) (80.76.206.154) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 22 Mar 2006 06:33:35 -0800
Received: by soto.kasei.com (Postfix, from userid 1011) id 153E51C3C2; Wed, 22 Mar 2006 14:33:28 +0000 (GMT)
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: Re: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
User-Agent: Mutt/1.5.5.1+cvs20040105i
Return-Path: <tony [...] kasei.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Date: Wed, 22 Mar 2006 14:33:28 +0000
Message-Id: <20060322143327.GA20811 [...] soto.kasei.com>
To: DI Gunther Schmidl via RT <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
From: Tony Bowden <tony [...] kasei.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-19746-1143038026-261.17914-0-0 [...] rt.cpan.org>
Content-Length: 505
Download (untitled) / with headers
text/plain 505b
On Wed, Mar 22, 2006 at 09:23:02AM -0500, DI Gunther Schmidl via RT wrote: Show quoted text
> it's been a while since your reply and I've only now had time to do this,
No worries. Show quoted text
> I'm afraid I don't -- the Unicode-related errors come directly from > Spreadsheet::ParseExcel, so there's really no way of testing this other than > looking at the console output and not seeing the gigantic bunch of warnings > one usually gets.
There must be some way of testing it - what sorts of problems does it cause? Thanks, Tony
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-19746-1143038026-261.17914-6-0 [...] rt.cpan.org>
X-Mailer: Microsoft Office Outlook 11
Received-SPF: neutral (x1.develooper.com: local policy)
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: us-ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id C55B34D83B5 for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 22 Mar 2006 09:57:01 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 69ACF4D8277 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 22 Mar 2006 09:57:01 -0500 (EST)
Received: (qmail 21096 invoked by alias); 22 Mar 2006 14:56:57 -0000
Received: from moutng.kundenserver.de (HELO moutng.kundenserver.de) (212.227.126.186) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 22 Mar 2006 06:56:47 -0800
Received: from [193.178.208.6] (helo=RLYEH) by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis), id 0MKxQS-1FM4lN3jnC-0005eq; Wed, 22 Mar 2006 15:56:42 +0100
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: AW: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
Return-Path: <schmidl [...] webdynamite.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Thread-Index: AcZNvZ+xrZiIc8BLReK96/wPH05j2QAAJYWA
Date: Wed, 22 Mar 2006 15:56:35 +0100
Message-Id: <007c01c64dc0$d14f69e0$a821cf2b [...] RLYEH>
X-Provags-Id: kundenserver.de abuse [...] kundenserver.de login:789f1266f4012cbb59f16712be3f2045
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
To: <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
Content-Transfer-Encoding: 7bit
From: "DI Gunther Schmidl" <schmidl [...] webdynamite.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-19731-1143039426-704.17914-0-0 [...] rt.cpan.org>
Content-Length: 542
Download (untitled) / with headers
text/plain 542b
Tony Bowden via RT wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=17914 > > > There must be some way of testing it - what sorts of problems does it > cause?
Usually when you parse an Unicode Excel file, you get a bunch of warnings looking like: Character in 'C' format wrapped in pack at [...]/Spreadsheet/ParseExcel/FmtDefault.pm line 68. With the Unicode reader turned on, this doesn't happen. ( See http://www.annocpan.org/~KWITKNR/Spreadsheet-ParseExcel-0.2602/ParseExcel.pm #note_626 ) Show quoted text
> Thanks, > > Tony
-- Gunther
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-19731-1143039426-704.17914-5-0 [...] rt.cpan.org>
Content-Disposition: inline
Received-SPF: pass (x1.develooper.com: local policy)
References: <RT-Ticket-17914 [...] rt.cpan.org> <rt-3.5.HEAD-19746-1143038026-261.17914-6-0 [...] rt.cpan.org> <007c01c64dc0$d14f69e0$a821cf2b [...] RLYEH> <rt-3.5.HEAD-19731-1143039426-704.17914-5-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: us-ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id D6C104D82A9 for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Wed, 22 Mar 2006 12:03:21 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 7B6304D82A1 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Wed, 22 Mar 2006 12:03:21 -0500 (EST)
Received: (qmail 2279 invoked by alias); 22 Mar 2006 17:03:17 -0000
Received: from soto.kasei.com (HELO soto.kasei.com) (80.76.206.154) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 22 Mar 2006 09:03:14 -0800
Received: by soto.kasei.com (Postfix, from userid 1011) id 6C8BD1C3D1; Wed, 22 Mar 2006 17:03:08 +0000 (GMT)
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: Re: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
User-Agent: Mutt/1.5.5.1+cvs20040105i
Return-Path: <tony [...] tmtm.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Date: Wed, 22 Mar 2006 17:03:08 +0000
Message-Id: <20060322170308.GA21835 [...] soto.kasei.com>
To: DI Gunther Schmidl via RT <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
From: Tony Bowden <tony [...] tmtm.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-19746-1143047005-424.17914-0-0 [...] rt.cpan.org>
Content-Length: 544
Download (untitled) / with headers
text/plain 544b
On Wed, Mar 22, 2006 at 09:57:07AM -0500, DI Gunther Schmidl via RT wrote: Show quoted text
> Usually when you parse an Unicode Excel file, you get a bunch of warnings > looking like: > Character in 'C' format wrapped in pack at > [...]/Spreadsheet/ParseExcel/FmtDefault.pm line 68. > With the Unicode reader turned on, this doesn't happen.
OK. Should be easy enough to catch by setting $SIG{__WARN__} and calling fail() if there are any warnings. If it's not something you know (or can work out) how to do I'll have a look at it at some stage. Thanks, Tony
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.6 required=8.0 tests=BAYES_00
In-Reply-To: <rt-3.5.HEAD-19746-1143047005-424.17914-6-0 [...] rt.cpan.org>
X-Mailer: Microsoft Office Outlook 11
Received-SPF: neutral (x1.develooper.com: local policy)
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: us-ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id 8F3884D8441 for <cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com>; Thu, 23 Mar 2006 03:43:07 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 391C94D82D8 for <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>; Thu, 23 Mar 2006 03:43:07 -0500 (EST)
Received: (qmail 9301 invoked by alias); 23 Mar 2006 08:43:02 -0000
Received: from moutng.kundenserver.de (HELO moutng.kundenserver.de) (212.227.126.183) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 23 Mar 2006 00:42:55 -0800
Received: from [83.64.52.210] (helo=RLYEH) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis), id 0MKwh2-1FMLP62NVi-0008Eb; Thu, 23 Mar 2006 09:42:48 +0100
Delivered-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Subject: AW: [rt.cpan.org #17914] Spreadsheet::ParseExcel::Simple and Unicode
Return-Path: <schmidl [...] webdynamite.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+spreadsheet-parseexcel-simple [...] diesel.bestpractical.com
Thread-Index: AcZN0oeYMsX1n5RFRZ6BZo/h84zerAAgovOw
Date: Thu, 23 Mar 2006 09:42:41 +0100
Message-Id: <003f01c64e55$c00927d0$c516a8c0 [...] RLYEH>
X-Provags-Id: kundenserver.de abuse [...] kundenserver.de login:789f1266f4012cbb59f16712be3f2045
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.2670
To: <bug-Spreadsheet-ParseExcel-Simple [...] rt.cpan.org>
Content-Transfer-Encoding: 7bit
From: "DI Gunther Schmidl" <schmidl [...] webdynamite.com>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-19749-1143103394-1819.17914-0-0 [...] rt.cpan.org>
Content-Length: 894
Download (untitled) / with headers
text/plain 894b
tony@tmtm.com via RT wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=17914 > > > On Wed, Mar 22, 2006 at 09:57:07AM -0500, DI Gunther Schmidl via RT > wrote:
>> Usually when you parse an Unicode Excel file, you get a bunch of >> warnings looking like: Character in 'C' format wrapped in pack at >> [...]/Spreadsheet/ParseExcel/FmtDefault.pm line 68. >> With the Unicode reader turned on, this doesn't happen.
> > OK. Should be easy enough to catch by setting $SIG{__WARN__} and > calling fail() if there are any warnings. If it's not something you > know (or can work out) how to do I'll have a look at it at some stage.
The strange thing is that all of this is a cosmetic issue -- the warning does not seem to impede the actual processing of the spreadsheet at all. I was just sick of having people using my script asking about the pack "errors", so I added the fix. -- Gunther


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.