From 18d2af2335741cdf59cb0725669f7aa7a7fad98b Mon Sep 17 00:00:00 2001 From: Steve Simms Date: Thu, 29 Oct 2015 15:30:45 -0400 Subject: Check to see if worksheets are hidden --- t/data/hidden-sheet.xlsx | Bin 0 -> 7397 bytes t/hidden-sheet.t | 15 +++++++++++++++ 2 files changed, 15 insertions(+) create mode 100644 t/data/hidden-sheet.xlsx create mode 100644 t/hidden-sheet.t (limited to 't') diff --git a/t/data/hidden-sheet.xlsx b/t/data/hidden-sheet.xlsx new file mode 100644 index 0000000..d29cafb Binary files /dev/null and b/t/data/hidden-sheet.xlsx differ diff --git a/t/hidden-sheet.t b/t/hidden-sheet.t new file mode 100644 index 0000000..09d4402 --- /dev/null +++ b/t/hidden-sheet.t @@ -0,0 +1,15 @@ +#!/usr/bin/env perl +use strict; +use warnings; +use Test::More; + +use Spreadsheet::ParseXLSX; + +my $wb = Spreadsheet::ParseXLSX->new->parse('t/data/hidden-sheet.xlsx'); +my $ws1 = $wb->worksheet(0); +ok(!$ws1->is_sheet_hidden(), 'Regular worksheet is not hidden'); + +my $ws2 = $wb->worksheet(1); +ok($ws2->is_sheet_hidden(), 'Hidden worksheet is hidden'); + +done_testing; -- cgit v1.2.3-54-g00ecf