topic export to Excel in SAS Enterprise Guide

export to Excel

deleted_user — Tue, 29 Jan 2008 07:50:15 GMT

Hi all
Can I export to Excel starting from a specific cell, not from A1 lets say from C3.
Is that possible? If yes How?

and can I export HTML reports to excel or it is only a feature for data sets

Thanks.

Re: export to Excel

deleted_user — Tue, 29 Jan 2008 12:34:00 GMT

Using the Libname engine it is certainly possible to define a range which includes the file, sheet and range values. Using the Microsoft Jet engine, which is EGs method of accessing Excel, I am not sure you can be quite as versatile.

However, when you are defining the Excel data source and have selected the file, it then prompts you for the sheet you require. If you define a "named range" within Excel, I believe it will populate with the sheet names in the data source definition process.

For help on named ranges, look up Excel Help, or go through the control bar for Insert / Name / Define.

Re: export to Excel

deleted_user — Wed, 30 Jan 2008 09:52:30 GMT

I think you are talking about Importing Excel
I'm askin about Exporting to Excel.

Re: export to Excel

deleted_user — Wed, 30 Jan 2008 11:07:09 GMT

No I'm not, the definition is very similar in both directions.

Try it and post any error messages here if it doesn't work.