CodeSmith Community
Your Code. Your Way. Faster!

Export to Excel

Latest post 08-18-2007 6:15 PM by mike123. 2 replies.
  • 08-15-2007 4:28 PM

    Export to Excel

    Hi there. Is there a way to control which columns get exported?

    I have a entitygrid with some columns displayed but wish to export the all the columns in the database. I don't want to display all however?

     

    Thanks

    Matt

    • Post Points: 65
  • 08-16-2007 11:04 AM In reply to

    • basolutions
    • Top 100 Contributor
    • Joined on 03-21-2007
    • Denver, CO
    • Posts 51
    • Points 1,175

    Re: Export to Excel

    The export looks at the rendered grid for its output.  You may need to try to bind another grid with all of the columns you want and export from that one.  I would try intercepting the export event, load a grid in memory with the columns you want, and export from it.  I haven't tried this myself, but if the in memory effort doesn't work, then I would try opening a popup window with the same grid.

     HTH,

    Jesse

    • Post Points: 5
  • 08-18-2007 6:15 PM In reply to

    • mike123
    • Top 10 Contributor
    • Joined on 02-25-2005
    • Toronto, Ontario
    • Posts 734
    • Points 17,040

    Re: Export to Excel

    You could export additional columns via ExcelColumns template, take a look here for more info: http://community.codesmithtools.com/forums/p/6420/26084.aspx

    Mike Shatny
    --------------------------------------------------------------
    Member of the .netTiers team http://www.nettiers.com
    --------------------------------------------------------------

    Filed under:
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems