Desktop productivity for business analysts and programmers

Embed title in all sheets of excel ODS

Reply
Contributor
Posts: 30

Embed title in all sheets of excel ODS

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

Super User
Posts: 22,873

Re: Embed title in all sheets of excel ODS

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.


 

Contributor
Posts: 30

Re: Embed title in all sheets of excel ODS

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

Super User
Posts: 22,873

Re: Embed title in all sheets of excel ODS

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.

Contributor
Posts: 30

Re: Embed title in all sheets of excel ODS

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 

Super User
Posts: 22,873

Re: Embed title in all sheets of excel ODS

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.

 

Contributor
Posts: 30

Re: Embed title in all sheets of excel ODS

(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');
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');
Customizing Your Excel Output
Ask a Question
Discussion stats
  • 6 replies
  • 154 views
  • 0 likes
  • 3 in conversation