export to a specific row/cell

[mick_g]

can you export data to an excel sheet row or cell something like below

LIBNAME SDF "&sasdir";
PROC EXPORT DATA=SDF.ORDERS
FILE='c:\temp\demo.xlsb'
DBMS=EXCEL REPLACE;
SHEET='Orders';
Row = 10;
column =0;
RUN;

[Cynthia_sas]

Hi:
I believe this paper shows how to export to a "named range" using the LIBNAME engine:
http://www2.sas.com/proceedings/sugi31/024-31.pdf

cynthia

[AshokSas]

Hi Cynthia,

can you please give an example with creating a dummy sas dataset which should be exported to excel to particular mentioned row and column numbers under UNIX environment.

Ods tagsets excelxp is not working with start_at option. please help me out this is critical requirement for report creation.

Thanks,

Ashok