Skip to Content
avatar image
Former Member

excel compatibilty with pb 12.6?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

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

    Any Suggetion?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 10:56 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 07:20 AM

    OLE linking to its object model

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2017 at 11:24 AM

    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é

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 03:12 PM

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

    Add comment
    10|10000 characters needed characters exceeded