Clearbuilt-Excelerator

 view release on metacpan or  search on metacpan

META.yml  view on Meta::CPAN

meta-spec:
  url: http://module-build.sourceforge.net/META-spec-v1.4.html
  version: '1.4'
name: Clearbuilt-Excelerator
provides:
  Clearbuilt::ExcelErator:
    file: lib/Clearbuilt/ExcelErator.pm
    version: '2.0001'
requires:
  Excel::Writer::XLSX: '0'
  Modern::Perl: '0'
  Moo: '0'
version: '2.0001'
x_BuiltWith:
  modules:
    Excel::Writer::XLSX: '1.09'
    ExtUtils::MakeMaker: '7.62'
    File::Spec: '3.80'
    File::Temp: '0.2311'
    FindBin: '1.52'
    IO::Handle: '1.46'
    IPC::Open3: '1.21'
    Modern::Perl: '1.20220515'
    Moo: '2.005004'
    Test2::Plugin::ExitSummary: '0.000145'
    Test2::Plugin::NoWarnings: '0.09'
    Test2::Plugin::Times: '0.000145'
    Test2::V0: '0.000145'
    Test::More: '1.302183'
    lib: '0.65'
    strict: '1.12'
    warnings: '1.51'
  perl:

Makefile.PL  view on Meta::CPAN

  "AUTHOR" => "D Ruth Holloway <ruthh\@clearbuilt.com>",
  "CONFIGURE_REQUIRES" => {
    "ExtUtils::MakeMaker" => 0
  },
  "DISTNAME" => "Clearbuilt-Excelerator",
  "LICENSE" => "perl",
  "MIN_PERL_VERSION" => "5.006",
  "NAME" => "Clearbuilt::Excelerator",
  "PREREQ_PM" => {
    "Excel::Writer::XLSX" => 0,
    "Modern::Perl" => 0,
    "Moo" => 0
  },
  "TEST_REQUIRES" => {
    "File::Spec" => 0,
    "File::Temp" => 0,
    "FindBin" => 0,
    "IO::Handle" => 0,
    "IPC::Open3" => 0,
    "Test2::Plugin::ExitSummary" => 0,
    "Test2::Plugin::NoWarnings" => 0,

Makefile.PL  view on Meta::CPAN

);


my %FallbackPrereqs = (
  "Excel::Writer::XLSX" => 0,
  "File::Spec" => 0,
  "File::Temp" => 0,
  "FindBin" => 0,
  "IO::Handle" => 0,
  "IPC::Open3" => 0,
  "Modern::Perl" => 0,
  "Moo" => 0,
  "Test2::Plugin::ExitSummary" => 0,
  "Test2::Plugin::NoWarnings" => 0,
  "Test2::Plugin::Times" => 0,
  "Test2::V0" => 0,
  "Test::More" => "0.94",
  "lib" => 0,
  "strict" => 0,
  "warnings" => 0
);

README.mkdn  view on Meta::CPAN

Opens the desired file for writing.  At this time, `filename` is the only parameter, which is passed
verbatim into [Excel::Writer::XLSX](https://metacpan.org/pod/Excel%3A%3AWriter%3A%3AXLSX); there may be other options in the future.

## write\_the\_book(\\%spreadsheet);

Writes the file, and closes it.  Easy-peasy!

# REQUIRES

- [Modern::Perl](https://metacpan.org/pod/Modern%3A%3APerl)
- [Moo](https://metacpan.org/pod/Moo)
- [Excel::Writer::XLSX](https://metacpan.org/pod/Excel%3A%3AWriter%3A%3AXLSX)

# ROADMAP

- Add other formatting functions
- Default column formatting
- More documentation
- A robust unit test for `write_the_book`

examples/create_test_excel_sheet  view on Meta::CPAN

#!/usr/bin/env perl
use Modern::Perl;
use Carp;
use FindBin;
use lib "$FindBin::Bin/../lib";
use Clearbuilt::ExcelErator;

# PODNAME: create_test_excel_sheet

my %spreadsheet = (
    'title'      => 'Test Title',
    'col_widths' => {

lib/Clearbuilt/ExcelErator.pm  view on Meta::CPAN

package Clearbuilt::ExcelErator;
use Modern::Perl;
our $VERSION = '2.0001'; # VERSION
our $AUTHORITY = 'cpan:CLEARBLT'; # AUTHORITY
# ABSTRACT: Write XLSX files in a Clearbuilt-standard way
use Moo;
extends 'Excel::Writer::XLSX';

#
# Attributes
#

lib/Clearbuilt/ExcelErator.pm  view on Meta::CPAN

=head2 write_the_book(\%spreadsheet);

Writes the file, and closes it.  Easy-peasy!

=head1 REQUIRES

=over 4

=item *
L<Modern::Perl>

=item *
L<Moo>

=item *
L<Excel::Writer::XLSX>

=back

=head1 ROADMAP

perlcriticrc  view on Meta::CPAN

program-extensions = pl psgi t

[-Modules::ProhibitAutomaticExportation]
[-Subroutines::ProhibitCallsToUndeclaredSubs]
[-Subroutines::ProhibitUnusedPrivateSubroutines]

[Subroutines::ProhibitExcessComplexity]
max_mccabe = 25

[TestingAndDebugging::RequireUseStrict]
equivalent_modules = Modern::Perl

[TestingAndDebugging::RequireUseWarnings]
equivalent_modules = Modern::Perl

[BuiltinFunctions::ProhibitStringySplit]
severity = 3

[CodeLayout::RequireTrailingCommas]
severity = 3

[ControlStructures::ProhibitCStyleForLoops]
severity = 3