Skip Menu | 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

Owner: Nobody in particular
Requestors: ftl [...]

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. 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 infrastructure.

Please report any issues with to