Result from particle analysis saved as XLS is not XLS?

[Cspr]

I found this very interesting.

After running a analyze particles I save the results as Results.xls

Interestingly when opening the XLS file is Microsoft Excel 2007 I am told by Exel that it is not a recognized format and I should be careful about opening. Nevertheless allowing the program to open it display the results just as they were saved.

Although this is perfectly alright it's somewhat irritating when trying to further process the XLS files. The reason for this is that trying to import the saved XLS file in MatLab causes an error because of the exact fact that apparently the saved XLS file is NOT a Microsoft Excel file.

Anyone else can verify this?

[lechristophe]

xls files generated by ImageJ are in fact plain tab-delimited text file.
Although it used to work Ok with Excel, if you have problems, my suggestion
is that you change the default extension of files saved by ImageJ to ".txt"
(using Edit>Options>Input/Output, "File Extensions for Tables" field). So
when opening with Excel your files will be processed to the "Import text
file" dialog, ensuring correct reading.

Christophe

On Wed, Apr 28, 2010 at 14:58, Cspr <[hidden email]> wrote:

> I found this very interesting.
>
> After running a analyze particles I save the results as Results.xls
>
> Interestingly when opening the XLS file is Microsoft Excel 2007 I am told
> by
> Exel that it is not a recognized format and I should be careful about
> opening. Nevertheless allowing the program to open it display the results
> just as they were saved.
>
> Although this is perfectly alright it's somewhat irritating when trying to
> further process the XLS files. The reason for this is that trying to import
> the saved XLS file in MatLab causes an error because of the exact fact that
> apparently the saved XLS file is NOT a Microsoft Excel file.
>
> Anyone else can verify this?
> --
> View this message in context:
> http://imagej.588099.n2.nabble.com/Result-from-particle-analysis-saved-as-XLS-is-not-XLS-tp4974260p4974260.html
> Sent from the ImageJ mailing list archive at Nabble.com.
>

[Michael Schmid]

Hi Cspr,

you can set the extension in Edit>Options>input/output.
Maybe Matlab is more happy with ".txt"
Some programs might also understand '.csv', although the files do not  
contain comma-separated but rather tab-separated lists.

Michael
________________________________________________________________

On 28 Apr 2010, at 14:58, Cspr wrote:

> I found this very interesting.
>
> After running a analyze particles I save the results as Results.xls
>
> Interestingly when opening the XLS file is Microsoft Excel 2007 I  
> am told by
> Exel that it is not a recognized format and I should be careful about
> opening. Nevertheless allowing the program to open it display the  
> results
> just as they were saved.
>
> Although this is perfectly alright it's somewhat irritating when  
> trying to
> further process the XLS files. The reason for this is that trying  
> to import
> the saved XLS file in MatLab causes an error because of the exact  
> fact that
> apparently the saved XLS file is NOT a Microsoft Excel file.
>
> Anyone else can verify this?

[Cspr]

Looks like that's the way to do it. Thank you both of you.