Export dataset to a specified range of cell of an existing excel spreadsheet

[akarki001]

I am trying to find the solution to export dataset to a specified range of cell of an existing excel spreadsheet? Please help me if there is any option in proc export or other ods?

[SASKiwi]

PROC EXPORT supports this but only if you use DBMS EXCEL or EXCELCS.

[akarki001]

Hi SASKiwi,
Thank you so much. would you mind to explain little bit more how i can i add those in following code please:
PROC EXPORT DATA=DATA
outfile="C:\test.xlsx"
DBMS=xlsx replace label;
sheet=sheet1;
run;
I need to populate my output C6:V10 only output numbers keeping heading fix and rows are fixed. I mean I have 6 by 20 matrix in existing sheet, just want to fix 1st row (heading) and 1st column (Name) fixed. Thank you so much for your help.

[Sajid01]

Hello @akarki001 
Please have a look at the following.
https://communities.sas.com/t5/General-SAS-Programming/Exporting-SAS-dataset-into-specific-cells/td-...

https://stats.idre.ucla.edu/sas/faq/how-can-i-send-sas-dataresults-to-specific-cells-in-an-excel-spr...

[akarki001]

Hi Sajid01,
I have gone through it earlier. Would you mind to elaborate how does it works please. Thank you.

[Sajid01]

The basic requirement is that you should have SAS and Excel installed on the same machine and of course WIndows OS.
Though SAS these days does not recommend it, this is the only direct option you have as I know of. The following SAS reference has good examples. Do read this, if you have not read already done so. (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p0rbba3syo5gf1n1gf17jd7zzhwq.htm) 
This another good reference ( https://www.lexjansen.com/nesug/nesug05/pos/pos15.pdf   ) .

The instructions are pretty clear. 
In case you have an error please post the logs.