Almost Done! Need help formatting Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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();
 
I got how to centre the header / title row

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

Now how does one AutoFilter the Excel spreadsheet??
 
Back
Top