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