利用 owc 生成 excel 并且显示在页面(2)

http://www.sina.com.cn 2008年07月11日 13:06 IT168.com

   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