05-16-2014 01:56 PM
hi i am new to sas,
basically i came to know that just like in hyperion you can use joole to format excelsheets
in sas you can use dde to go to cell level and format excel sheets.
basically what i want is to create fancy excel sheets with coloring, pasting data to specific cells, formatting, adding formulas, headers in excel via code.
can i do that using sas dde in sas enterprise guide 4.3.
05-16-2014 02:02 PM
Usually not, from what I understand, because its been turned off by default.
You should look into the Tagsets.ExcelXP destination though, it can do a lot of what you're looking to do already (minus the paste data to specific cells).