[dba-VS] automating Excel

[Doug Murphy]

John,

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

Doug

-----Original Message-----
From: dba-VS [mailto:dba-vs-bounces at databaseadvisors.com] On Behalf Of John
Colby
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
http://databaseadvisors.com/mailman/listinfo/dba-vs
http://www.databaseadvisors.com