Skip to content
Latest commit fc2648a May 14, 2016 @jmcnamara Prep for release 0.90.
Failed to load latest commit information.
bin Updated copyright year. Jan 30, 2015
examples Updated copyright year. Jan 12, 2016
lib/Excel/Writer Prep for release 0.90. May 14, 2016
.travis.yml Travis config file. Apr 16, 2016
Changes Prep for release 0.90. May 14, 2016
MANIFEST Prep for release 0.90. May 14, 2016
Makefile.PL Added vba_project examples and documentation. Nov 24, 2012
README Prep for release 0.90. May 14, 2016



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


    The Excel::Writer::XLSX module can be used to create a new Excel file
    in the 2007+ XLSX format. 

    The module supports the following Excel features:

        * Multiple worksheets
        * Strings and numbers
        * Unicode text
        * Cell formatting
        * Formulas
        * Images
        * Charts
        * Autofilters
        * Data validation
        * Conditional formatting
        * Macros
        * Tables
        * Shapes
        * Sparklines
        * Hyperlinks
        * Rich string formats
        * Defined names
        * Grouping/Outlines
        * Cell comments
        * Panes
        * Page set-up and printing options

    Excel::Writer::XLSX uses the same interface as Spreadsheet::WriteExcel.


    To write a string, a formatted string, a number and a formula to
    the first worksheet in an Excel XML spreadsheet called perl.xls:

        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(); # Add a format

        # 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)');


    Use the standard Unix style installation.

        Unzip and untar the module as follows:

            tar -zxvf Excel-Writer-XLSX-0.90.tar.gz

        The module can be installed using the standard Perl procedure:

            perl Makefile.PL
            make test
            make install    # As sudo/root


    John McNamara (
Something went wrong with that request. Please try again.