Generate Excel spread sheet on client side?

[twelvecodespent]

I am looking to have my website generate a simple excel spread sheet on the client side when clicking a button. I don't know if it would be best to open the spread sheet on the client side and then write to it or create it on the server side and ask the user to save it locally. I've been looking around at possible ways to achieve this and none have worked so far. Any advise on how to achieve this would be much appreciated.


Currently I am trying to open the excel application on the client side and write to it, however it does not even open the application using the following code.

oXL = CreateObject("Excel.Application")
        oXL.Visible = True

Thanks.

 

[jmcilhinney]

This is not something you should do at the client. You should do it at the server and allow the user to download it. That said, installing Excel on a web server is not usually supported. In that case, just create a CSV and let the user open it in Excel and save it as an Excel workbook if desired.