CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Lightbulb Performance optimization - while creating Excel reports

    Hi,

    Can anyone suggest me the proper approach for performance optimization while generating around 600 excel reports programatically.

    I am facing issues different issues like:
    -> Un ending loop.
    -> Code crash after generationg aroung 25 to 30 reports at a time.

    I am using Excel COM object to create excel report.

    thanx in advance for suggestions.

  2. #2
    Join Date
    Jun 2008
    Posts
    2,477

    Re: Performance optimization - while creating Excel reports

    A never ending loop is not a performance issue; it's a bug in your program.
    A crash is, again, not a performance issue; it's a bug in your program.

    These aren't random occurrences. Spend some time in the debugger, come back here, and then tell us

    1. What exception is being thrown?
    2. Under what circumstances do these problems occur?
    3. What have you already tried?

    Next step; show us your code so we don't have to guess at what the problem is.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured