topic Re: Embed title in all sheets of excel ODS in SAS Enterprise Guide

Embed title in all sheets of excel ODS

hk2013 — Thu, 25 Jan 2018 19:10:09 GMT

I am trying to embed title in a excel sheet so when i open a new sheet i see the title.

Re: Embed title in all sheets of excel ODS

Reeza — Thu, 25 Jan 2018 20:29:50 GMT

And something you tried didn't work? Do you have a question of some sort?

@hk2013 wrote:

I am trying to embed title in a excel sheet so when i open a new sheet i see the title.

Re: Embed title in all sheets of excel ODS

againreddy — Thu, 25 Jan 2018 20:31:34 GMT

(EMBEDDED_TITLES= 'OFF' | 'ON')

specifies whether titles should appear in the worksheet.

ON

embed titles in the worksheet.

Alias

YES

OFF

do not embed titles in the worksheet.

Alias

Default	NO
Example	ods excel file='myxml.xlsx' options(embedded_titles='on');
Example	Customizing Your Excel Output

(EMBED_TITLES_ONCE= 'OFF' | 'ON')

specifies whether embedded titles should appear at the top of the worksheet only once.

ON

embedded titles appear only once at the top of the worksheet.

Alias

YES

OFF

titles appear as they normally appear.

Alias

Default	OFF
Example	ods excel options(embed_titles_once='on');
Example	Customizing Your Excel Output

Re: Embed title in all sheets of excel ODS

hk2013 — Thu, 25 Jan 2018 20:58:49 GMT

this is what i am doing but when the excel sheet opens up the title is there but when i open a new sheet in that workbook the title is not there

ods tagsets.ExcelXP options(
embedded_titles='yes'
embedded_footnotes='yes'
frozen_headers='4'
frozen_rowheaders='no'
sheet_name='NotonProblemlist'
sheet_interval='table'
autofit_height='yes'
absolute_column_width='25,25,25,25,25,25,25,25'
rowcolheadings='yes'
Pages_FitWidth = '1'
Pages_FitHeight='100'
FitToPage = 'yes'
ORIENTATION= 'LANDSCAPE'
);

Proc report data=Final(where=(trim(left(ID)) = trim(left(&ID)))) split='^' contents="" /*style=seaside*/;

TITLE1 JUSTIFY=left height=14pt color=white '';
TITLE2 JUSTIFY=left height=14pt COLOR=red bold "Title";
TITLE3 JUSTIFY=LEFT HEIGHT=12PT color=blue bold italic "Title2";
TITLE4 JUSTIFY=LEFT HEIGHT=12PT color=blue bold italic "title3";

Re: Embed title in all sheets of excel ODS

Reeza — Thu, 25 Jan 2018 21:02:47 GMT

but when i open a new sheet in that workbook the title is not there

How are you 'opening' a new sheet.

For clarification, your code indicates that you're using ODS TAGSETS.EXCELXP - not ODS EXCEL. There are some very big differences between the two, so please be as clear as possible in future question what methodology you're using.

Re: Embed title in all sheets of excel ODS

hk2013 — Thu, 25 Jan 2018 21:08:18 GMT

The excel file is being sent in a email and when i open that attachment and open a new sheet in that work book the title isnt there

Re: Embed title in all sheets of excel ODS

Reeza — Thu, 25 Jan 2018 21:11:13 GMT

Yeah, that's what I'd expect. A new sheet is created via Excel and it doesn't take over the other sheet settings. That's expected behaviour.

There's an option to REPEAT data in every page (see Excel) and that's probably what you want to use for this.