The RATS Software Forum

Dear Tom,

I do want to load out-of-sample forecast generated by rats into our internal excel database.
However exporting the table with the forecast via report instruction creates an Excel file where the sheet name is 'sheet 1'.
Unfortunately this does not work with our database System, where aspecific sheet name is required.
Can I export a table via Report, copy or an other instruction, where i can define the sheet name?

Unfortunately this does not work:
report(action=show,format=xlsx,sheet=name1,unit=copy)


Thanks a lot

So a single sheet is OK, but you have to be able to control its name?

Yes thats right one sheet is sufficient. I just need to control the name.

I have an additional question. Is it possible to load all excel files from a specific folder? I want to collect different forecast from different rats programs in one single excel file.

Thanks a lot