auto generate excel report

Question

The front end of our application is developed by .Net and C#. Currently the front -end can load data and analyze data to genetate well formatted report. Is it possible to resue the .Net code to auto generate daily excel report and save in some net drive? Thanks!

Sylwester · Answer

So you want to save data in XLS format? To do that in CSV format is pretty easy but XLS you have more work. You also can use Excel objects to works with excel cells directly. I'm corrently developed class to works with XLS ( www.madartsoft.com ).