1Spreadsheet-WriteExcel-Styler 2 3DESCRIPTION 4 5This is a small utility to help formatting cells while 6creating Excel workbooks through the wonderful 7L<Spreadsheet::WriteExcel> module. 8 9When working within the Excel application, users often change one 10format feature at a time (highlight a row, add a border to a column, 11etc.); these changes do not affect other format features (for example 12if you change the background color, it does not affect fonts, borders, 13or cell alignment). By contrast, when generating a workbook through 14L<Spreadsheet::WriteExcel>, formats express complete sets of features, 15and they cannot be combined together. This means that the programmer 16has to prepare in advance all formats for all possible combinations of 17format features, and has to invent a way of cataloguing those 18combinations. 19 20Objects from this module hold a catalogue of I<styles>, where each 21style is a collection of format features. Then, for any combination 22of styles, the styler generats a L<Spreadsheet::WriteExcel::Format> 23on the fly, or, if a similar combination was already encountered, 24retrieves the format from its internal cache. 25 26INSTALLATION 27 28To install this module, run the following commands: 29 30 perl Build.PL 31 perl Build 32 perl Build test 33 perl Build install 34 35SUPPORT AND DOCUMENTATION 36 37After installing, you can find documentation for this module with the 38perldoc command. 39 40 perldoc Spreadsheet::WriteExcel::Styler 41 42You can also look for information at: 43 44 RT, CPAN's request tracker 45 http://rt.cpan.org/NoAuth/Bugs.html?Dist=Spreadsheet-WriteExcel-Styler 46 47 AnnoCPAN, Annotated CPAN documentation 48 http://annocpan.org/dist/Spreadsheet-WriteExcel-Styler 49 50 CPAN Ratings 51 http://cpanratings.perl.org/d/Spreadsheet-WriteExcel-Styler 52 53 Search CPAN 54 http://search.cpan.org/dist/Spreadsheet-WriteExcel-Styler/ 55 56 57LICENSE AND COPYRIGHT 58 59Copyright (C) 2010 Laurent Dami 60 61This program is free software; you can redistribute it and/or modify it 62under the terms of either: the GNU General Public License as published 63by the Free Software Foundation; or the Artistic License. 64 65See http://dev.perl.org/licenses/ for more information. 66 67