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

Report information
The Basics
Id:
113088
Status:
new
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
ftl [...] dnv.com
Cc:
AdminCc:

BugTracker
Severity:
Wishlist
Broken in:
0.15
Fixed in:
(no value)



Subject: Suggested build in converter that solves quite some of hte issues mentioned.
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
Message-ID: <rt-4.0.18-5213-1458140166-776.0-0-0@rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 724
Hi the following converter has worked for me in some projects. Maybe it may be of some help to others my $converter = Spreadsheet::XLSX::XLSXConvert->new(); require Spreadsheet::XLSX; $oBook = Spreadsheet::XLSX->new($fh, $converter); { package Spreadsheet::XLSX::XLSXConvert; sub new { my $module = shift; return bless( { }, $module ); } sub convert { my $self = shift; my ($raw) = @_; #do NOT use 'USE utf 8;', as that would be a pragma saying this script itself is written in utf-8; (ie. myfile.pl is encoded in utf-8) #just use the code below directly: utf8::decode($raw); #also decode html escapes, $raw =~ s/\&amp;/&/g; $raw =~ s/\&lt;/\</g; $raw =~ s/\&gt;/\>/g; return $raw; } }


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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