diff options
author | Jesse Luehrs <doy@tozt.net> | 2015-12-04 00:24:36 -0500 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2015-12-04 00:24:36 -0500 |
commit | 95686bb1c95eb60c674055bd6477227357a022c9 (patch) | |
tree | b7a9703b1a83fbdfaae88d8bec2ba56d89f1b706 /t | |
parent | 54ace637bf4ddfc1469ffcc7cdaf429ca2b88814 (diff) | |
parent | a2104941f31a97bd3661b930dc135d2b019e4725 (diff) | |
download | spreadsheet-parsexlsx-95686bb1c95eb60c674055bd6477227357a022c9.tar.gz spreadsheet-parsexlsx-95686bb1c95eb60c674055bd6477227357a022c9.zip |
Merge pull request #37 from mazurin/encryption
Diffstat (limited to 't')
-rw-r--r-- | t/data/encryption-agile-123q.xlsx | bin | 0 -> 13312 bytes | |||
-rw-r--r-- | t/data/encryption-standard-default-password.xlsx | bin | 0 -> 12288 bytes | |||
-rw-r--r-- | t/encryption.t | 30 |
3 files changed, 30 insertions, 0 deletions
diff --git a/t/data/encryption-agile-123q.xlsx b/t/data/encryption-agile-123q.xlsx Binary files differnew file mode 100644 index 0000000..be3b561 --- /dev/null +++ b/t/data/encryption-agile-123q.xlsx diff --git a/t/data/encryption-standard-default-password.xlsx b/t/data/encryption-standard-default-password.xlsx Binary files differnew file mode 100644 index 0000000..a863c1b --- /dev/null +++ b/t/data/encryption-standard-default-password.xlsx diff --git a/t/encryption.t b/t/encryption.t new file mode 100644 index 0000000..cbd913e --- /dev/null +++ b/t/encryption.t @@ -0,0 +1,30 @@ +#!/usr/bin/env perl +use strict; +use warnings; +use Test::More; + +use Spreadsheet::ParseXLSX; + +my $parser = Spreadsheet::ParseXLSX->new(); +my $workbook = $parser->parse("t/data/encryption-agile-123q.xlsx", {password => '123q'}); + +my $worksheet; +my $cell; + +$worksheet = $workbook->worksheet(0); +ok(defined($workbook)); + +$cell = $worksheet->get_cell(1, 1); +ok(defined($cell) && $cell->value() eq 'abcdefgABCDEFG'); + + +open FH, "t/data/encryption-standard-default-password.xlsx"; +$workbook = $parser->parse(\*FH); + +ok(defined($workbook)); + +$worksheet = $workbook->worksheet(0); +$cell = $worksheet->get_cell(22, 8); +ok(defined($cell) && $cell->value() == 1911); + +done_testing; |