Comment on Ask YC: Excel Generation (Server Side)?Comments−PeterHammar18yI've used 2 methods:1: SpreadsheetML: You can output XML which is understood by excel, here is an introduction: http://msdn.microsoft.com/en-us/library/bb226687(office.11).aspx2: Insert values into an existing template.xls which is accessed with sql using an Oledbconnection. The template can have existing charts which will get updated with the new values.
Comments
I've used 2 methods:
1: SpreadsheetML: You can output XML which is understood by excel, here is an introduction: http://msdn.microsoft.com/en-us/library/bb226687(office.11).aspx
2: Insert values into an existing template.xls which is accessed with sql using an Oledbconnection. The template can have existing charts which will get updated with the new values.