ODS Excel output from Row=2 and Column=2

R_Win — Mon, 03 May 2010 06:10:02 GMT

Hi
i am exporting output in ods excel i want the output to start from row=2 and column=2 how can i do it.

Re: ODS Excel output from Row=2 and Column=2

sbb — Mon, 03 May 2010 12:31:12 GMT

As a general guideline, you only need to post a given query in one forum.

Scott

Re: ODS Excel output from Row=2 and Column=2

Cynthia_sas — Mon, 03 May 2010 14:15:50 GMT

Hi:
Generally speaking, your ODS TAGSETS.EXCELXP or ODS HTML output (there is no ODS EXCEL destination) starts in the upper left-hand corner of the worksheet when the XML file or HTML file is opened in Excel. This means cell A1 or row1,col1.

If you have titles, procedure titles, and/or column headers, these report elements can all impact the starting row of the data. The starting column of data is usually COL A or COL 1.

You might be able to manipulate the data with some blank columns in your procedure of choice in order to shift the output to start in COL 2.

You also indicated that you were "exporting" -- this implies the use of PROC EXPORT and not ODS. I believe that PROC EXPORT output always starts in Row 1, Column A.

cynthia

topic Re: ODS Excel output from Row=2 and Column=2 in ODS and Base Reporting

ODS Excel output from Row=2 and Column=2

Re: ODS Excel output from Row=2 and Column=2

Re: ODS Excel output from Row=2 and Column=2