Optibrium Community

Downloads

Export to Excel

May 16, 2022

Export to Excel

May 16, 2022

The Export to Excel script provides a quick and easy way to transfer the contents of a data set straight into Microsoft® Excel®. The necessary files and instructions for how to install and use the script are provided in the following pages…

Version

This script is for StarDrop 7.3 for either Windows® or macOS®. To find out which version you have installed, start StarDrop and select the Help->About menu

Installation

We have recently updated StarDrop’s scripting to make it easier for everyone to download and install scripts without needing administrator privileges. If you are already using custom scripts that you downloaded and installed while using a previous version of StarDrop, then you will need to download these again (they have all been updated) and follow the installation instructions. If you are using any in-house scripts to access internal systems or databases, or are uncertain about what to do, then please contact stardrop-support@optibrium.com for assistance.

To install this script on Windows:

  • Ensure that you have saved your work and close StarDrop
  • Download the file StarDrop Script – Export To Excel.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

To install this script on macOS or Windows:

  • Ensure that you have saved your work and close StarDrop
  • Download the file StarDrop Script – Export To Excel.zip
  • In your user area, navigate to the StarDrop Python folder (on Windows this is in C:\Users\username\AppData\Roaming\StarDrop\py, on macOS, this is in ~/StarDrop/py)
  • Extract the contents of StarDrop Script – Export To Excel.zip into this folder overwriting any existing files
  • You should now see a folder called Export To Excel and a folder called Utils
  • Start StarDrop

For StarDrop 7.2 or earlier please use the following files:
On Windows – Download the file StarDrop Script – Export To Excel_py2.exe
On macOS or Windows – Download the file StarDrop Script – Export To Excel_py2.zip

To use this 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.