code need for extrating the data into an excel file

[vijayan veeraragavan]

hai,


i want to extract the data from the datagrid or custom table and copy as
excel file. how to do this using DDE ( Dynamic Data Exchange)

 

[Nicholas Paldino [.NET/C# MVP]]

vijayan,

Why do you need to do this using DDE? Quite honestly, I think it would
be near impossible to do this using DDE, as I don't know that the command
verbs are there.

I would use Excel automation to create the file. It should be pretty
easy too.

Just create your workbook and then copy the data out.

Hope this helps.

 

[Tarren]

Unless you need Macros, you could it through xml and push through xslt to
create an excel doc.

vijayan,

Why do you need to do this using DDE? Quite honestly, I think it would
be near impossible to do this using DDE, as I don't know that the command
verbs are there.

I would use Excel automation to create the file. It should be pretty
easy too.

Just create your workbook and then copy the data out.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

hai,


i want to extract the data from the datagrid or custom table and copy as
excel file. how to do this using DDE ( Dynamic Data Exchange)