From 48c05714c254df089e170c014661db9a4bc7d21d Mon Sep 17 00:00:00 2001 From: Steve Simms Date: Thu, 29 Oct 2015 16:05:14 -0400 Subject: Check to see if rows and columns are hidden --- t/data/hidden-row-and-column.xlsx | Bin 0 -> 7467 bytes t/hidden-row-and-column.t | 17 +++++++++++++++++ 2 files changed, 17 insertions(+) create mode 100644 t/data/hidden-row-and-column.xlsx create mode 100644 t/hidden-row-and-column.t (limited to 't') diff --git a/t/data/hidden-row-and-column.xlsx b/t/data/hidden-row-and-column.xlsx new file mode 100644 index 0000000..4d4bac4 Binary files /dev/null and b/t/data/hidden-row-and-column.xlsx differ diff --git a/t/hidden-row-and-column.t b/t/hidden-row-and-column.t new file mode 100644 index 0000000..cd18c70 --- /dev/null +++ b/t/hidden-row-and-column.t @@ -0,0 +1,17 @@ +#!/usr/bin/env perl +use strict; +use warnings; +use Test::More; + +use Spreadsheet::ParseXLSX; + +my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/hidden-row-and-column.xlsx'); +my $ws = $wb->worksheet(0); + +ok(!$ws->is_row_hidden(0), 'Regular row is not hidden'); +ok( $ws->is_row_hidden(1), 'Hidden row is hidden'); + +ok(!$ws->is_col_hidden(0), 'Regular column is not hidden'); +ok( $ws->is_col_hidden(1), 'Hidden column is hidden'); + +done_testing; -- cgit v1.2.3-54-g00ecf