Excel::Writer::XLSX Create a new file in the Excel 2007+ XLSX format
Download

Excel::Writer::XLSX Ranking & Summary

Excel::Writer::XLSX Tags

Perl module perl Excel XLSX XLSX writer

Excel::Writer::XLSX Description

Create a new file in the Excel 2007+ XLSX format Excel::Writer::XLSX is a Perl module that can be used to create an Excel file in the 2007+ XLSX format.The XLSX format is the Office Open XML (OOXML) format used by Excel 2007 and later.Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, and formulas can be written to the cells.This module cannot, as yet, be used to write to an existing Excel XLSX file.SYNOPSISTo write a string, a formatted string, a number and a formula to the first worksheet in an Excel workbook called perl.xlsx: use Excel::Writer::XLSX; # Create a new Excel workbook my $workbook = Excel::Writer::XLSX->new( 'perl.xlsx' ); # Add a worksheet $worksheet = $workbook->add_worksheet(); # Add and define a format $format = $workbook->add_format(); $format->set_bold(); $format->set_color( 'red' ); $format->set_align( 'center' ); # Write a formatted and unformatted string, row and column notation. $col = $row = 0; $worksheet->write( $row, $col, 'Hi Excel!', $format ); $worksheet->write( 1, $col, 'Hi Excel!' ); # Write a number and a formula using A1 notation $worksheet->write( 'A3', 1.2345 ); $worksheet->write( 'A4', '=SIN(PI()/4)' ); Requirements: · Perl

Excel::Writer::XLSX Related Software