Spreadsheet-GenerateXLSX

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

Revision history for Perl module Spreadsheet::GenerateXLSX

0.05 2019-12-17 NEILB
    - passing a value of undef would result in a warning when you generate
      the spreadsheet. Thanks to Johann Rolschewski for PR with fix.

0.04 2017-01-05 NEILB
    - Optional testsuite that checks whether generated spreadsheet reads ok.
      Uses Spreadsheet::ParseXLSX, or skips if that's not installed.
    - Changed req'd version of Perl to 5.008, to match Ref::Util

0.03_02 2016-12-30 NEILB
    - I had done a push on an arrayref, which caused some CPAN Testers fails --
      I need to get out of that habit.

0.03_01 2016-12-28 NEILB
    - Added a testsuite which generates a spreadsheet then uses
      Spreadsheet::ParseXLSX to check the generated file.
      Uses Test::Needs to skip if Spreadsheet::ParseXLSX not installed.
    - Specified min perl version of 5.010, as Ref::Util currently doesn't
      work on older perls.

0.03 2016-12-11 NEILB
    - The github repo was wrong in the doc. Sebastien Thebert++
    - Updated SEE ALSO entry on XLS::Simple, now I've played with it,
      and added a link to my recent blog post.

0.02 2016-11-29 NEILB
    - Added SEE ALSO section, with a list of other spreadsheet writing modules.
    - Changed one instance of // to ||, so it will work on older Perls.

META.json  view on Meta::CPAN

      "configure" : {
         "requires" : {
            "ExtUtils::MakeMaker" : "0"
         }
      },
      "runtime" : {
         "requires" : {
            "Carp" : "0",
            "Excel::Writer::XLSX" : "0",
            "Exporter" : "0",
            "Ref::Util" : "0",
            "parent" : "0",
            "perl" : "5.008",
            "strict" : "0",
            "warnings" : "0"
         }
      },
      "test" : {
         "requires" : {
            "Test::More" : "0.88",
            "Test::Needs" : "0",

META.yml  view on Meta::CPAN

generated_by: 'Dist::Zilla version 6.012, CPAN::Meta::Converter version 2.150010'
license: perl
meta-spec:
  url: http://module-build.sourceforge.net/META-spec-v1.4.html
  version: '1.4'
name: Spreadsheet-GenerateXLSX
requires:
  Carp: '0'
  Excel::Writer::XLSX: '0'
  Exporter: '0'
  Ref::Util: '0'
  parent: '0'
  perl: '5.008'
  strict: '0'
  warnings: '0'
resources:
  homepage: https://github.com/neilb/Spreadsheet-GenerateXLSX
  repository: https://github.com/neilb/Spreadsheet-GenerateXLSX.git
version: '0.05'
x_generated_by_perl: v5.28.2
x_serialization_backend: 'YAML::Tiny version 1.73'

Makefile.PL  view on Meta::CPAN

    "ExtUtils::MakeMaker" => 0
  },
  "DISTNAME" => "Spreadsheet-GenerateXLSX",
  "LICENSE" => "perl",
  "MIN_PERL_VERSION" => "5.008",
  "NAME" => "Spreadsheet::GenerateXLSX",
  "PREREQ_PM" => {
    "Carp" => 0,
    "Excel::Writer::XLSX" => 0,
    "Exporter" => 0,
    "Ref::Util" => 0,
    "parent" => 0,
    "strict" => 0,
    "warnings" => 0
  },
  "TEST_REQUIRES" => {
    "Test::More" => "0.88",
    "Test::Needs" => 0,
    "Test::Warn" => "0.36"
  },
  "VERSION" => "0.05",
  "test" => {
    "TESTS" => "t/*.t"
  }
);


my %FallbackPrereqs = (
  "Carp" => 0,
  "Excel::Writer::XLSX" => 0,
  "Exporter" => 0,
  "Ref::Util" => 0,
  "Test::More" => "0.88",
  "Test::Needs" => 0,
  "Test::Warn" => "0.36",
  "parent" => 0,
  "strict" => 0,
  "warnings" => 0
);


unless ( eval { ExtUtils::MakeMaker->VERSION(6.63_03) } ) {

lib/Spreadsheet/GenerateXLSX.pm  view on Meta::CPAN

package Spreadsheet::GenerateXLSX;
$Spreadsheet::GenerateXLSX::VERSION = '0.05';
use 5.008;
use strict;
use warnings;

use parent 'Exporter';

use Carp                qw/ croak /;
use Ref::Util           qw/ is_arrayref is_ref /;
use Excel::Writer::XLSX;

our @EXPORT_OK = qw/ generate_xlsx /;

my $MAX_EXCEL_COLUMN_WIDTH = 80;


my $define_formats = sub {
    my $workbook = shift;
    my $formats  = {};