Re: output file

[Michaël Kummert <kummert@xxxxxxxxxxxxx>]

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