Embed title in all sheets of excel ODS

[hk2013]

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

[Reeza]

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.

---

[hk2013]

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";

[Reeza]

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.

[hk2013]

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 

[Reeza]

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.

[againreddy]

(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

NO

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

NO

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