trekkee
asked on
Reporting in MS Excel
//print totals
sheet.cells[ i + 2, 3 ] := 'Total (' + class_code + ')';
sheet.cells[ i + 2, 4 ] := class_time_total;
sheet.cells[ i + 2, 5 ] := class_total;
//set the TOTAL row range
startrange := 'C' + IntToStr( i + 2 );
endrange := 'E' + IntToStr( i + 2 );
range := x.Workbooks[ 1 ].Worksheets[ 'Delphi Data' ].Range[ startrange + ':' + endrange ];
//format TOTAL row
range.columns.font.size := 11;
range.columns.font.bold := true;
*** In the above code, how could I format the row/cells to have a border on the top? or bottom?
sheet.cells[ i + 2, 3 ] := 'Total (' + class_code + ')';
sheet.cells[ i + 2, 4 ] := class_time_total;
sheet.cells[ i + 2, 5 ] := class_total;
//set the TOTAL row range
startrange := 'C' + IntToStr( i + 2 );
endrange := 'E' + IntToStr( i + 2 );
range := x.Workbooks[ 1 ].Worksheets[ 'Delphi Data' ].Range[ startrange + ':' + endrange ];
//format TOTAL row
range.columns.font.size := 11;
range.columns.font.bold := true;
*** In the above code, how could I format the row/cells to have a border on the top? or bottom?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.