excel cell alignment

[michael_jhons]

hello everybody can somebody help me in formating excel cells inside a worksheet: i tried

worksheet.get_Range(worksheet.Cells[2, 1], worksheet.Cells[2, 3]).HorizontalAlignment = HorizontalAlignment.Left;

but gave me an error i made a research i found that i have to use

... HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter

the problem is that i couldn't find XlHAlign property i tried many reference but without any solution. thank you in advance and kind regards

[Pedram Behroozi]

michael_jhons wrote:

but gave me an error i made a research i found that i have to use ... HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter

But it worked for me! :confused: It's my code:

using System;
using System.Text;
using Microsoft.Office.Interop.Excel;

namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
WorksheetClass ws = new WorksheetClass();
ws.get_Range(ws.Cells[2, 1], ws.Cells[2, 3]).HorizontalAlignment = XlHAlign.xlHAlignCenter;
}
}
}

While (true) { Human.isLearnable = true; }

[michael_jhons]

thank you pedram, it was the

using Microsoft.Office.Interop.Excel;

i added as a reference but when i added from using XLHalign apears, thank you fro your help

[minhlao]

Range rng = objSheet.getRange(col1, row1,col2 ,row2); rng.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; ;) enjoy it soicodon : mihazu_undead@yahoo.com