mars 26
We'll see here how we can dynamically add new worksheets in an excel document using the VSTO tools. [Plus]
Tags: |
mars 26
When creating some Excel files using the VSTO, you may need to generate charts.
We'll see here how to do it the "simple way" using the SetSourceData method, but also how to have lot more control about the chart creation, dealing directly with the SeriesCollection and creating some series on the fly.
We'll also see how to associate each serie with a specific axis, and how to customize a bit each axis. [Plus]
Tags: |
mars 24
Since a few days, I'm working in Visual Studio 2008 and VSTO to update an Excel application.

As I have a mighty hard time to understand everything and find some information in the very lacunar documentation, I have decided to so a serie of post, related to what I learn and discover in this domain.

I will explain
- how to access your different sheets
- how to select a range (composed of a single cell or of multiple cell)
- how to set values (single value or a formula) in a cell
- how to write relative formulas [Plus]
Tags: |
janv. 27
I just found (what I think to be) a bug in Powerpoint 2007 when working with actions and switches "/". Check here for some details ! [Plus]
Tags: |
oct. 22
I was just surfing around Internet, reading a blog I have just discovered when I have found this post (in french) :

Excel has some calculation problems (or display ?) when dealing with the number 65 535.

Interesting to know no ? ( and to download the associated patch ) [Plus]