Hello,
I need to store large number of data in excel sheet so that my clients can view thid data in excel sheet, as the showing this data i.e. almost 15000 rows in the grid is highly impossible, also lot of memory will be consume by this on server. Hnec my approach toward this issue is to save this data directly in the excel template and then either display it or whatever client will choose.
First question - Is it possible to generate EXCEL sheet (in a specific column format) from DataSet at runtime?
2) How this process should run faster as lot of data will be fetched by the user?
Regards,
Abhijeet
...
Go to the complete details ...