Last post Nov 30, 2009 08:35 AM by mudassarkhan
Nov 30, 2009 06:17 AM|sharadc|LINK
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...
dynamic rows and columns
Nov 30, 2009 08:20 AM|DarrellNorton|LINK
Try this code:
Nov 30, 2009 08:35 AM|mudassarkhan|LINK
check out this
another option read data in dataset and then export