Home

Welcome to your wiki!

This is the default page, edit it as you see fit. To add a new page simply reference it within brackets, e.g.: [SamplePage].

The wiki uses Markdown syntax.

Project Members:

• Danil Karimov (admin)

[Danil Karimov]

Slk Repair

Tool for degreasing fat SLK files

Problem

When working with the SLK-files in Excel the following problem is known: when the number of sheets reaches a certain value (> 255), it either does not display properly, or (in severe cases), its opening leads to the collapse of Excel . This is especially noticeable in Excel from Office 2007/2010, because, unlike his predecessor, it records a copy of the style sheet (record type P;F or P;E) every time you save a new document. Simple cleaning the document title of unnecessary records does not help, because the document contains references to the styles used. In order to successfully correct the error output when opening Excel "clearing" the documents required to correct the references correctly .

Solution

SlkRepair program performs menial of the work to correct the document. It looks for used styles, stores them in the file header, and arranges them by reference. Correction is carried out "in place", the old document is copied to the backup with the addition of a tilde (~) to the file name. Restarting replaces the old document with corrected one, so if for any reason you are not satisfied with the results of the program, make sure that the old document has been properly maintained.

Usage:

slkrepair <​​list of files> [/C[ONVERT]:(0|1|Y[ES]|N[O])].

Example:

slkrepair report.slk sklrep01.slk rep.slk /c:0

Of coarse, the application file must be located in an accessible place, preferably declared in the PATH environment variable