From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

 / 
Spreadsheet-Compare-0.16
River stage zero No dependents
/ Spreadsheet::Compare::Reader::WB

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.