mars 24

## VSTO & .NET 3.5 : Excel - Setting values in cells

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 (See in MSDN), I have decided to so a serie of post, related to what I learn and discover in this domain.

• By simply using the "this" keyword when working in a sheet
• By using the "Globals" class
• Globals.Sheet1
• Globals.Sheet2

#### How to set a value in a single cell ?

• Select the cell you want and set a value

Globals.Sheet1.Cells[10, 10] = "Hello world";

#### How to set the same value in mutliple cells ?

• Select a range...
• Example 1

Excel.Range range = Globals.Sheet1.Range["D10", "E11"];

• Example 2

Excel.Range cell1 = (Excel.Range)Globals.Sheet1.Cells[10, 10];

Excel.Range cell2 = (Excel.Range)Globals.Sheet1.Cells[12, 12];

Excel.Range range = Globals.Sheet1.Range[cell1, cell2];

• ...and set

range.Value2 = "Same value";

#### How to set a formula in a cell ?

Note that to set it in mutliple cell, you can first get a range as specified above.

Globals.Sheet1.Range["A15", "A15"].Formula = "=15";

Globals.Sheet1.Range["A16", "A16"].Formula = "=15*2";

Globals.Sheet1.Range["A17", "A17"].Formula = "=R[-2]C+R[-1]C";

How works the last example ? It's pretty simple in fact :

• R means "the same row"
• R means the current row + 3 (if we are at row 10, so it will be row 13)
• R[-2] means the current row - 2 (if we are at row 10, so it will be row 8)
• C means "the current column"
• C means the current column + 3 (if we are at column 10, so it will be column 13)
• C[-2] means the current column - 2 (if we are at column 10, so it will be column 8)
Tags: |

Commentaires

Posted on vendredi, 11 avril 2014 21:15

Помимо специальной профессиональной обуви, которая выпускает специально для тренировок и занятий спортом, сегодня в моде обычные мужские кроссовки, которые носят на работу даже в офис.

my blog post; В москве Бутсы для футбола Найк модель из новой коллекции ( nike.makesit.net - http://nike.makesit.net/nike-hypervenom.html )

Posted on lundi, 19 décembre 2016 19:39

Pingback from steroidsforsale.biz

dianabol dragon

Posted on jeudi, 22 décembre 2016 15:49

Pingback from steroidsforsale.biz

anabolic steroids Ajouter un commentaire

• Commentaire
• Aperçu immédiat 