ODS Excel control row after embedding image using proc gslide

[SuryaKiran]

Hi,

ODS Excel is becoming more commonly used destination for generating native XLSX file. Although there are some bugs, SAS team is working to improve its advantages. I was able to successfully embed image  into a sheet before my report. But I was not able to control the space between my image and report. absolute_row_height is applied after the image and not from starting row.

proc template; 
define style styles.background_logo;
parent=styles.Excel;
style header/ 
	fontsize=11pt
	backgroundcolor=cornflowerblue;
end;
run;

title;
footnote;
ods _all_ close;
goptions device=actximg;
ods excel file=xl_out;
ods excel options (	sheet_interval='none' 
					sheet_name="Cover Sheet" 
					start_at="2,2" 
) style=background_logo;

goptions iback="/usr/asmile.jpg"  vsize=2in hsize=2in;	;
proc gslide border;
run;
proc print data=sashelp.class;
run;
ods excel close;

I also tried couple of other options mentioned here Tips for Using the ODS Excel Destination, but this servers me well for my report except that space between.

 Using SAS 9.4 M4

[SuryaKiran]

@Cynthia_sas, I know your good at these, any help is appreciated. 

[Cynthia_sas]

Hi: I'm not sure the GSLIDE approach will give you the control you want. Take a look at this paper https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf at the approach that starts on page 3. There is a macro program that the paper author is using that allows you to post-process the XLSX file and insert images into specific locations. That might give you the type of control you're looking for. Otherwise, I'd recommend opening a track with Tech Support.

Cynthia

[SuryaKiran]

Thanks, Unfortunately that approach will not work for me since I'm on Linux operating system and can't run x-commands or VB Script. I will open track with SAS Tech support and see what I come up with. 

[SuryaKiran · Accepted solution]

I opened track with SAS Technical Support and got response on this. Unfortunately this did not have solution for the current versions of SAS and hope it will be fixed in future releases.