Refer to the original version of the XLStylesTool user comminity contributed information and “how to” video.
Windows 8 Version Specifics:
All original application features and settings described in the user community contributed documentation, comments and older posts on this site for the most part apply to the Windows 8 version. The user interface has been upgraded to Windows 8 immersive experience and the processing algorithms have been adjusted to run in the sandboxed environment. The reason for this upgrade is the drastic change in how Windows 8 runs older .Net applications in the desktop mode. All unsigned applications get blocked with the message that would stop most users from launching the app the first time. Since I don’t have digital certificate and want to keep the application free, I chose to write Windows 8 version that is very user friendly and is fully trusted by the Windows 8 OS because it is distributed from the Windows App Store. This version of the tool will also be supported on the Windows RT – ARM processor based Windows 8 tablets that will also run MS Office. Old .Net or Silverlight apps won’t work on Win RT. Please take a note of the following differences in functionality:
- There is no “Commit changes and open in Excel” check box. Because of the brokered file system access I can no longer launch the processed file. Also, unlike in the WinForms version of the app all file changes once you click “Process File” button are permanent. Please work with file backups if you need to try out various option combinations on your files.
- Processed file will show noticable drop in size after you preview and save it in MS Excel for the first time after it has been processed. Previously file was opened automatically and Excel was prompting you to save it on file close.
- Error message: “Selected file is not readable. Access is denied.” This error message is specific to Windows 8 and in most cases means that the Excel file that you selected is opened in another application (most likely Excel) or by another user, so the app can’t open it with exclusive rights. Close the file in the app that has it opened and try to scan again.
Original Post History:
UPDATE [7/9/12]: Windows 8 Metro version of the XLStylesTool was submitted to the store to be released on the RP build, but I just found out that it won’t be available until General Availability of the Windows App Store (Windows 8 goes RTM first week of August). They won’t publish any more apps at the store until GA. Please use browser based SL5 app in the desktop mode for now if you are on Win8.
UPDATE [9/24/12]: Updated for Windows 8 RTM app has been submitted to the store at 9:24PM PST. If it gets published I will go through the effort of adding Windows 8 version specific help content in this post. This post is linked to the Help pane to ensure the content is always current.
UPDATE [10/01/12]: The app got certified and published: XLStylesTool for Windows in the Windows App Store . I will update Windows 8 specific info in this post very shortly.
UPDATE [10/22/12]: First wave of Windows 8 users provided their feedback (Thank You!). There was only one reported usability issue so far: users that already had their Excel file open in the Desktop Excel app got “Access is denied…” error message and some didn’t know what to do. I added bolded text bullet in the Help section of the post above and submitted Release 2 to the store. Release 2 will have more explicit error message: it will suggest to close already opened file.
UPDATE [10/20/13]: Release 3 that contains Windows 8.1 version of the XLStyles Tool passed App store certification and is available to Windows 8.1 users.