imagej2 icon indicating copy to clipboard operation
imagej2 copied to clipboard

How to fix read and write excel

Open dczomby opened this issue 7 years ago • 2 comments

Hello there, i had an issue when i try saving my results by using read and write excel, it always show me an Exception window, and Rename me after writing is done.xlsx never exist anymore. I mean i cant save my measure results into excel. Is there any kind of methods that can fix this macro? or copy manually is the best option? Thanks

(p.s this problem occurs after i reinstall my office 2016) p.p.s i'm sorry for my bad english

(Fiji Is Just) ImageJ 2.0.0-rc-68/1.52e; Java 1.8.0_172 [64-bit]; Windows 10 10.0; 96MB of 2965MB (3%)
 
java.io.FileNotFoundException: C:\Users\HP\Desktop\Rename me after writing is done.xlsx (The system cannot find the file specified)
	at java.io.FileOutputStream.open0(Native Method)
	at java.io.FileOutputStream.open(FileOutputStream.java:270)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:162)
	at Read_and_Write_Excel$ExcelHolder.ensureExcelFileExists(Read_and_Write_Excel.java:311)
	at Read_and_Write_Excel$ExcelHolder.readFileAndOpenWorkbook(Read_and_Write_Excel.java:292)
	at Read_and_Write_Excel.run(Read_and_Write_Excel.java:123)
	at ij.IJ.runUserPlugIn(IJ.java:228)
	at ij.IJ.runPlugIn(IJ.java:192)
	at ij.Executer.runCommand(Executer.java:137)
	at ij.Executer.run(Executer.java:66)
	at java.lang.Thread.run(Thread.java:748)
(Fiji Is Just) ImageJ 2.0.0-rc-68/1.52e; Java 1.8.0_172 [64-bit]; Windows 10 10.0; 97MB of 2965MB (3%)
 
java.lang.NullPointerException
	at Read_and_Write_Excel.openSheetInWorkbook(Read_and_Write_Excel.java:226)
	at Read_and_Write_Excel.run(Read_and_Write_Excel.java:138)
	at ij.IJ.runUserPlugIn(IJ.java:228)
	at ij.IJ.runPlugIn(IJ.java:192)
	at ij.Executer.runCommand(Executer.java:137)
	at ij.Executer.run(Executer.java:66)
	at java.lang.Thread.run(Thread.java:748)

dczomby avatar Aug 27 '18 04:08 dczomby

Read_and_Write_Excel is an external plugin, so this issue likely belongs here: https://github.com/antinos/Results_To_Excel/issues

@dczomby you can save xls files directly from the results table in ImageJ, via File > Save As.... Is there any specific functionality missing why you'd use the other plugin?

imagejan avatar Aug 27 '18 08:08 imagejan

@imagejan well, i didn't know that such a method can be used, because when i tried to save my results the extension files had .csv code and when i open it by using excel 2016, it make all of my results into single row, like label area mean etc. then the next row below it show my measurements. that's why i intended to keep in touch with this plugin.

Sorry for my late answer, P.S so we need to delete the .csv to .xls then, thank you for your care

dczomby avatar Aug 28 '18 21:08 dczomby