Programmatically building Excel worksheet.range in C#

Question

Hope you can help.

I'm looking for a way to build an excel sheet range by just passing in some parameters. My method is as follows:

private void TableCellformatting(int rowStart, int rowEnd, char colStart, char colEnd)
    {
        char temp;
        StringBuilder s = new StringBuilder();
        excelSheetRange = null;
        for (int i = rowStart; i <= rowEnd; i++)
        {
            temp = colStart;
            while (temp <= colEnd)
            {
                if (s.Length > 0)
                    s.Append(", ");
                s.Append(string.Format("{0}{1}", temp.ToString(), i));
                temp++;
            }
        }
        excelSheetRange = excelSheet.get_Range(s.ToString());
        excelSheetRange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
    }

This runs ok until the excelSheet.get_Range part is called. When I pass in the cell numbers manually, I have to do it like this:

get_Range("A1", "A2" etc...)

Any ideas if this is even possible, or if there is another way?

Thanks!

Motomotes · Accepted Answer · 2019-07-12 19:05:01Z

2

Use worksheet.range property.

excelSheetRange = excelSheet.Range[excelsheet.Cells[rowstart, colstart], excelsheet.Cells[rowend, colend]];

edited Jul 12, 2019 at 19:05

answered May 10, 2012 at 15:32

Motomotes

4,2471 gold badge28 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Don Diego Over a year ago

link is not valid anymore, do you know where I can find some Info about this? I'm confused with the fact that a Range variable can contain an xlsSheet.Range[xlsSheet.Cells[rowstart, colstart]] type but also an xlsSheet.Range[xlsSheet.Cells[rowstart, colstart], xlsSheet.Cells[rowstart, colstart]] variable

Motomotes Over a year ago

It is just like an overload, xlsSheet.Range[xlsSheet.Cells[rowstart, colstart]] == xlsSheet.Range[xlsSheet.Cells[rowstart, colstart], xlsSheet.Cells[rowstart, colstart]] It's like xlsSheet.Range(Cell) calls xlsSheet.Range(Cell, Cell), a Range is always from one Cell to another Cell a range of one cell is a unique case where the Range starts and stops on the same Cell.

Motomotes Over a year ago

web.archive.org/web/20150107183159/http://msdn.microsoft.com/…

Collectives™ on Stack Overflow

Programmatically building Excel worksheet.range in C#

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related