NAME

Spreadsheet::Compare::Reader::WB - Workbook Adapter for Spreadsheet::Compare

DESCRIPTION

This module provides a fetch interface for various spreadsheet workbook formats (Excel/OpenOffice/LibreOffice). It uses Spreadsheet::Read for reading the spreadsheet data. Spreadsheet::Read will not be installed as a hard dependency for Spreadsheet::Compare, so it has to be manually installed.

ATTRIBUTES

If not stated otherwise, read write attributes can be set as options from the config file passed to Spreadsheet::Compare or spreadcomp.

data_row

            

              
              
possible values: <integer>
default: 1
            
          

The starting row number of record data

data_col

            

              
              
possible values: <integer>
default: 0
            
          

The starting column number of record data

header_row

            

              
              
possible values: <integer>
default: 0
            
          

The row containing the header line (if "has_header" in Spreadsheet::Compare::Reader) is set.

header_col

            

              
              
possible values: <integer>
default: 0
            
          

The starting column number of header data (if "has_header" in Spreadsheet::Compare::Reader) is set.

rootdir

Set by Spreadsheet::Compare during reader initialisation. Same as "rootdir" in Spreadsheet::Compare.

sheet

(readonly) The sheet object.

sheetname

(readonly) The sheetname for this reader. Use "sheets" for filename/sheetname specification.

sheets

            

              
              
possible values: <list of exactly 2 filename::sheetname specifications>
default: []
            
          

Example:

            

              
              
sheets:
  - ./left_dir/data.ods::MyDataSheet
  - ./right_dir/data.ods::MyDataSheet
            
          

or

            

              
              
sheets:
  - ./data.xlsx::Sheet_001
  - ./data.xlsx::Sheet_002
            
          

Relative filenames will be interpreted releative to "rootdir"

sr_options

            

              
              
possible values: <hash>
default: {}
            
          

Example:

            

              
              
sr_options:
  dtfmt: 'yyyy-mm-dd'
            
          

A reference to a hash with options for calling the Spreadsheet::Read constructor.

wb

(readonly) The Spreadsheet::Read instance.

METHODS

Spreadsheet::Compare::Reader::WB inherits or overwrites all methods from Spreadsheet::Compare::Reader.

cpanm Spreadsheet::Compare

perl -MCPAN -e shell
install Spreadsheet::Compare