export dataset to execl 2000
-
Hi, I searched the web. I can find how to export data for Excel 2002 or later. But how to do for Excel 2000 ? Thanks Wilson
Instead of trying to export to Excel, just export to a CSV (comma-separated values, or comma-delimited text file). Excel and other applications can open these with no problem. Just be sure to quote your strings that contain commas in them, which isn't hard and there are articles to assist you. To note, though, the typelib for Excel hasn't changed much since Excel 97. The base functionality is the same - as all good COM libs should. Chances are whatever works for Excel 2002 will work for Excel 2000, but you should use the Excel 2000 typelib for Excel 2000 and later since the class IDs and interface IDs (
GUIDs) should be the same throughout new versions (new interfaces are added and the old classes implement those, but the old interfaces are typically still implemented). Please note that this is usually the case, but things do get deprecated, though the functionality you require is pretty basic so you should be fine.Microsoft MVP, Visual C# My Articles