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.

Datawindow SaveAs Excel - Not saving more than 65536 rows

7 posts in DataWindow Last posting was on 2008-06-21 17:53:12.0Z
RMK.B Posted on 2008-06-19 14:35:18.0Z
From: "RMK.B" <rammuralikrishnanb@zylog.co.in>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Datawindow SaveAs Excel - Not saving more than 65536 rows
Lines: 544
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485a6ea6@forums-1-dub>
Date: 19 Jun 2008 07:35:18 -0700
X-Trace: forums-1-dub 1213886118 10.22.241.152 (19 Jun 2008 07:35:18 -0700)
X-Original-Trace: 19 Jun 2008 07:35:18 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87211
Article PK: 416469

Hi all,

I am using PowerBuilder 10.2.0 Build 7516.

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


Roland Smith [TeamSybase] Posted on 2008-06-19 16:24:58.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <485a6ea6@forums-1-dub>
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485a885a$1@forums-1-dub>
Date: 19 Jun 2008 09:24:58 -0700
X-Trace: forums-1-dub 1213892698 10.22.241.152 (19 Jun 2008 09:24:58 -0700)
X-Original-Trace: 19 Jun 2008 09:24:58 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87214
Article PK: 416470

The code that allows the DataWindow to save in Excel file format is entirely
internal to the PB runtime .dlls. It doesn't matter which version of Excel
is installed.

Microsoft started using the year as part of the name beginning with 'Excel
for Windows 95'. Internally to the program it continues to have a version
number. Version 8 is Excel 97. Excel 2007 is version 12.

"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
news:485a6ea6@forums-1-dub...
> Hi all,
>
> I am using PowerBuilder 10.2.0 Build 7516.
>
> 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
>
>
>
>
>


Scott Morris Posted on 2008-06-19 15:16:39.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <485a6ea6@forums-1-dub>
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485a7857$1@forums-1-dub>
Date: 19 Jun 2008 08:16:39 -0700
X-Trace: forums-1-dub 1213888599 10.22.241.152 (19 Jun 2008 08:16:39 -0700)
X-Original-Trace: 19 Jun 2008 08:16:39 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87213
Article PK: 416471


> 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).

Per PB Help (10.2.1 9004), there is no discussion of row limits nor the
latest Excel version. The "8" in Excel8 doesn't refer to a specific version
of Excel. Given that the last 10.2 MR version was released in 2005, it
would be difficult for it to support any software / specification that came
afterwards.

The saveas type of Excel8 supports versions of Excel that are limited to
sheets of a maximum of 65k rows. As the saveas dialog indicates (though
online help doesn't), Excel8 is backwards compatible with Office97. There
is no specific type (as best I know) that supports the later versions of
Excel and their larger row limits. In short, you can't do what you want
with the version of PB you are using. You can try the latest version of PB
to see if there have been any enhancements in this area. Alternatively, use
any format that does not have this limit and which Excel can open. Other
alternatives have been suggested previously (e.g., using COM) - investigate
the newsgroup archives if you want more information.


Pat Madigan Posted on 2008-06-19 17:23:15.0Z
From: "Pat Madigan" <pmadigan_at_pccstructurals_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <485a6ea6@forums-1-dub>
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485a9603$1@forums-1-dub>
Date: 19 Jun 2008 10:23:15 -0700
X-Trace: forums-1-dub 1213896195 10.22.241.152 (19 Jun 2008 10:23:15 -0700)
X-Original-Trace: 19 Jun 2008 10:23:15 -0700, vip152.sybase.com
X-Authenticated-User: powerbuilder
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87215
Article PK: 416472

You could try using the OLE method of saving data to excel. I can't test
that for >65K rows, as I don't have Excel 2007, but I would think that would
work.

There's some examples of this on CodeExchange, and I prefer that over the
SaveAs.

Pat

"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
news:485a6ea6@forums-1-dub...
> Hi all,
>
> I am using PowerBuilder 10.2.0 Build 7516.
>
> 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
>
>
>
>
>


Ken Breneman Posted on 2008-06-21 05:48:15.0Z
Sender: 2890.485c8f7a.1804289383@sybase.com
From: Ken Breneman
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <485c961f.290f.1681692777@sybase.com>
References: <485a6ea6@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Jun 2008 22:48:15 -0700
X-Trace: forums-1-dub 1214027295 10.22.241.41 (20 Jun 2008 22:48:15 -0700)
X-Original-Trace: 20 Jun 2008 22:48:15 -0700, 10.22.241.41
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87228
Article PK: 416485

You could try using the CSV! format. Your Excel 2007
program can open csv files directly.

> Hi all,
>
> I am using PowerBuilder 10.2.0 Build 7516.
>
> 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
>
>
>
>
>
> [Attachment: excel saveas dialog.zip]


Wheeley Posted on 2008-06-21 06:34:13.0Z
From: Wheeley <wheeley@ix.netcom.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
Message-ID: <8s7p54p85fcs5bulp53ef4429f4bpsfi50@4ax.com>
References: <485a6ea6@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 Jun 2008 23:34:13 -0700
X-Trace: forums-1-dub 1214030053 10.22.241.152 (20 Jun 2008 23:34:13 -0700)
X-Original-Trace: 20 Jun 2008 23:34:13 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87229
Article PK: 416486

All current released versions of Powerbuilder nave no support for
Office 2007. I had this confirmed by Tech support when I was trying to
use an olecontrol with the .xlsm file type. Maybe 11.5 has support,
but Tech support said no support was to e found up through 11.2. I ask
when support would be added and they said they didn't know. So you are
going to have no way of doing what you want with Excel 2007 and
SaveAs.

Wheeley

On 19 Jun 2008 07:35:18 -0700, "RMK.B"

<rammuralikrishnanb@zylog.co.in> wrote:

>Hi all,
>
>I am using PowerBuilder 10.2.0 Build 7516.
>
>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)


Bruce Armstrong [TeamSybase] Posted on 2008-06-21 17:53:12.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Datawindow SaveAs Excel - Not saving more than 65536 rows
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <6ufq54d3m1ddrj739cfrm07knhfe2eqvsb@4ax.com>
References: <485a6ea6@forums-1-dub> <8s7p54p85fcs5bulp53ef4429f4bpsfi50@4ax.com>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 21 Jun 2008 10:53:12 -0700
X-Trace: forums-1-dub 1214070792 10.22.241.152 (21 Jun 2008 10:53:12 -0700)
X-Original-Trace: 21 Jun 2008 10:53:12 -0700, vip152.sybase.com
Lines: 35
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87230
Article PK: 416487

The SaveAs functionality of the DataWindow and support for Office 2007
file formats in OLE Controls are completely seperate features.

In any event, if you use OLE Automation to transfer the data over to
Excel, you are only limited by Excel's limits.

On 20 Jun 2008 23:34:13 -0700, Wheeley <wheeley@ix.netcom.com> wrote:

>All current released versions of Powerbuilder nave no support for
>Office 2007. I had this confirmed by Tech support when I was trying to
>use an olecontrol with the .xlsm file type. Maybe 11.5 has support,
>but Tech support said no support was to e found up through 11.2. I ask
>when support would be added and they said they didn't know. So you are
>going to have no way of doing what you want with Excel 2007 and
>SaveAs.
>
>Wheeley
>
>On 19 Jun 2008 07:35:18 -0700, "RMK.B"
><rammuralikrishnanb@zylog.co.in> wrote:
>
>>Hi all,
>>
>>I am using PowerBuilder 10.2.0 Build 7516.
>>
>>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)