Dynamically generate EXCEL file RRS feed

  • Question

  • User-1587929738 posted

    Hi All,

    My requirement is kind of export to excel funtionality from a search page, where the number of columns and rows will be decided on the creteria selected by user. But the basic design of the excel is fixed..... so I was thinking if it is possible to have ready template where all the formatting thing can be predefined and at runtime I can just repeat the rows and coulmn with their respective cell values (If possible would like to add formulas also).

    The data has to be pulled from the database so I guess there is no luxury for me to generate excel direcly from DataGrid. But I am ready to try options using HTML/Data Grid/XML/EXCEL (If possible any other option without using Office library because it has lot of dependency on version etc.)

    Since the excel will be dynamically generated, immediate reponse is expected.

    Looking for your valuable suggestions...

    Monday, November 30, 2009 6:17 AM

All replies