Updating plugin ResultsToExcel automatically is not working

Hello folks,
I have now tried several times to install the plugin ResultsToExel as a new plugin via Help–>Update–>Manage Update Site without success…I keep getting the following error message:

[ERROR] javax.net.ssl.SSLException: SSL peer shut down incorrectly
at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:596)
at sun.security.ssl.InputRecord.read(InputRecord.java:532)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983)
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:940)
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:284)
at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
at sun.net.www.MeteredStream.read(MeteredStream.java:134)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(HttpURLConnection.java:3393)
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(HttpURLConnection.java:3386)
at net.imagej.updater.util.Downloader.download(Downloader.java:128)
at net.imagej.updater.util.Downloader.start(Downloader.java:98)
at net.imagej.updater.Installer.start(Installer.java:154)
at net.imagej.ui.swing.updater.UpdaterFrame.install(UpdaterFrame.java:627)
at net.imagej.ui.swing.updater.UpdaterFrame$13.run(UpdaterFrame.java:564)

Does anyone have a suggested solution? I do not know how to install the plugin manually.

Hi @hofmanpa,

If you can, I would highly recommend using the Fiji updater. I don’t recognise those error codes and don’t have much experience with SSL sockets and server handshake stuff. Maybe its something to do with your internet? Perhaps others can help you on this front.

As a recommended last resort, this is how you can do a manual install:

  • Navigate to Index of /ResultsToExcel
  • From the ‘plugins’ directory on this site, save the the ‘1.1.7.jar’ file to your computer
  • Move this file to the ‘plugins’ folder of your ImageJ/Fiji
  • Rename the file to remove everything after ‘.jar’… so remove the -20200926151143 bit
  • Back to the website, from the other ‘jars’ directory, save the following files to your computer:
    • commons-collections4-4.1
    • poi-3.17
    • poi-ooxml-3.17
    • poi-ooxml-schemas-3.17
    • xmlbeans-2.6.0 (latest version, should be at the bottom)
  • Move these to the ‘jars’ folder of Imagej/Fiji
  • Rename the files to remove anything after the ‘.jar’
  • Open ImageJ/Fiji

Doing the manual install may stop you getting auto updates, so its better to use the updater if you can get that to work.

Kind regards.

1 Like

@antinos thanks for your quick reply, I tried another network for downloading the plugin, now it works!

Hello @antinos,

I have discovered macros for myself for quick editing of a series of images. At the moment, the transfer of results is still failing to some extent. Is there a possibility to transfer the summary with the plugin Read and Write to Excel?

In the following my actual macro code with an image example enclosed:
// prompt to open an image
run(“Bio-Formats Importer”, “open=’”);
originalImageID = getImageID();

//Preprocess
run(“Mean…”, “radius=1”);
run(“Histogram”);
waitForUser(“Foreground Selection”, “Look at the histogram \n \nNOTE- Reduce the mode value by 20 %. Subtract the value from 255. You get the actual value for background reduction, click OK to continue”);

//example value = 109
number = getNumber(“Value to be substracted and added:”, “”);
close();

run(“Duplicate…”, " ");
run(“Invert”);
run(“Subtract…”, “value=[number]”);
run(“Add…”, “value=[number]”);

//Threshold
setAutoThreshold(“Otsu dark no-reset”);
run(“Threshold…”);
setOption(“BlackBackground”, true);
run(“Convert to Mask”);
run(“Close”);

//clean up with morphological operations
run(“Erode”);
run(“Fill Holes”);

//Identify&Analyse
run(“Set Scale…”, “distance=1924.0000 known=500 unit=µm global”);
run(“Set Measurements…”, “area mean standard min perimeter bounding shape feret’s area_fraction limit redirect=None decimal=3”);
run(“Analyze Particles…”, “size=5-Infinity pixel display exclude summarize add”);
run(“Clear Results”);
selectImage(originalImageID);
roiManager(“Show All with label”);
roiManager(“Deselect”);
roiManager(“Measure”);
run(“Summarize”);

//saves segmented image as binary image
run(“Bio-Formats Exporter”, “save=’”);
run(“Close All”);
run(“Read and Write Excel”);
close(“Results”);

greetings,
Paul

Link to image example: https://we.tl/t-eJVHGH6BwQ

Hi @hofmanpa,

You can rename the summary table to ‘Results’ before calling the plugin again. Just make sure to have finished with the actual results table first. In your macro, I guess you can place the new commands after you close your results table at the end. The summary data should then be imported next to the results data in the same .xlsx file.

Of course, if you do not need the .xlsx and native single file appending features of the plugin, you can also use the csv saving function of ImageJ, which will look something like this:

selectWindow("Summary.csv");
saveAs("Results", "C:/Users/Hofmann/Desktop/My_file.csv");

Kind regards.