Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Export Datawindow to XLSX

3 posts in DataWindow Last posting was on 2012-12-04 16:39:32Z
Kiran Chalapaka Posted on 2012-12-04 15:53:48Z
Sender: 1734.50be1a72.1804289383@sybase.com
From: Kiran Chalapaka
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Export Datawindow to XLSX
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50be1c8c.17e1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Dec 2012 07:53:48 -0800
X-Trace: forums-1-dub 1354636428 172.20.134.41 (4 Dec 2012 07:53:48 -0800)
X-Original-Trace: 4 Dec 2012 07:53:48 -0800, 172.20.134.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:94710
Article PK: 928235

Hi,

I have the following doubt for some time, can some please
clarify.

dw_control.saveas(filepath, Excel!) works without any
supporting files or platforms.
but for dw_control.saveas(filepath, XLSX!)to work we need
all of the below aspects.

1. .NET framework 3.0 or above should be installed in the
users machine
2. The dll PBDWExcel12Interop115.dll in the package.
3. The dll Sybase.PowerBuilder.DataWindow.Excel12.dll in
the GAC.

Is this correct?

Best regards,

Kiran


Chris Pollach Posted on 2012-12-04 15:58:05Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Export Datawindow to XLSX
References: <50be1c8c.17e1.1681692777@sybase.com>
In-Reply-To: <50be1c8c.17e1.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50be1d8d@forums-1-dub>
Date: 4 Dec 2012 07:58:05 -0800
X-Trace: forums-1-dub 1354636685 172.20.134.152 (4 Dec 2012 07:58:05 -0800)
X-Original-Trace: 4 Dec 2012 07:58:05 -0800, vip152.sybase.com
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:94711
Article PK: 928234

Hi Kiran;

For both SaveAs ( ) ... Excel8! or XLSX! you are correct.

--

Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com
TKD: http://www.syeoh.com

On 12/4/2012 10:53 AM, Kiran Chalapaka wrote:
> Hi,
>
> I have the following doubt for some time, can some please
> clarify.
>
> dw_control.saveas(filepath, Excel!) works without any
> supporting files or platforms.
> but for dw_control.saveas(filepath, XLSX!)to work we need
> all of the below aspects.
>
> 1. .NET framework 3.0 or above should be installed in the
> users machine
> 2. The dll PBDWExcel12Interop115.dll in the package.
> 3. The dll Sybase.PowerBuilder.DataWindow.Excel12.dll in
> the GAC.
>
> Is this correct?
>
> Best regards,
>
> Kiran
>


Kiran Chalapaka Posted on 2012-12-04 16:39:32Z
Sender: 1734.50be1a72.1804289383@sybase.com
From: Kiran Chalapaka
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Export Datawindow to XLSX
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50be2744.1a7f.1681692777@sybase.com>
References: <50be1d8d@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Dec 2012 08:39:32 -0800
X-Trace: forums-1-dub 1354639172 172.20.134.41 (4 Dec 2012 08:39:32 -0800)
X-Original-Trace: 4 Dec 2012 08:39:32 -0800, 172.20.134.41
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:94712
Article PK: 928236

Hi Chris,

Thanks for clarifying.
And this is not the first time that I got some
useful info. from you :-).

Regards,

Kiran.

> Hi Kiran;
>
> For both SaveAs ( ) ... Excel8! or XLSX! you are
> correct.
>
> --
>
> Regards ... Chris
> President: OSUG / STD Inc.
> Vice President: ISUG
> Blog: http://chrispollach.blogspot.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
> PBDJ: http://chrispollach.sys-con.com
> TKD: http://www.syeoh.com
>
>
>
>
>
> On 12/4/2012 10:53 AM, Kiran Chalapaka wrote:
> > Hi,
> >
> > I have the following doubt for some time, can some
> > please clarify.
> >
> > dw_control.saveas(filepath, Excel!) works without any
> > supporting files or platforms.
> > but for dw_control.saveas(filepath, XLSX!)to work we
> > need all of the below aspects.
> >
> > 1. .NET framework 3.0 or above should be installed in
> > the users machine
> > 2. The dll PBDWExcel12Interop115.dll in the package.
> > 3. The dll
> > Sybase.PowerBuilder.DataWindow.Excel12.dll in the GAC.
> >
> > Is this correct?
> >
> > Best regards,
> >
> > Kiran
> >
>