Almost Done! Need help formatting Excel

[JM]

Hi

I am almost done my little project. However I need to know how to "centre"
the title/header row. I've already managed to bold and underlined.

Also how would one sort all of the data on the worksheet but not including
the header row??

worksheet.get_Range("A1", "H1").Font.Bold = true;
worksheet.get_Range("A1", "H1").Font.Underline = true;

Range oRng = worksheet.get_Range("A1", "H1");
oRng.EntireColumn.AutoFit();

[JM]

I got how to centre the header / title row

worksheet.get_Range("A1", "H1").HorizontalAlignment = -4108;

Now how does one AutoFilter the Excel spreadsheet??

"JM" wrote:

Hi

I am almost done my little project. However I need to know how to "centre"
the title/header row. I've already managed to bold and underlined.

Also how would one sort all of the data on the worksheet but not including
the header row??

worksheet.get_Range("A1", "H1").Font.Bold = true;
worksheet.get_Range("A1", "H1").Font.Underline = true;

Range oRng = worksheet.get_Range("A1", "H1");
oRng.EntireColumn.AutoFit();