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.

Problems to generate Excel in PB9

10 posts in Objects Last posting was on 2004-09-21 22:53:17.0Z
Mano Bill Posted on 2004-01-29 17:34:07.0Z
From: "Mano Bill" <manobill@peganing.com.br>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Problems to generate Excel in PB9
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
Message-ID: <40194671@forums-2-dub>
X-Original-Trace: 29 Jan 2004 09:44:17 -0800, 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Jan 2004 09:17:26 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Jan 2004 09:34:07 -0800
X-Trace: forums-1-dub 1075397647 10.22.108.75 (29 Jan 2004 09:34:07 -0800)
X-Original-Trace: 29 Jan 2004 09:34:07 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7767
Article PK: 735041

/* Using PB9, Build 6053 */

Hi all,

I have a problem to generate big Excel files, and I'd like to ask if someone
knows how to solve it. I need to generate an Excel spreadsheet in a PB
window. Right now, I'm using an OLE object to generate it. For small reports
it's fine, 'cos generates all content fast and fine.

The problem is that I need to generate a formatted Excel with 50 columns and
more than 3000 rows. When I try it, system takes 15 minutes to generate the
report (I'm testing it in a Pentium 4 1.3GHz Dual-Processor), and it allocs
tons of memory. Someone knows a better (and faster) way to generate an Excel
file via PB9???

Thanks in advance,
Mano Bill


Sanjiv Das [TeamSybase] Posted on 2004-01-30 06:09:58.0Z
From: "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ip68-4-216-144.oc.oc.cox.net
X-Original-NNTP-Posting-Host: ip68-4-216-144.oc.oc.cox.net
Message-ID: <4019f536$1@forums-1-dub>
Date: 29 Jan 2004 22:09:58 -0800
X-Trace: forums-1-dub 1075442998 68.4.216.144 (29 Jan 2004 22:09:58 -0800)
X-Original-Trace: 29 Jan 2004 22:09:58 -0800, ip68-4-216-144.oc.oc.cox.net
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7769
Article PK: 735042

Have you tried loading the data into a DW, then invoking the SaveAs ( )
method, setting the SaveAsType to Excel5! ?

Sanjiv.

"Mano Bill" <manobill@peganing.com.br> wrote in message
news:40194671@forums-2-dub...
> /* Using PB9, Build 6053 */
>
> Hi all,
>
> I have a problem to generate big Excel files, and I'd like to ask if
someone
> knows how to solve it. I need to generate an Excel spreadsheet in a PB
> window. Right now, I'm using an OLE object to generate it. For small
reports
> it's fine, 'cos generates all content fast and fine.
>
> The problem is that I need to generate a formatted Excel with 50 columns
and
> more than 3000 rows. When I try it, system takes 15 minutes to generate
the
> report (I'm testing it in a Pentium 4 1.3GHz Dual-Processor), and it
allocs
> tons of memory. Someone knows a better (and faster) way to generate an
Excel
> file via PB9???
>
> Thanks in advance,
> Mano Bill
>
>


Mano Bill Posted on 2004-02-02 16:49:09.0Z
From: "Mano Bill" <manobill@peganing.com.br>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub> <4019f536$1@forums-1-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
Message-ID: <401e81f4@forums-2-dub>
X-Original-Trace: 2 Feb 2004 08:59:32 -0800, 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Feb 2004 08:32:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Feb 2004 08:49:09 -0800
X-Trace: forums-1-dub 1075740549 10.22.108.75 (2 Feb 2004 08:49:09 -0800)
X-Original-Trace: 2 Feb 2004 08:49:09 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7772
Article PK: 735047

Yes! But the problem with this option is that I can't work with Excel
formulas, and I need to format the whole report as well... But I'm testing
the PBD sent by Phillip Salgannik, and it's working for now. I'll just do
more tests related, but it looks like a good thing to generate reports.

Thanks for all your help!!
Mano Bill

"Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
message news:4019f536$1@forums-1-dub...
> Have you tried loading the data into a DW, then invoking the SaveAs ( )
> method, setting the SaveAsType to Excel5! ?
>
> Sanjiv.


Sanjiv Das [TeamSybase] Posted on 2004-02-14 02:51:15.0Z
From: "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub> <4019f536$1@forums-1-dub> <401e81f4@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ip68-4-216-144.oc.oc.cox.net
Message-ID: <402d8fb8@forums-2-dub>
X-Original-Trace: 13 Feb 2004 19:02:16 -0800, ip68-4-216-144.oc.oc.cox.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Feb 2004 18:32:59 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Feb 2004 18:51:15 -0800
X-Trace: forums-1-dub 1076727075 10.22.108.75 (13 Feb 2004 18:51:15 -0800)
X-Original-Trace: 13 Feb 2004 18:51:15 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7796
Article PK: 735072

Glad that's working for you.

If you want to experiment with different methods, you could also probably
try to save the data to a CSV file, then importing that into Excel through
OLE commands.

Sanjiv.

"Mano Bill" <manobill@peganing.com.br> wrote in message
news:401e81f4@forums-2-dub...
> Yes! But the problem with this option is that I can't work with Excel
> formulas, and I need to format the whole report as well... But I'm testing
> the PBD sent by Phillip Salgannik, and it's working for now. I'll just do
> more tests related, but it looks like a good thing to generate reports.
>
> Thanks for all your help!!
> Mano Bill
>
> "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
> message news:4019f536$1@forums-1-dub...
> > Have you tried loading the data into a DW, then invoking the SaveAs ( )
> > method, setting the SaveAsType to Excel5! ?
> >
> > Sanjiv.
>
>


Mano Bill Posted on 2004-02-17 15:24:46.0Z
From: "Mano Bill" <manobill@peganing.com.br>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub> <4019f536$1@forums-1-dub> <401e81f4@forums-2-dub> <402d8fb8@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
Message-ID: <403234e3@forums-2-dub>
X-Original-Trace: 17 Feb 2004 07:36:03 -0800, 200-102-085-209.nhoce7002.dsl.brasiltelecom.net.br
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2004 07:06:14 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2004 07:24:46 -0800
X-Trace: forums-1-dub 1077031486 10.22.108.75 (17 Feb 2004 07:24:46 -0800)
X-Original-Trace: 17 Feb 2004 07:24:46 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7799
Article PK: 735073

That's great! But how can I import a CSV file into Excel through OLE? Do you
have any examples?

Thanks for your great help!!!
Mano Bill

"Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
message news:402d8fb8@forums-2-dub...
> Glad that's working for you.
>
> If you want to experiment with different methods, you could also probably
> try to save the data to a CSV file, then importing that into Excel through
> OLE commands.
>
> Sanjiv.
>
>
>
> "Mano Bill" <manobill@peganing.com.br> wrote in message
> news:401e81f4@forums-2-dub...
> > Yes! But the problem with this option is that I can't work with Excel
> > formulas, and I need to format the whole report as well... But I'm
testing
> > the PBD sent by Phillip Salgannik, and it's working for now. I'll just
do
> > more tests related, but it looks like a good thing to generate reports.
> >
> > Thanks for all your help!!
> > Mano Bill
> >
> > "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
> > message news:4019f536$1@forums-1-dub...
> > > Have you tried loading the data into a DW, then invoking the SaveAs
( )
> > > method, setting the SaveAsType to Excel5! ?
> > >
> > > Sanjiv.
> >
> >
>
>


Bruce Armstrong [TeamSybase] Posted on 2004-02-17 18:45:49.0Z
Message-ID: <40325D01.278C22B4@teamsybase.com>
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Organization: TeamSybase
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD Boeing Kit (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Problems to generate Excel in PB9
References: <40194671@forums-2-dub> <4019f536$1@forums-1-dub> <401e81f4@forums-2-dub> <402d8fb8@forums-2-dub> <403234e3@forums-2-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 141.102.124.34
X-Original-Trace: 17 Feb 2004 10:57:06 -0800, 141.102.124.34
Lines: 69
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2004 10:27:15 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2004 10:45:49 -0800
X-Trace: forums-1-dub 1077043549 10.22.108.75 (17 Feb 2004 10:45:49 -0800)
X-Original-Trace: 17 Feb 2004 10:45:49 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7801
Article PK: 735075

I use the following in one of my apps for an Excel file, you would just
change the filter on the GetFileOpenName to show CSV instead.

string ls_pathname, ls_filename
long ll_rc
oleobject loo_excel

IF GetFileOpenName ( "Open File", ls_pathname, ls_filename, "XLS",
"Excel Files (*.xls),*.xls" ) < 1 THEN Return

loo_excel = CREATE OLEObject
loo_excel.ConnectToNewObject( "excel.application" )
loo_excel.visible = false
loo_excel.workbooks.open( ls_pathname )
loo_excel.ActiveCell.CurrentRegion.Select
loo_excel.Selection.Copy()
ll_rc = dw_1.ImportClipBoard ( 2 )
ClipBoard('')
loo_excel.workbooks.close()
loo_excel.disconnectobject()
DESTROY loo_excel

st_1.Text = String ( dw_1.RowCount() ) + ' records ready to import.'
cb_2.enabled = TRUE

Mano Bill wrote:
>
> That's great! But how can I import a CSV file into Excel through OLE? Do you
> have any examples?
>
> Thanks for your great help!!!
> Mano Bill
>
> "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
> message news:402d8fb8@forums-2-dub...
> > Glad that's working for you.
> >
> > If you want to experiment with different methods, you could also probably
> > try to save the data to a CSV file, then importing that into Excel through
> > OLE commands.
> >
> > Sanjiv.
> >
> >
> >
> > "Mano Bill" <manobill@peganing.com.br> wrote in message
> > news:401e81f4@forums-2-dub...
> > > Yes! But the problem with this option is that I can't work with Excel
> > > formulas, and I need to format the whole report as well... But I'm
> testing
> > > the PBD sent by Phillip Salgannik, and it's working for now. I'll just
> do
> > > more tests related, but it looks like a good thing to generate reports.
> > >
> > > Thanks for all your help!!
> > > Mano Bill
> > >
> > > "Sanjiv Das [TeamSybase]" <No-Spam-SDas_TeamSybase@HotMail.Com> wrote in
> > > message news:4019f536$1@forums-1-dub...
> > > > Have you tried loading the data into a DW, then invoking the SaveAs
> ( )
> > > > method, setting the SaveAsType to Excel5! ?
> > > >
> > > > Sanjiv.
> > >
> > >
> >
> >


Philip Salgannik Posted on 2004-01-29 18:17:09.0Z
Sender: 5e8c.40194dc0.1804289383@sybase.com
From: Philip Salgannik
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Problems to generate Excel in PB9
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40194e25.5e8f.846930886@sybase.com>
References: <40194671@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Jan 2004 10:17:09 -0800
X-Trace: forums-1-dub 1075400229 10.22.241.41 (29 Jan 2004 10:17:09 -0800)
X-Original-Trace: 29 Jan 2004 10:17:09 -0800, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7768
Article PK: 735045

http://www.desta.com.ua/dw2xls/index.html

> /* Using PB9, Build 6053 */
>
> Hi all,
>
> I have a problem to generate big Excel files,


Anselmo Garcia Posted on 2004-09-20 22:28:51.0Z
From: "Anselmo Garcia" <agarcia@innova.com.mx>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: server.innova.com.mx
Message-ID: <414f5b71$1@forums-2-dub>
X-Original-Trace: 20 Sep 2004 15:36:33 -0700, server.innova.com.mx
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Sep 2004 15:16:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Sep 2004 15:28:51 -0700
X-Trace: forums-1-dub 1095719331 10.22.108.75 (20 Sep 2004 15:28:51 -0700)
X-Original-Trace: 20 Sep 2004 15:28:51 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8014
Article PK: 735285

hello Mano...

I will know how do you create excel file because when I save datawindows
with sentence "saveas", in the excel file the information is strange.

please tell to me how!!!

this is my email: agarcia@innova.com.mx

"Mano Bill" <manobill@peganing.com.br> wrote in message
news:40194671@forums-2-dub...
> /* Using PB9, Build 6053 */
>
> Hi all,
>
> I have a problem to generate big Excel files, and I'd like to ask if
someone
> knows how to solve it. I need to generate an Excel spreadsheet in a PB
> window. Right now, I'm using an OLE object to generate it. For small
reports
> it's fine, 'cos generates all content fast and fine.
>
> The problem is that I need to generate a formatted Excel with 50 columns
and
> more than 3000 rows. When I try it, system takes 15 minutes to generate
the
> report (I'm testing it in a Pentium 4 1.3GHz Dual-Processor), and it
allocs
> tons of memory. Someone knows a better (and faster) way to generate an
Excel
> file via PB9???
>
> Thanks in advance,
> Mano Bill
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004


Chris Pollach Posted on 2004-09-21 14:12:33.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub> <414f5b71$1@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 51
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: firewall.scc-csc.gc.ca
Message-ID: <415038a1$1@forums-2-dub>
X-Original-Trace: 21 Sep 2004 07:20:17 -0700, firewall.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Sep 2004 06:59:50 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Sep 2004 07:12:33 -0700
X-Trace: forums-1-dub 1095775953 10.22.108.75 (21 Sep 2004 07:12:33 -0700)
X-Original-Trace: 21 Sep 2004 07:12:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8018
Article PK: 735287

You could probably use PB 10 where you now have other Excel SaveAs options!

"Anselmo Garcia" <agarcia@innova.com.mx> wrote in message
news:414f5b71$1@forums-2-dub...
> hello Mano...
>
> I will know how do you create excel file because when I save datawindows
> with sentence "saveas", in the excel file the information is strange.
>
> please tell to me how!!!
>
> this is my email: agarcia@innova.com.mx
>
> "Mano Bill" <manobill@peganing.com.br> wrote in message
> news:40194671@forums-2-dub...
> > /* Using PB9, Build 6053 */
> >
> > Hi all,
> >
> > I have a problem to generate big Excel files, and I'd like to ask if
> someone
> > knows how to solve it. I need to generate an Excel spreadsheet in a PB
> > window. Right now, I'm using an OLE object to generate it. For small
> reports
> > it's fine, 'cos generates all content fast and fine.
> >
> > The problem is that I need to generate a formatted Excel with 50 columns
> and
> > more than 3000 rows. When I try it, system takes 15 minutes to generate
> the
> > report (I'm testing it in a Pentium 4 1.3GHz Dual-Processor), and it
> allocs
> > tons of memory. Someone knows a better (and faster) way to generate an
> Excel
> > file via PB9???
> >
> > Thanks in advance,
> > Mano Bill
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004
>
>


Anselmo Garcia Posted on 2004-09-21 22:53:17.0Z
From: "Anselmo Garcia" <agarcia@innova.com.mx>
Newsgroups: sybase.public.powerbuilder.objects
References: <40194671@forums-2-dub> <414f5b71$1@forums-2-dub> <415038a1$1@forums-2-dub>
Subject: Re: Problems to generate Excel in PB9
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: server.innova.com.mx
Message-ID: <4150b2ad$1@forums-2-dub>
X-Original-Trace: 21 Sep 2004 16:01:01 -0700, server.innova.com.mx
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Sep 2004 15:40:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Sep 2004 15:53:17 -0700
X-Trace: forums-1-dub 1095807197 10.22.108.75 (21 Sep 2004 15:53:17 -0700)
X-Original-Trace: 21 Sep 2004 15:53:17 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8019
Article PK: 735286

Chris I'm using PB9, and I 'm working with compositive datawindows...

What do you think Chris I can do??

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:415038a1$1@forums-2-dub...
> You could probably use PB 10 where you now have other Excel SaveAs
options!
>
>
> "Anselmo Garcia" <agarcia@innova.com.mx> wrote in message
> news:414f5b71$1@forums-2-dub...
> > hello Mano...
> >
> > I will know how do you create excel file because when I save datawindows
> > with sentence "saveas", in the excel file the information is strange.
> >
> > please tell to me how!!!
> >
> > this is my email: agarcia@innova.com.mx
> >
> > "Mano Bill" <manobill@peganing.com.br> wrote in message
> > news:40194671@forums-2-dub...
> > > /* Using PB9, Build 6053 */
> > >
> > > Hi all,
> > >
> > > I have a problem to generate big Excel files, and I'd like to ask if
> > someone
> > > knows how to solve it. I need to generate an Excel spreadsheet in a PB
> > > window. Right now, I'm using an OLE object to generate it. For small
> > reports
> > > it's fine, 'cos generates all content fast and fine.
> > >
> > > The problem is that I need to generate a formatted Excel with 50
columns
> > and
> > > more than 3000 rows. When I try it, system takes 15 minutes to
generate
> > the
> > > report (I'm testing it in a Pentium 4 1.3GHz Dual-Processor), and it
> > allocs
> > > tons of memory. Someone knows a better (and faster) way to generate an
> > Excel
> > > file via PB9???
> > >
> > > Thanks in advance,
> > > Mano Bill
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004
> >
> >
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004