怎样将SPREAD控件里的内容导入EXCEL,在线等待!
如题!表头使用以下
MergeCell "A1:A2"
xlSheet.Cells(1, 1) = "购销存产品组别"
MergeCell "B1:B2"
xlSheet.Cells(1, 2) = "购销存日期"
MergeCell "C1:C2"
xlSheet.Cells(1, 3) = "产品区域"
MergeCell "D1:D2"
xlSheet.Cells(1, 4) = "产品编号"
MergeCell "E1:E2"
xlSheet.Cells(1, 5) = "产品名称"
MergeCell "F1:F2"
xlSheet.Cells(1, 6) = "单位"
MergeCell "G1:G2"
xlSheet.Cells(1, 7) = "产品类别"
MergeCell "H1:H2"
xlSheet.Cells(1, 8) = "供应商"
MergeCell "I1:I2"
xlSheet.Cells(1, 9) = "供应商单位"
MergeCell "J1:J2"
xlSheet.Cells(1, 10) = "每单位数量"
MergeCell "K1:K2"
xlSheet.Cells(1, 11) = "订货提前时间"
MergeCell "L1:L2"
xlSheet.Cells(1, 12) = "运输提前时间"
MergeCell "M1:M2"
xlSheet.Cells(1, 13) = "库存级别"
MergeCell "N1:N2"
xlSheet.Cells(1, 14) = "前6个月平均销售数量"
MergeCell "O1:O2"
xlSheet.Cells(1, 15) = "前3个月平均销售数量"
MergeCell "P1:P2"
xlSheet.Cells(1, 16) = "上月末库存"
MergeCell "Q1:Q2"
xlSheet.Cells(1, 17) = "在途订单数量"