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 more than 65535 rows

4 posts in DataWindow Last posting was on 2008-08-22 15:22:41.0Z
Krishna Posted on 2008-08-19 07:00:15.0Z
From: Krishna <krishnagceb@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Export more than 65535 rows
Date: Tue, 19 Aug 2008 00:00:15 -0700 (PDT)
Organization: http://groups.google.com
Lines: 11
Message-ID: <fb630fd5-6220-443c-a4bf-61319c4cdc89@r15g2000prd.googlegroups.com>
NNTP-Posting-Host: 203.99.197.2
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1219129215 26953 127.0.0.1 (19 Aug 2008 07:00:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 19 Aug 2008 07:00:15 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r15g2000prd.googlegroups.com; posting-host=203.99.197.2; posting-account=EF9J0ggAAACXSpNuXlvbh_TAlnuMHfS8
User-Agent: G2/1.0
X-HTTP-Via: 1.0 CTSINNVLSISA, 1.1 CTSINTDLSISB
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r15g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87583
Article PK: 416841

Hi,

I need to export more than 65535 rows, but have the extra rows as
another sheet in the same Excel File.

How am I to do that?

Please advise. Thanks in advance

Regards,
Krishna.


Bruce Armstrong [TeamSybase] Posted on 2008-08-19 15:01:45.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <fb630fd5-6220-443c-a4bf-61319c4cdc89@r15g2000prd.googlegroups.com>
Subject: Re: Export more than 65535 rows
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48aae059$1@forums-1-dub>
Date: 19 Aug 2008 08:01:45 -0700
X-Trace: forums-1-dub 1219158105 10.22.241.152 (19 Aug 2008 08:01:45 -0700)
X-Original-Trace: 19 Aug 2008 08:01:45 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87592
Article PK: 416847

Use OLE Automation rather than attempting a SaveAs

"Krishna" <krishnagceb@gmail.com> wrote in message
news:fb630fd5-6220-443c-a4bf-61319c4cdc89@r15g2000prd.googlegroups.com...
> Hi,
>
> I need to export more than 65535 rows, but have the extra rows as
> another sheet in the same Excel File.
>
> How am I to do that?
>
> Please advise. Thanks in advance
>
> Regards,
> Krishna.


Krishna Posted on 2008-08-22 06:55:54.0Z
From: Krishna <krishnagceb@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Export more than 65535 rows
Date: Thu, 21 Aug 2008 23:55:54 -0700 (PDT)
Organization: http://groups.google.com
Lines: 15
Message-ID: <4dac261a-c686-4052-92d3-a59f6989f07b@z72g2000hsb.googlegroups.com>
References: <fb630fd5-6220-443c-a4bf-61319c4cdc89@r15g2000prd.googlegroups.com> <48aae059$1@forums-1-dub>
NNTP-Posting-Host: 203.99.195.98
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1219388154 6020 127.0.0.1 (22 Aug 2008 06:55:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 22 Aug 2008 06:55:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z72g2000hsb.googlegroups.com; posting-host=203.99.195.98; posting-account=EF9J0ggAAACXSpNuXlvbh_TAlnuMHfS8
User-Agent: G2/1.0
X-HTTP-Via: 1.0 CTSINNVLSISA, 1.1 CTSINTCOISA9
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z72g2000hsb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87612
Article PK: 416868

Hi,

I am using OLE automation only.
I have 65532 rows to save, which we refer as a page size. There are 4
header rows.
So, a total of 65536 rows are available.
First the data is saved and then the header is inserted, where exactly
I get the error.
I am able 2 understand the error is due to the exceeding of the
maximum number of rows in a worksheet.
But am not able 2 fix this problem.
Please help.

Regards,
Krishna.


Bruce Armstrong [TeamSybase] Posted on 2008-08-22 15:22:41.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <fb630fd5-6220-443c-a4bf-61319c4cdc89@r15g2000prd.googlegroups.com> <48aae059$1@forums-1-dub> <4dac261a-c686-4052-92d3-a59f6989f07b@z72g2000hsb.googlegroups.com>
Subject: Re: Export more than 65535 rows
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48aed9c1$1@forums-1-dub>
Date: 22 Aug 2008 08:22:41 -0700
X-Trace: forums-1-dub 1219418561 10.22.241.152 (22 Aug 2008 08:22:41 -0700)
X-Original-Trace: 22 Aug 2008 08:22:41 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87614
Article PK: 416872

Are you using Excel 2007? If not, then you can't save that many rows no
matter what.

If you are using Excel 2007, then there's something wrong with your code.

"Krishna" <krishnagceb@gmail.com> wrote in message
news:4dac261a-c686-4052-92d3-a59f6989f07b@z72g2000hsb.googlegroups.com...
> Hi,
>
> I am using OLE automation only.
> I have 65532 rows to save, which we refer as a page size. There are 4
> header rows.
> So, a total of 65536 rows are available.
> First the data is saved and then the header is inserted, where exactly
> I get the error.
> I am able 2 understand the error is due to the exceeding of the
> maximum number of rows in a worksheet.
> But am not able 2 fix this problem.
> Please help.
>
> Regards,
> Krishna.