private void Format_top_block() { //format title block xl.range = xl.Select_range(2, 2, 6, 2); xl.range.Font.Bold = true; xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight; xl.range = xl.Select_range(2, 3, 6, 3); xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft; //format subtotals block xl.range = xl.Select_range(2, 5, 7, 5); xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight; xl.range = xl.Select_range(2, 6, 3, 6); xl.range.Style = xl.workbook.Styles["Currency"]; xl.range = xl.Select_range(4, 5, 4, 6); xl.range.Font.Bold = true; xl.range = xl.Select_range(5, 6, 7, 6); xl.range.Style = xl.workbook.Styles["Currency"]; xl.range = xl.Select_range(7, 5, 7, 6); xl.range.Font.Bold = true; xl.range = xl.Select_range(2, 8, 6, 8); xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight; xl.range = xl.Select_range(3, 9, 3, 9); xl.range.Style = xl.workbook.Styles["Currency"]; xl.range = xl.Select_range(6, 9, 6, 9); xl.range.Style = xl.workbook.Styles["Currency"]; }
private void Format_quote_body() { //set column widths //xl.worksheet.Cells[1, 1].ColumnWidth = 10; xl.worksheet.Cells[1, qs.quantityCol].ColumnWidth = 6; xl.worksheet.Cells[1, qs.descriptionCol].ColumnWidth = 26; xl.worksheet.Cells[1, qs.serviceCol].ColumnWidth = 35; xl.worksheet.Cells[1, qs.materialCol].ColumnWidth = 20; xl.worksheet.Cells[1, qs.sizeCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.ratingCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.lengthCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.materialBufferCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.aCol].ColumnWidth = 8; xl.worksheet.Cells[1, qs.bCol].ColumnWidth = 8; xl.worksheet.Cells[1, qs.cCol].ColumnWidth = 8; xl.worksheet.Cells[1, qs.unitsCol].ColumnWidth = 8; xl.worksheet.Cells[1, qs.partNumCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.partPriceCol].ColumnWidth = 14; xl.worksheet.Cells[1, qs.materialPriceCol].ColumnWidth = 14; xl.worksheet.Cells[1, qs.laborBufferCol].ColumnWidth = 12; xl.worksheet.Cells[1, qs.plasmaLaborCol].ColumnWidth = 8; xl.worksheet.Cells[1, qs.hoursCol].ColumnWidth = 8; ////hide material calculation columns //xl.range = xl.Select_range(1, qs.aCol, 1, qs.partPriceCol); //xl.range.EntireColumn.Hidden = true; //format column headers xl.range = xl.Select_range(qs.headerRow, qs.firstCol, qs.headerRow, qs.lastCol); xl.range.Font.Bold = true; xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; //set top boundary xl.range = xl.Select_range(qs.headerRow + 1, qs.firstCol, qs.headerRow + 1, qs.lastCol); xl.range.EntireRow.RowHeight = 3; xl.range.Interior.Color = Excel.XlRgbColor.rgbBlack; //set bottom boundary xl.range = xl.Select_range(qs.lastRow + 1, qs.firstCol, qs.lastRow + 1, qs.lastCol); xl.range.EntireRow.RowHeight = 3; xl.range.Interior.Color = Excel.XlRgbColor.rgbBlack; //format item cells xl.range = xl.Select_range(qs.firstRow, qs.firstCol, qs.lastRow, qs.lastCol); xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; xl.range = xl.Select_range(qs.firstRow, qs.partPriceCol, qs.lastRow, qs.partPriceCol); xl.range.Style = xl.workbook.Styles["Currency"]; xl.range = xl.Select_range(qs.firstRow, qs.materialPriceCol, qs.lastRow, qs.materialPriceCol); xl.range.Style = xl.workbook.Styles["Currency"]; }