Limitations with the Excel Writer

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Limitations with the Excel Writer

John Bishai
Hello,
I think I've pushed the Excel Writer to its limits. I am getting over 32000 counts which seems to be
beyond the limitation of what can be handled. As a result, I get the following message:

java.lang.IllegalArgumentException: Row out of range: -32768
 at ij.measure.ResultsTable.getRowAsString(Unknown Source)
 at ExcelInterface.SaveToExcel.writeRsTable(SaveToExcel.java:156)
 at Excel_Writer.run(Excel_Writer.java:28)
 at ij.IJ.runUserPlugIn(Unknown Source)
 at ij.IJ.runPlugIn(Unknown Source)
 at ij.Executer.runPlugIn(Unknown Source)
 at ij.Executer.runCommand(Unknown Source)
 at ij.Executer.run(Unknown Source)
 at java.lang.Thread.run(Thread.java:552)

Is there any way around this glitch?

Thanks,
John
Reply | Threaded
Open this post in threaded view
|

Re: Limitations with the Excel Writer

Wayne Rasband
> I think I've pushed the Excel Writer to its limits. I am
> getting over 32000 counts which seems to be beyond the
> limitation of what can be handled. As a result, I get the
> following message:

> java.lang.IllegalArgumentException: Row out of range: -32768
>  at ij.measure.ResultsTable.getRowAsString(Unknown Source)
>  at ExcelInterface.SaveToExcel.writeRsTable(SaveToExcel.java:156)
>  at Excel_Writer.run(Excel_Writer.java:28)
>  at ij.IJ.runUserPlugIn(Unknown Source)
>  at ij.IJ.runPlugIn(Unknown Source)
>  at ij.Executer.runPlugIn(Unknown Source)
>  at ij.Executer.runCommand(Unknown Source)
>  at ij.Executer.run(Unknown Source)
>  at java.lang.Thread.run(Thread.java:552)
>
> Is there any way around this glitch?

Right click on the Results window (control click on the Mac), select
"Save As" from the drop down menu, and change the suggested extension
from .txt to .xls.

-wayne