Optibrium Community

Downloads

Export to Excel StarDrop Script

Sep 22, 2023

The Export to Excel script provides a quick and easy way to transfer the contents of a data set straight into Microsoft Excel.

Version

This integration is available to use with the latest version of StarDrop (Windows and macOS). To find out which version you have installed, start StarDrop and select the Help->About menu.

If you are using an older version of StarDrop, please contact us at support@optibrium.com and we will be happy to help install this script on your StarDrop client.

Installing and using the Export to Excel script for StarDrop

  • Exit StarDrop
  • Download StarDrop Script – Export to Excel_py3Qt.exe
  • When the download is complete, double-click the file to run it and follow the instructions (we recommend that you accept the default options provided)
  • Start StarDrop
  • Exit StarDrop
  • Download StarDrop Script – Export To Excel_py3Qt.zip
  • In your user area, navigate to the StarDrop Python folder in C:\Users\username\AppData\Roaming\StarDrop
  • Extract the contents of the zip file into this folder overwriting any existing files
  • You should now see the following folders in the StarDrop folder:
    py3\Export To Excel
  • Start StarDrop
  • Exit StarDrop
  • Download StarDrop Script – Export To Excel_py3Qt.zip
  • Extract the contents of the zip file into this folder overwriting any existing files, you should now see the following folders in the StarDrop folder:
    py3\Export To Excel
  • In your user area, navigate to the StarDrop folder: /Users/username/StarDrop
  • Move the unzipped folders, sub-folders, and files into the StarDrop folder, overwriting any existing files
  • Start StarDrop

To use the Export to Excel script

Click on the Custom Scripts->Export to Excel menu item in StarDrop. If there is no data set open it will give a message saying that there is nothing to export. If there is a data set open, the contents will be copied into a Microsoft Excel worksheet and Microsoft Excel will automatically be opened to display the file.

Please note: StarDrop contains a number of data types that are not supported by Microsoft Excel, however, an accurate numerical or textual representation of each data point is exported wherever possible.

It is possible to customise the formatting that appears in the Microsoft Excel file and some examples are provided which will be visible if you open the example StarDrop file StarDropDemo.add (the default installation path for this is C:\Program Files\StarDrop\Examples\StarDropDemo.add) and export the complete file using this script. To change the formatting you must manually edit the file myCriteria.py that is installed in C:\Users\\AppData\Roaming\StarDrop\py choosing any colours, fields and any criteria you wish to set define how a column of data should be displayed.