2 ms·
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/bb2266
by PeterHammar 18y ago
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 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.