[dba-VS] automating Excel
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
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