Hi all -
I gave a presentation at the Chicago Perl Mongers group on 06/25/2015 on using Perl to read and write Excel files. There is a brief discussion on the different modules for handling the 2003 and earlier .xls files, as well as the 2007 and later .xlsx files.
Writing data with different formats for headers and data, as well as including Excel comments is shown. Comments can be used to programmatically highlight items for additional information as shown in the picture.
FInally, creating a chart using data from a random number generator was discussed. Chart parameters for the X and Y axis, such as min and max values, major and minor grids, as well as chart type and size is covered. The chart parameters needed for the chart shown are covered.
The PDF presentation can be viewed at or downloaded from http://www.customvisuals.com/resources/PerlExcel.pdf.
Please let me know if you have any questions or comments.