perl-Spreadsheet-GenerateXLSX - function to generate XLSX spreadsheet from array ref(s)

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package name perl-Spreadsheet-GenerateXLSX
Package version 0.04
Package release alt1
Package architecture noarch
Package type rpm
Installed size 27.39 KB
Download size 27.39 KB
Official Mirror
This module provides a function `generate_xlsx' which takes
an array of Perl data and generates a simple Excel spreadsheet
in the XLSX format.
The generated sheets have the first row frozen,
and auto filters enabled for every column.
Each sheet in the spreadsheet is generated from an array of rows,
where each row is an arrayref.
The first row is treated as a header row.
Here's an example:
my @sheet1 = (
['Pokemon',  'Type',      'Number'],
['Pikachu',  'Electric',  25],
['Vulpix',   'Fire',      37],
['Ditto',    'Normal',    132],
The generated spreadsheet can have any numbers of sheets:
generate_xslx('pokemon.xlsx', \@sheet1, \@sheet2);
If you just pass arrayrefs, the sheets will be named Sheet1, Sheet2, etc.
You can also pass the name of the sheet:
generate_xslx('pokemon.xlsx', 'All Pokemon' => \@sheet1, 'Hit List' => \@sheet2);


Package Version Architecture Repository
perl-Spreadsheet-GenerateXLSX - - -


Name Value
/usr/share/perl5 -
perl(Excel/Writer/ -
perl(Ref/ -
perl( -
rpmlib(PayloadIsLzma) -


Name Value
perl(Spreadsheet/ = 0.040
perl-Spreadsheet-GenerateXLSX = 0.04-alt1


Type URL
Binary Package perl-Spreadsheet-GenerateXLSX-0.04-alt1.noarch.rpm
Source Package perl-Spreadsheet-GenerateXLSX-0.04-alt1.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    rpm [Sisyphus] noarch autoimports
    rpm [Sisyphus] noarch autoimports
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-Spreadsheet-GenerateXLSX rpm package:
    # sudo apt-get install perl-Spreadsheet-GenerateXLSX



See Also

Package Description
perl-Spreadsheet-HTML-0.07-alt1.noarch.rpm Tabular data to HTML tables
perl-Spreadsheet-ParseExcel-Simple-1.04-alt1_29.noarch.rpm Simple interface to Excel data
perl-Spreadsheet-ParseExcel-Stream-0.11-alt1.noarch.rpm Simple interface to Excel data with less memory overhead
perl-Spreadsheet-ParseExcel_XLHTML-0.04-alt1.noarch.rpm Parse Excel Spreadsheets using xlhtml
perl-Spreadsheet-ParseXLSX-0.27-alt1.noarch.rpm parse XLSX files
perl-Spreadsheet-Read-0.79-alt1.noarch.rpm Meta-Wrapper for reading spreadsheet data
perl-Spreadsheet-Read-scripts-0.79-alt1.noarch.rpm Spreadsheet-Read scripts
perl-Spreadsheet-Reader-Format-0.6.0-alt1.noarch.rpm Formatting for various spreadsheet readers
perl-Spreadsheet-Simple-1.0.0-alt1.noarch.rpm Simple interface to spreadsheet files
perl-Spreadsheet-SimpleExcel-1.92-alt1.noarch.rpm perl module Spreadsheet-SimpleExcel
perl-Spreadsheet-Template-0.05-alt1.noarch.rpm generate spreadsheets from a template
perl-Spreadsheet-Template-scripts-0.05-alt1.noarch.rpm Spreadsheet-Template scripts
perl-Spreadsheet-Wright-0.105-alt1.noarch.rpm simple spreadsheet worker
perl-Spreadsheet-Write-1.03-alt1.noarch.rpm perl module Spreadsheet-Write
perl-Spreadsheet-WriteExcel-Extended-FitColumnWidth-1.02-alt1.noarch.rpm Extends Spreadsheet::WriteExcel with autofit of columns and a few other nice things