难点一:
Excel中字段名称与数据库中不一致
难点二:
如何根据条件,对已有数据进行筛选
先将Excel中的字段用别名对应到数据库中的字段名
string mColTitle2 = " 寄件公司 as Col_001,寄件地址 as Col_002,寄件电话 as Col_003,寄件联系人 as Col_004,短信服务号 as Col_005,收件公司 as Col_006,收件地址 as Col_007,收件电话 as Col_008,收件手机 as Col_009,收件联系人 as Col_010,寄件区号 as Col_011,付款方式 as Col_013,是否回单 as Col_014,寄件公司编码 as Col_015,原寄地 as Col_016,收件地