This project aims to fix "broken" Excel files that load extremely slowly due to broken references. It does that by searching for broken references and removing them from the Excel file.
This project is intended to be run on PowerShell Core. All plugins should ideally run on all OSes.
To run, load the PowerShell module (Import-Module excelerate.psd1) and run Repair-XLSX.
Repair-XLSX currently just has 2 required arguments, -InFile and -OutFile. InFile is the XLSX file which needs to be repaired. OutFile is the filename you want to save the repaired file as. Currently you cannot overwrite an existing file and any attempts to do so will result in an error.
Note that Repair-XLSX will support many options in the future and those options are hinted, but they will currently do nothing.
This project may be built using make. To build, simply run make then make test to run the Pester tests.
For ease of testing, you may also run make shell to dump you into a shell with the module imported.
Note that make install is NOT currently implemented. Installation is currently manual. In the future we will try to implement make install.
To install, copy all the files in the "build" directory into a new folder in your PowerShell modules directory.
The following functions are publicly exported from this module for use. These functions may be used either manually, or in automated jobs.
- Repair-XLSX This function will attempt to repair an XLSX file by removing broken references