NAME

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

DESCRIPTION

This module provides an open/fetch interface for various spreadsheet workbook formats (Excel/OpenOffice/LibreOffice). It uses Spreadsheet::Read for reading the spreadsheet data.

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