Reduce the Size of your XLF and SWF Files

If you are working on Large XLF files, your SWF load time might drastically increase due the number of components used and the Excel Logic that you have implemented. In order to reduce the size of your XLF file and eventually the generated SWF file, you can follow the below mentioned steps. Please note that these steps might not work always.

Many of you must have noticed the unusual increase in size of the XLF file when you save the file multiple times. This is not an issue with Xcelsius; however it is an issue with Excel. Follow the below steps to make your Xcelsius Model light.

Note: Make sure that you perform these steps within the Embedded Excel sheet in design mode. Also note that we take no responsibility of any data loss, hence after each step save different versions of the file.

After each step check the file size by right clicking and selecting the Properties option.

Do the following to ALL Worksheets.

  1. Select any single cell then push F5, click Special and check the “Blanks” option and click Ok.
  2. Now go to Edit>Clear>All.
  3. Manually go to the last used row in the Worksheet (do not use Edit>Go to-Special “Last Cell”).
  4. Select the entire row beneath, then holding down the Ctrl+Shift key push the Down Arrow.
  5. This should select all unused rows. Now go to Edit>Clear>All. Do the same for the Columns.
  6. Click SAVE twice.

Hope this helps reduce the file Size by few KBs and reduce the Load time by few Seconds.