BookmarkSubscribeRSS Feed
hk2013
Fluorite | Level 6

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

6 REPLIES 6
Reeza
Super User

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
Fluorite | Level 6

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
Super User

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
Fluorite | Level 6

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
Super User

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
Obsidian | Level 7

(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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 7367 views
  • 0 likes
  • 3 in conversation