Difference between revisions of "User:ResultsToExcel"

Line 6: Line 6:
  
 
Release date:
 
Release date:
 +
 
19 Nov 2015 v1.0.0
 
19 Nov 2015 v1.0.0
  
Line 42: Line 43:
  
 
Link:
 
Link:
 +
YouTube tutorial (https://www.youtube.com/watch?v=79rzUae-7N8)
  
 
Dependencies:
 
Dependencies:

Revision as of 08:08, 25 November 2015

I only have one ImageJ/Fiji plugin to date.

plugins/Read_and_Write_Excel-1.0.1.jar

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