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.

PB 11 - Excel SaveAs 65000 rows limitation

2 posts in DataWindow Last posting was on 2008-10-10 17:11:12.0Z
RMK.B Posted on 2008-10-10 14:21:30.0Z
Sender: 1a12.48ef63f9.1804289383@sybase.com
From: RMK.B
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: PB 11 - Excel SaveAs 65000 rows limitation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48ef64ea.1a36.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Oct 2008 07:21:30 -0700
X-Trace: forums-1-dub 1223648490 10.22.241.41 (10 Oct 2008 07:21:30 -0700)
X-Original-Trace: 10 Oct 2008 07:21:30 -0700, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87970
Article PK: 417227

Hi all,

I am PB Version 11.0 Build 6525.

I am having problem with datawindow saveas function for
excel8! filetype. I am using Microsoft Excel 2007 which
supports a maximum of 1048576 rows in a excel sheet. The
help for saveas function for excel filetype states excel8!
filetype will work for "Microsoft Excel Version 8 and higher
format". But, the datawindow saveas function for excel8!
filetype is not saving more than 65536 rows. (Also I have
tried Excel! filetype and Excel5! filetype of Saveas. But it
didn't work out)

My datawindow query is returning 212536 rows. When I try to
save the datawindow rows as excel8! type, "Save Rows As
Failed" error occurs. The saveas excel8! type is showing
error if the number of rows are greater than 65536.

I am using Microsoft office 2007, but the saveas function is
not working for Excel 2007 and shows error. I have tried the
same in design time also. The "Save Rows As" dialog shows
only "Excel8 (97 / 2000 / XP / 2003)" and "Excel8 (97 / 2000
/ XP / 2003) with headers" options. The Excel 2007 option is
not disaplayed. (Attached the "excel saveas dialog.zip which
has excel
saveas dialog.bmp file")

I want the datawindow saveas function to save rows as
Microsoft Excel 2007 file for more rows. (As per the help,
it should save the rows in latest excel version, for max of
1000000 rows).

Any solutions to resolve this. Any additional EBFs required.
Any
roundabouts. Any suggestion or feedback is appreciated.

TIA
Rammurali Krishnan B


Paul Horan[Sybase] Posted on 2008-10-10 17:11:12.0Z
From: "Paul Horan[Sybase]" <phoran_nospam@sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48ef64ea.1a36.1681692777@sybase.com>
Subject: Re: PB 11 - Excel SaveAs 65000 rows limitation
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ef8cb0@forums-1-dub>
Date: 10 Oct 2008 10:11:12 -0700
X-Trace: forums-1-dub 1223658672 10.22.241.152 (10 Oct 2008 10:11:12 -0700)
X-Original-Trace: 10 Oct 2008 10:11:12 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87972
Article PK: 417228

You can have Excel connect directly to your database via ODBC and pull the
data itself - there's no need to get PowerBuilder involved at all...

Paul Horan[Sybase]

<RMK.B> wrote in message news:48ef64ea.1a36.1681692777@sybase.com...
> Hi all,
>
> I am PB Version 11.0 Build 6525.
>
> I am having problem with datawindow saveas function for
> excel8! filetype. I am using Microsoft Excel 2007 which
> supports a maximum of 1048576 rows in a excel sheet. The
> help for saveas function for excel filetype states excel8!
> filetype will work for "Microsoft Excel Version 8 and higher
> format". But, the datawindow saveas function for excel8!
> filetype is not saving more than 65536 rows. (Also I have
> tried Excel! filetype and Excel5! filetype of Saveas. But it
> didn't work out)
>
> My datawindow query is returning 212536 rows. When I try to
> save the datawindow rows as excel8! type, "Save Rows As
> Failed" error occurs. The saveas excel8! type is showing
> error if the number of rows are greater than 65536.
>
> I am using Microsoft office 2007, but the saveas function is
> not working for Excel 2007 and shows error. I have tried the
> same in design time also. The "Save Rows As" dialog shows
> only "Excel8 (97 / 2000 / XP / 2003)" and "Excel8 (97 / 2000
> / XP / 2003) with headers" options. The Excel 2007 option is
> not disaplayed. (Attached the "excel saveas dialog.zip which
> has excel
> saveas dialog.bmp file")
>
> I want the datawindow saveas function to save rows as
> Microsoft Excel 2007 file for more rows. (As per the help,
> it should save the rows in latest excel version, for max of
> 1000000 rows).
>
> Any solutions to resolve this. Any additional EBFs required.
> Any
> roundabouts. Any suggestion or feedback is appreciated.
>
> TIA
> Rammurali Krishnan B