User:ResultsToExcel

Revision as of 06:23, 1 November 2016 by ResultsToExcel (talk | contribs)

I only have one ImageJ/Fiji plugin to date.

plugins/Read_and_Write_Excel-1.0.1.jar (Installation instructions at bottom of this page)

Created in Eclipse IDE Mars.1 release (4.5.1), using the java jdk1.6.0_45 for ImageJ/Fiji compatibility.

Release date:

19 Nov 2015 v1.0.0

25 Nov 2015 v1.0.1

Description : This plugin extracts data from the Results Table and adds it to a sheet-tab "A" in an .xlsx Excel file on the user's desktop. The plugin will create a file named "Rename me after writing is done" on the desktop if none-exists already, and will update this file if it has already been created. Data is added to the latest sheet (created as "A" if the file is new). Within the latest sheet, data will be added adjacent to previous data. Results Table column headers are added automatically (I'm not sure if custom headers are supported as I haven't tested this yet).

This plugin can be called from a macro using: run("Read and Write Excel"); and it works very well with batching.

For legacy purposes, the data can also be fed to the plugin as a single-line string argument, in which case this will take priority over the open Results Table e.g.: run("Read and Write Excel", arg);

I am aware that another Excel_Writer plugin exists but it did not work for me very well (hence me creating this). I did not consult their source code but did find out about Apache POI(*) from them.

If you decide to consult my source-code, please excuse odd methods and strange notes. I have taught myself Java to write this.

(*)This plugin uses the Apache POI api, which is distributed under the terms of the Apache Licence (available from https://poi.apache.org/legal.html). I believe this software to be free and open source.

Version 1.0.1 changes: 1) package is not bloated by dependency .jar files. 2) now contains source-code for reference. 3) removed platform specification as I believe this plugin will work across operating systems.

Author: Anthony Sinadinos

Platforms: Multi

Category: Input/Output. Export data to file. Batch tested.

Link: YouTube tutorial (https://www.youtube.com/watch?v=79rzUae-7N8)

Dependencies: jars/xmlbeans.jar, jars/poi-ooxml.jar, jars/poi-ooxml-schemas.jar, jars/poi.jar, jars/ij.jar

Update site: http://sites.imagej.net/ResultsToExcel

Installation:

  • - With ImageJ open, navigate to 'Help'
  • - In the presented drop down menu, then select 'Update...'
  • - Allow ImageJ to check for updates
  • - If required, download updates and restart ImageJ as prompted
  • - Repeat the first two steps = Help>Update...
  • - This time ImageJ should let you know that there are no updates available
  • - Click on 'OK' but do not close the 'ImageJ Updater' window that is also open
  • - In the bottom left of the 'ImageJ Updater' window, find and click on 'Manage update sites'
  • - In the newly presented 'Manage update sites' window, find and check the 'ResultsToExcel' check box
  • - Then close the 'Manage update sites' window
  • - The 'ImageJ Updater' window will now present you with the plugin files for installation
  • - Press 'Apply changes'
  • - After the update has been applied successfully, restart ImageJ