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 script
Windows with .zip file
- Exit StarDrop
- Download zip
- In your user area, navigate to the StarDrop Python folder in C:\Users\username\AppData\Roaming\StarDrop
- Create a new folder with the name Export to Excel inside the py3 folder.
- Extract the contents of the zip file
- Place the myCriteria.py and StarDropToXLS.py files into the Export to Excel folder
- Place the xlwt file into the StarDrop\site-packages\xlwt directory
- Place the DataSetUtils.py and package_functions.py files into the StarDrop\py3\Utils directory
- Start StarDrop
macOS with .zip file
- Exit StarDrop
- Download zip file
- In your user area, navigate to the StarDrop folder: /Users/username/StarDrop/py3
- Create a new folder with the name Export to Excel inside the py3 folder.
- Extract the contents of the zip file, move the Export to Excel -macOS file contents into the Export to Excel folder.
- Move DataSetUtils.py file to the py3/Utils folder, overwriting any existing files.
- Start StarDrop
Windows with .exe file
- 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
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.
Installation files
Windows with .zip file
- Exit StarDrop
- Download zip
- In your user area, navigate to the StarDrop Python folder in C:\Users\username\AppData\Roaming\StarDrop
- Create a new folder with the name Export to Excel inside the py3 folder.
- Extract the contents of the zip file
- Place the myCriteria.py and StarDropToXLS.py files into the Export to Excel folder
- Place the xlwt file into the StarDrop\site-packages\xlwt directory
- Place the DataSetUtils.py and package_functions.py files into the StarDrop\py3\Utils directory
- Start StarDrop
macOS with .zip file
- Exit StarDrop
- Download zip file
- In your user area, navigate to the StarDrop folder: /Users/username/StarDrop/py3
- Create a new folder with the name Export to Excel inside the py3 folder.
- Extract the contents of the zip file, move the Export to Excel -macOS file contents into the Export to Excel folder.
- Move DataSetUtils.py file to the py3/Utils folder, overwriting any existing files.
- Start StarDrop
Windows with .exe file
- 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
How to use the 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.