Date: Fri, 20 Sep 2002 08:35:26 -0700
Reply-To: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject: Re: EXPORT Table viewer results to EXCEL
Content-Type: text/plain; charset=ISO-8859-1
firstname.lastname@example.org (A. Jarmak) wrote in message news:<email@example.com>...
> Hi everyone,
> I have an AF Application which is using the table viewer control.
> How I can create a pushbutton to export the results displayed in the
> table viewer into EXCEL?
> I know that can be done extra through coding (i.e DDE), but I would
> like to know if SAS v8 has a simplest way.
> I'm thinking about ODS , but I don't know how !!!.
> Thanks a lot,
> A. JARMAK
Try the _createHTML() method. Excel will read in an HTML table. It's
not native .xls, so very large tables will create very large .html.
You could implement your own method to attach to the data model to
create a native .xls using DDE.