Skip to Content
0

excel compatibilty with pb 12.6?

Jan 18, 2017 at 06:31 PM

216

avatar image
Former Member

Hi,

I am using powerbuilder 12.6 and i am making an excel through pb 12.6.

It is getting saved within a minute with ms excel 2003 but it is taking so much time even more than 1 hour with ms excel version 2007,2010.

Any help will be appreciated.

Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Jan 23, 2017 at 05:59 AM
0

Any Suggetion?

Share
10 |10000 characters needed characters left characters exceeded
Dan Cooperstock Jan 31, 2017 at 10:56 PM
0

More details please - exactly HOW are you making that Excel file? Through OLE linking to its object model? Do you need that level of control, or might a simple export from a DW be sufficient?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 02, 2017 at 07:20 AM
0

OLE linking to its object model

Share
10 |10000 characters needed characters left characters exceeded
René Ullrich Feb 02, 2017 at 11:24 AM
0

I can't compare the two versions but I use Excel 2007 to export data using OLE.

Because I have to save a lot of data I tested different ways.

My final solution:

I copy data column by column, for each column multiple rows at one time. My largest block contains 512 rows. (I have tested with larger blocks but the performance became poorer.)

You need an array of type any with two dimensions.

Example for a block with 512 rows for column "A":

any la_9[512, 1]

aole_sheet.Range("A1:A512").FormulaR1C1 = la_9

I have different (la_0[1, 1], la_1[2, 1], la_2[4, 1], la_3[8, 1], ..., la_9[512, 1]) and I use the appropriate array to fill all it cells. If I have more then 512 rows it needs more calls to fill all the data of a row.

You may also try to fill rows and columns at one time. But you need a to know the array size at design time!

HTH,

René

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 02, 2017 at 03:12 PM
0

12.6 SaveAs supports the new format, why not use that?

Share
10 |10000 characters needed characters left characters exceeded