Creating an Automation Excel Add-In

[MC]

For all newbies



http://msdn2.microsoft.com/en-us/library/ms173189

[Cuchulainn]

This C# code is a lot easier than the corresponding code in C++. In C++ more more plumbing is needed. In all fairness, once you get it working in C++ you know it for all time.

[zhouxing]

Here you can find a compilable example

[Cuchulainn]

Using basic Charts in Excel

[Cuchulainn]

Steps in getting contact with Excel from .NET C#



1. Create C# Shared Add in Project (under "Other Projects")

2. Right mouse click your project name

3. Choose Add Reference

4. Choose Mcrosoft Excel Library*** (compatible version)(from COM tab page!); click it

(RCW wrapper automagically created).

5. Look! It's in Solution Explorer

6. Test with some C# code I have provided



next step is to try with your own COM dll.

[tallent_e]

thank you for your very useful example codes.



i started a little project. roughly speaking i aim at automatically updating an Excel spreadsheet from data released weekly on the internet.



i first check whether or not my Excel file is up-to-date.



a regex extracts the date contained in the webpage that is the date of the latest update online. i thus come up with a string, right ? (and that might be my problem)



now, i need to check whether the corresponding date (in Excel dd/mm/yyyy date format) yet exists in the spreadsheet (more exactly, in the B column) .



what is smart way to cope with that ? i guess there is casting involved ?



thank you.

[tallent_e]

i think i can cope finding out support at http://www.dotnetperls.com/time

[Cuchulainn]

Example of interfacing databases and Excel.