NAME

Spreadsheet::XLSX::Reader::LibXML::Chartsheet - Read xlsx chartsheets with LibXML

SYNOPSIS

See the SYNOPSIS in the Workbook class

DESCRIPTION

This documentation is intended to cover all 'chartsheet' tabs. For review of the function and implementation of the 'worksheet' style tabs please review the documentation for Worksheets.

Currently this class is mostly a stub to keep the package from dying if a chartsheet exists in the xlsx file to be read. It doesn't provide much functionality or indeed expose any real useful information about the chart. Please provide all suggestions to what you would like for this class to do to the issues section in the github repo

Extending the chartsheet class

I don't have any good ideas yet. Outside input welcome.

Attributes

These are attributes that contain information about the sheet. Not much else. At the end of this list it is noted that a reference to the workbook is stored in one of the attributes as well so many workbook settings can be adjusted from the chartsheet instance. (Don't)

sheet_rel_id

    Definition: This is the relId of the sheet listed in the XML of the .xlsx file. You probably don't care and you should never set this value.

    attribute methods Methods provided to adjust this attribute

      rel_id

        Definition: returns the value stored in the attribute

sheet_id

    Definition: This is the Id of the sheet listed in the XML of the .xlsx file. I beleive this to be the number used in vbscript to reference the sheet. You should never set this value.

    attribute methods Methods provided to adjust this attribute

      sheet_id

        Definition: returns the value stored in the attribute

sheet_position

    Definition: This is the visual sheet position in the .xlsx file. You should never set this value.

    attribute methods Methods provided to adjust this attribute

      position

        Definition: returns the value stored in the attribute

sheet_name

    Definition: This is the visual sheet name in the .xlsx file. You should never set this value.

    attribute methods Methods provided to adjust this attribute

      get_name

        Definition: returns the value stored in the attribute

drawing_rel_id

    Definition: A chart sheet has an underlying drawing object that the chart is built on. This is the xlsx relID of that drawing object.

    attribute methods Methods provided to adjust this attribute

      get_drawing_rel_id

        Definition: returns the value stored in the attribute

sheet_type

    Definition: There are two possible kinds of sheets in an Excel file; 'worksheets' and 'chartsheets' if you are not sure what kind of sheet you have this is where the information is stored.

    attribute methods Methods provided to adjust this attribute

      get_sheet_type

        Definition: returns the value stored in the attribute (chartsheet)

workbook_instance

SUPPORT

TODO

    1. Figure out what users want from their charts and how they want to read it.

AUTHOR

Jed Lund
jandrew@cpan.org

COPYRIGHT

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.

This software is copyrighted (c) 2014, 2015 by Jed Lund

DEPENDENCIES

SEE ALSO