How to fix read and write excel
- Dominant language
- Java
- Stars
- 1.4k
- Forks
- 350
- PR merge metrics
- No merged PRs in 30d
Description
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.(FileOutputStream.java:213)
at java.io.FileOutputStream.(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)
```
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with Read_and_Write_Excel.java at ensureExcelFileExists (line 311), readFileAndOpenWorkbook (line 292), and openSheetInWorkbook (line 226), using the two reported stack traces as the entry point. Reproduce the save operation in the stated ImageJ, Java, Windows, and Office environment, then verify that the workbook is created and the results can be saved without either exception.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- desktop
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100