nick322/secure-spreadsheet

Encrypt and password protect sensitive XLSX files

1.0.15 2025-02-17 03:31 UTC

Requires

• php: ^7.3 || ^8.0
• ext-hash: *
• ext-openssl: *
• ext-simplexml: *
• mnapoli/silly: ^1.0
• pear/ole: ^1.0

Requires (Dev)

• pear/pear-core-minimal: *
• phpunit/phpunit: ^9.6 || ^10 || ^11

MIT

• Nick Huang

README

🔥 Secure your data exports - encrypt and password protect sensitive XLSX files

The Office Open XML format provides a standard for encryption and password protection

Works with Excel, Numbers, and LibreOffice Calc

Installation

To install the package:

Run composer require nick322/secure-spreadsheet to add the package to your project.

Or run composer global require nick322/secure-spreadsheet to add the package to your system.

This will automatically install the package to your vendor folder.

Use

In cli

secure-spreadsheet run --password=1 --input=/Users/nick/Encryptor/Book1.xlsx --output=/Users/nick/Encryptor/bb.xlsx

In php

require "vendor/autoload.php";

use Nick\SecureSpreadsheet\Encrypt;

$test = new Encrypt();
$test->input('Book1.xlsx')
    ->password('111')
    ->output('bb.xlsx');

If you want to only use memory/variable output and input, and no file interaction

$test = new Encrypt($nofile = true);
$output = $test->input($binaryData)
    ->password('111')
    ->output();

Credits

Thanks to xlsx-populate for providing the encryption and password protection.

History

View the changelog

Contributing

Everyone is encouraged to help improve this project. Here are a few ways you can help:

• Report bugs
• Fix bugs and submit pull requests
• Write, clarify, or fix documentation
• Suggest or add new features

To get started with development:

git clone https://github.com/nick322/secure-spreadsheet.git
cd secure-spreadsheet
./secure-spreadsheet