export to Excel

[deleted_user]

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.

[deleted_user]

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.

[deleted_user]

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

[deleted_user]

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.