[dba-VS] automating Excel

Doug Murphy dw-murphy at cox.net
Mon Dec 14 10:35:11 CST 2015


You might query CodeProject. I have seen a number of C#/Excel articles
posted there.


-----Original Message-----
From: dba-VS [mailto:dba-vs-bounces at databaseadvisors.com] On Behalf Of John
Sent: Monday, December 14, 2015 6:22 AM
To: Development in Visual Studio
Subject: [dba-VS] automating Excel

I need to add some Excel automation to my C# application.

Currently I run a set of queries by hand, then take the resulting data sets,
insert sheets into workbooks, and insert the data into the sheets.  I have
to manually rename the pages to reflect the data set (geo location).  About
8 sheets total, and about three different workbooks. I then close the
workbook just created, attach to an email and email to my client.

I am looking for experience, code samples, web pages to read etc. Are any of
you folks doing this?

John W. Colby

dba-VS mailing list
dba-VS at databaseadvisors.com

More information about the dba-VS mailing list