Copy table from word to excel ...

I just had to convert a word table (nicely formatted with bullet list, etc.) into an excel table.

The native approach with Copy and Paste does not work as each bullet in the list results in an own cell in excel.

Approach:

1) Select the table in word
2) Replace '^p' with ';'
3) Replace '^l' with ';'
4) Format bullet list to no bullet list
5) Replace ';;' with ';' ...

Copy - Paste

Learning to program excel with c#

After some time I figured out how to set ranges with row and column numbers.


            range = xlWorkSheet.get_Range(xlWorkSheet.Cells[r1, c1], xlWorkSheet.Cells[r2, c2]);

where r1, r2, c1, c2 are all integers

and xlWorkSheet is the worksheet under work

Developing Sparx EA AddIn with Visual Studio 2010

After switching from VS 2008 to VS 2010 I had the problem that the debugger didn't break in the newly compiled addin. After trying around I came to the following solution:
- compile the add in
- start EA
- attach the debugger to EA
This picks a compatible version of the debugger (the default is the latest debugger).