Re: output file

[Isabelle BRUYERE <bruyere@xxxxxxxxxxxxxx>]

Thank you all for your help. I will try Michaël's solution.

Regards,

Isabelle


A 12:02 27/06/2003 -0500, Michaël Kummert a écrit :
> Isabelle BRUYERE wrote:
> > I would like to open my output file directly in Excel. I tried to give
> > a ".xls" extension to my output file names in type 25, but all outputs
> > of each timestep are written in the same cell. That doesn't really
> > help... Can anybody tell me what I'm doing wrong ?
>
> Dear Isabelle,
> Arie is right, you cannot create real Excel files from TRNSYS. However, 
> there is a way to create files that will open correctly in excel if you 
> double click on them for example:
> -Use Type25b
> -Set the last parameter (Output format "normal" or "SPREADSHEET") to 1
> -Choose a file name with an ".XLS" extension
>
> When you save the file from Excel, you will notice that it is a TAB 
> separated file and not a true excel file (but from there you can save it 
> as a "real" excel file)
>
> The files created that way will also open correctly if you use File/Open 
> from Excel.
>
> As Arie also mentioned, Excel locks the file when you open it so any 
> attempt to run TRNSYS will generate an error (although on my computer the 
> error is reasonably explicit, it says "write to read-only file blabla.xls")
>
> Regards,
>
> Michaël Kummert
>
> --
> _________________________________________________
>
> Michaël Kummert
>
> Solar Energy Laboratory - University of Wisconsin-Madison
> 1303 Engr Res Bldg, 1500 Engineering Drive
> Madison, WI 53706
>
> Tel: +1 (608) 263-1589
> Fax: +1 (608) 262-8464
> E-mail: kummert@engr.wisc.edu
>
> SEL Web Site: http://sel.me.wisc.edu
> TRNSYS Web Site: http://sel.me.wisc.edu/trnsys

Isabelle Bruyère
Université Catholique de Louvain
Unité d'architecture - Architecture et Climat
Place du Levant, 1 à 1348 Louvain-la-Neuve
Tél : 010/47 21 38 - Fax : 010/47 21 50