# NAME Excel::Writer::XLSX::Simple::Tabs - Simple Interface to the Excel::Writer::XLSX Package # SYNOPSIS use Excel::Writer::XLSX::Simple::Tabs; my $ss=Excel::Writer::XLSX::Simple::Tabs->new; my @data=( ["Heading1", "Heading2"], ["data1", "data2" ], ["data3", "data4" ], ); $ss->add(Tab1=>\@data, Tab2=>\@data); print $ss->header(filename=>"filename.xlsx"), $ss->content; # DESCRIPTION This is a simple wrapper around Excel::Writer::XLSX that creates tabs for data. It is meant to be simple not full featured. I use this package to export data from the [DBIx::Array](https://metacpan.org/pod/DBIx::Array) sqlarrayarrayname method which is an array of array references where the first array is the column headings. # USAGE # CONSTRUCTOR ## new ## book Returns the workbook object ## add $ss->add("Tab Name", \@data); $ss->add(Tab1=>\@data, Tab2=>\@data); ## header Returns a header appropriate for a web application Content-type: application/vnd.ms-excel Content-Disposition: attachment; filename=filename.xls $ss->header #embedded in browser $ss->header(filename=>"filename.xls") #download prompt $ss->header(content_type=>"application/vnd.ms-excel") #default content type ## content This returns the binary content of the spreadsheet. print $ss->content; print $ss->header, $ss->content; #CGI Application binmod($fh); print $fh, $ss->content; # PROPERTIES ## first Returns a hash of additional settings for the first row $ss->first({setting=>"value"}); #settings from L ## default Returns a hash of default settings for the body $ss->default({setting=>"value"}); #settings from L # BUGS Please report issues on [GitHub](https://github.com/mrdvt92/perl-Excel-Writer-XLSX-Simple-Tabs/issues) # AUTHOR Michael R. Davis # COPYRIGHT Copyright (c) 2022 Michael R. Davis Copyright (c) 2001-2005 Tony Bowden (IO::Scalar portion used here "under the same terms as Perl itself") This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. # SEE ALSO [Excel::Writer::XLSX](https://metacpan.org/pod/Excel::Writer::XLSX), [DBIx::Array](https://metacpan.org/pod/DBIx::Array) sqlarrayarrayname method, [IO::Scalar](https://metacpan.org/pod/IO::Scalar), [Spreadsheet::WriteExcel](https://metacpan.org/pod/Spreadsheet::WriteExcel)