mars 26

On the personal VSTO project I currently work on, I was first working on sheets I had added at design time. I was thinking it would be simpler to be able to generate the worksheets at runtime depending of my needs.

To add a sheet, we can just do something like :

Globals.ThisWorkbook.Worksheets.Add(System.Type.Missing, System.Type.Missing, 1, XlSheetType.xlWorksheet);

However we can note the following things

  • The worksheets added at design time are Microsoft.Office.Tools.Excel.Worksheet
  • The worksheets added at runtime are Microsoft.Office.Interop.Excel.Worksheet
  • The add method :
    • expects only optional arguments
    • its two first arguments (Before and After) must be of type Interop.Excel.Worksheet
    • it will return an Interop.Excel.Worksheet
  • As far as I have seen - after googling quite a lot - there is no way to convert a Tools.Excel.Worksheet to a Interop.Excel.Worksheet

However there are some way (not given or advised by the MSDN) to convert a Interop.Excel.Worksheet to a Tools.Excel.Worksheet (search GetExtendedWorksheet in google).


Having these two types and no built in conversion is driving me crazy... I think for now I will continue working with sheets at design time. If you have any advice, leave a comment !

Tags: |


Pierre-Emmanuel Dautreppe

Posted on samedi, 26 décembre 2009 00:39

Note that in VS 2008 SP1, some extensions methods have been added to facilitate the conversion !


Posted on dimanche, 1 juillet 2012 17:56

i like

Posted on jeudi, 24 octobre 2013 15:27

Maintaining a good driving record in the long-term can lower the new driver's insurance rates. Statistically, and in reality, insuring a young person is likely to cost the company far more than insuring someone else, so  their premiums have to reflect this. Airport charges:  fees applied by the airport authorities for terminal and off terminal locations.

My web blog - young drivers insurance With gps - - ,

young driver insurance monthly

Posted on jeudi, 24 octobre 2013 15:27

It is always in the best interest of the person to timely go for the best possible car insurance policy. Consider whether you will be taking out the minimum liability cover or comprehensive and collision. By obtaining, a Pass Plus Certificate can reduce your premium by as much as 35%.

Here is my website -  young driver insurance monthly -

young drivers insurance cheap

Posted on jeudi, 24 octobre 2013 15:28

It should also be remembered that in the UK if the police find a car tyre to be defective (with a tyre tread of less than 1. One of the most important ways to lower young driver car insurance is to enroll yourself in some driving classes or course. Let's face it, insurance is a dirty word and one that strikes fear and trepidation into the hearts of many young drivers and their parents purely and simply because of two main facts:1.

Feel free to surf to my webpage  young drivers insurance cheap -

young drivers insurance specialist

Posted on jeudi, 24 octobre 2013 15:28

Lifetime dog insurance will cover your dog for its entire life. Anti-lock brakes, mechanized seat-belts, airbags, alarm bell systems, anti-theft security devices, as well as other comparable facilities built-in in your automobile are not only brilliant features which guard you time on the highway but in addition make you entitled to get reductions on your auto insurance plan. The outcome of this to ask them to pay a high premium, since you cannot gain years of experience over night there is little you can do about this.

Also visit my blog post -  young drivers insurance specialist -

young driver insurance schemes

Posted on jeudi, 24 octobre 2013 15:28

It may be impossible to avoid having people in these age ranges on your policy. Generally, the insurance premiums for the young drivers are more expansive than any other categorized populaces. These simple steps will greatly reduce or even eliminate any opportunity for your insurance company to deny a claim in the future.

my website  young driver insurance schemes -

Posted on jeudi, 24 octobre 2013 15:30

In this case once more an accident on the road can be fatal. Bear in mind costs will differ wildly from provider to provider, and the cheapest quote isn't essentially the best, however the costliest is perhaps not the very best either. Insurance companies live and die by the law of averages.

Check out my page :: young driver Insurance help ( - )

wilmington nc

Posted on mardi, 29 octobre 2013 08:51

Thank you a bunch for sharing this with all of us you actually recognize what you're speaking approximately! Bookmarked. Kindly also seek advice from my website =). We could have a link trade agreement among us!

Here is my blog;  wilmington nc -

Posted on vendredi, 8 novembre 2013 08:05

In less than 5 minutes, you can determine the value of a property anywhere in the United States. You will be expected to complete the purchase within 28 days of the property auction or face financial penalties. Bedding can be a carrier for bugs, lice, or other nasty things that you don't want in your home.

Here is my homepage :: meaningful beauty serum - -  -

green coffee suppliers

Posted on mercredi, 18 décembre 2013 12:24

I have read so many articles about the blogger lovers but this piece of writing is really a pleasant piece of writing, keep it up.

my blog post ...  green coffee suppliers -

Posted on mercredi, 1 janvier 2014 01:20

Right here is the perfect web site for anybody who wants to find out about this topic. You realize a whole lot its almost hard to argue with you (not that I actually would want to…HaHa). You certainly put a fresh spin on a subject which has been discussed for decades. Wonderful stuff, just wonderful!

Look into my web-site -

Posted on mercredi, 1 janvier 2014 09:49

wonderful publish, very informative. I'm wondering why the other experts of this sector don't understand this. You should proceed your writing. I'm sure, you have a great readers' base already!

Also visit my blog post :: -

Posted on mercredi, 19 février 2014 02:04

Hi this is kind of of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I'm starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience. Any help would be greatly appreciated!

Also visit my web page - How To Make Homemade Bubble Bath ( - )


Posted on samedi, 8 mars 2014 23:37

What a stuff of un-ambiguity and preserveness of precious know-how regarding unpredicted feelings.

my homepage ... new car finance,  Winfred - ,


Posted on mardi, 25 mars 2014 06:03

There is definately a great deal to find out about this issue. I like all the points you've made.

my blog post ... boiler repairs ( Jannette - )

Posted on samedi, 17 décembre 2016 19:58

Pingback from


Posted on lundi, 19 décembre 2016 22:38

Pingback from

buy anabolic steroids online

Posted on jeudi, 22 décembre 2016 19:42

Pingback from

buy ansomone online

Ajouter un commentaire

  • Commentaire
  • Aperçu immédiat