|
xlsheet.get_Range(xlsheet.Cells[2, 13], xlsheet.Cells[3, 13]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 13] = "合同号"; xlsheet.get_Range(xlsheet.Cells[2, 13], xlsheet.Cells[3, 13]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 14], xlsheet.Cells[3, 14]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 14] = "供应商"; xlsheet.get_Range(xlsheet.Cells[2, 14], xlsheet.Cells[3, 14]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 15], xlsheet.Cells[3, 15]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 15] = "合同签定日"; xlsheet.get_Range(xlsheet.Cells[2, 15], xlsheet.Cells[3, 15]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 16], xlsheet.Cells[3, 16]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 16] = "合同金额"; xlsheet.get_Range(xlsheet.Cells[2, 16], xlsheet.Cells[3, 16]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 17], xlsheet.Cells[3, 17]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 17] = "合同控制价"; xlsheet.get_Range(xlsheet.Cells[2, 17], xlsheet.Cells[3, 17]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 18], xlsheet.Cells[3, 18]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 18] = "出厂资料交付时间"; xlsheet.get_Range(xlsheet.Cells[2, 18], xlsheet.Cells[3, 18]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 19], xlsheet.Cells[3, 19]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 19] = "出厂前检验时间"; xlsheet.get_Range(xlsheet.Cells[2, 19], xlsheet.Cells[3, 19]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 20], xlsheet.Cells[3, 20]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 20] = "性能试验时间"; xlsheet.get_Range(xlsheet.Cells[2, 20], xlsheet.Cells[3, 20]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.get_Range(xlsheet.Cells[2, 21], xlsheet.Cells[2, 24]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 21] = "交货时间"; xlsheet.get_Range(xlsheet.Cells[2, 21], xlsheet.Cells[2, 24]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.ActiveSheet.Cells[3, 21] = "1"; xlsheet.ActiveSheet.Cells[3, 22] = "2"; xlsheet.ActiveSheet.Cells[3, 23] = "3"; xlsheet.ActiveSheet.Cells[3, 24] = "4"; xlsheet.get_Range(xlsheet.Cells[2, 25], xlsheet.Cells[2, 30]).set_MergeCells(true); xlsheet.ActiveSheet.Cells[2, 25] = "付款条件"; xlsheet.get_Range(xlsheet.Cells[2, 25], xlsheet.Cells[2, 30]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter); xlsheet.ActiveSheet.Cells[3, 25] = "1"; xlsheet.ActiveSheet.Cells[3, 26] = "2"; xlsheet.ActiveSheet.Cells[3, 27] = "3"; xlsheet.ActiveSheet.Cells[3, 28] = "4"; xlsheet.ActiveSheet.Cells[3, 29] = "5"; xlsheet.ActiveSheet.Cells[3, 30] = "6"; #endregion