需要实现一个将固定格式的Excel File内容导入到系统中的功能:
需要导入至主表中的字段与excel文件的对应关系为:
field excel Field
PromoCode Promo Nbr
ItemDescription Promotion Name
RebateAmount Rebate value
TotalSold Total Sold
Redeemed Redemption Rate
RebateReserve Total Reserved
BeginPromoPeriodDate promo period(前面的日期部分)
EndPromoPeriodEndDate promo period(后面的日期部分)
需要导入至从表的字段与excel文件的对应关系为:
field excel Field
InvoiceNumber Invoice Number
InvoiceDate Invoice Date
TotalValid Total Valid
TotalInvalid Total Invalid
RebateTotal Rebate total
ProcessFe Fees And Tax Total