Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Populating a spreadsheet via a com object

Populating a spreadsheet via a com object

Populating a spreadsheet via a com object

Hi chaps,

This is probably more of an excel / windows problem but somebody might have a suggestion.

We have a particular report which has to be formatted to look pretty fancy. To do this we populate a ready built excel spreadsheet via a com Object and using excel's API functions.

Ie. We will say in cell "A1" put "Title", in "A2" put "Main Report" etc till will populate every cell required.

Now this is all very fine until we come to the speed issue. When we put the program live it took twice as long as during testing. After extensive benchmarking it appears the speed for "POPULATING" the spreadsheet is linked to the printer you have set up as a default. It has nothing to do with spooling etc it's just the population of the spreadsheet. If I delete all printers from my PC the report is populated very quickly, the more "complex" a printer I add as a default the longer population takes.

I can only imagine that as I populate each cell excel is communicating with the default print driver to see how it is to be formatted or something like that.

Has anybody any idea how I can stop excel from interrogating the printer driver during population or indeed any idea as to exactly why the printer selection (even on a view only) directly affects the population speed?
We use progress 9.1d (A Gui 4GL SQL Language) on a mixture "NT" and "2000" platforms and use excel 2000.

Any suggestion will be much appreciated as I've hit a blank.

Thanks and Merry Xmas

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close