Tuesday, 2 November 2010

Eclipse Client Platform

The Eclipse client platform looks really inteesting. Here is a tutorial how to install and use it.

Saturday, 30 October 2010

Friday, 29 October 2010

Monday, 12 July 2010

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

Sunday, 11 July 2010

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