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

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

Report information
The Basics
Id: 113088
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

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

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



Subject: Suggested build in converter that solves quite some of hte issues mentioned.
Download (untitled) / with headers
text/plain 724b
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 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.