excelexport.csv

delphi实现EXCEL复杂导入导出功能的类

OrderNo,CustNo,SaleDate,ShipDate,EmpNo,ShipToContact,ShipToAddr1,ShipToAddr2,ShipToCity,ShipToState,ShipToZip,ShipToCountry,ShipToPhone,ShipVIA,PO,Terms,PaymentMethod,ItemsTotal,TaxRate,Freight,AmountPaid
1003,1351,04/12/1988,5/3/1988 12:00,114,,,,,,,,,UPS,,FOB,Credit,"1,250.00",4.5,$0.00,$0.00
1004,2156,04/17/1988,4/18/1988 0:00,145,Maria Eventosh,PO Box 737,,Johannesburg,,2042,Republic So. Africa,27-11-4432458,DHL,,FOB,Check,"7,885.00",0,$0.00,"$7,885.00"
1005,1356,04/20/1988,1/21/1988 12:00,110,,,,,,,,,UPS,,FOB,Visa,"4,807.00",0,$0.00,"$4,807.00"
1006,1380,11/06/1994,11/7/1988 12:00,46,,,,,,,,,Emery,P101324,FOB,Visa,"31,987.00",0,$0.00,$0.00
1007,1384,05/01/1988,5/2/1988 0:00,45,,,,,,,,,US Mail,,FOB,Visa,"6,500.00",0,$0.00,"$6,500.00"
1008,1510,05/03/1988,5/4/1988 0:00,12,,,,,,,,,US Mail,,Net 30,Visa,"1,449.50",0,$0.00,$0.00
1009,1513,05/11/1988,5/12/1988 0:00,71,,,,,,,,,US Mail,,Net 30,COD,"5,587.00",0,$0.00,$0.00
1010,1551,05/11/1988,5/12/1988 0:00,46,,,,,,,,,UPS,,Net 30,COD,"4,996.00",0,$0.00,"$4,996.00"
1011,1560,05/18/1988,5/19/1988 0:00,5,,,,,,,,,UPS,,Net 30,COD,"2,679.85",0,$0.00,"$2,679.85"
1012,1563,05/19/1988,5/20/1988 0:00,118,,,,,,,,,UPS,,Net 30,Credit,"5,201.00",0,$0.00,"$5,201.00"
1013,1624,05/25/1988,5/26/1988 0:00,134,,,,,,,,,Emery,,Net 30,Credit,"3,115.00",0,$0.00,"$3,115.00"
1014,1645,05/25/1988,5/26/1988 0:00,144,,,,,,,,,Emery,,Net 30,Credit,134.85,0,$0.00,$134.85
1015,1651,05/25/1988,5/26/1988 0:00,71,,,,,,,,,Emery,,FOB,MC,"20,321.75",0,$0.00,"$20,321.75"
1016,1680,06/02/1988,6/3/1988 0:00,65,,,,,,,,,UPS,,FOB,AmEx,"2,605.00",0,$0.00,$0.00
1017,1984,06/12/1988,6/13/1988 0:00,28,,,,,,,,,DHL,,FOB,Check,"10,195.00",0,$0.00,$0.00
1018,2118,06/18/1988,6/19/1988 0:00,118,,,,,,,,,DHL,,FOB,Check,"5,256.00",0,$0.00,$0.00
1019,2135,06/24/1988,6/25/1988 0:00,114,,,,,,,,,DHL,,Net 30,Credit,"20,602.00",0,$0.00,$0.00
1020,2156,06/24/1988,6/25/1988 0:00,61,,,,,,,,,DHL,,Net 30,Credit,"9,955.00",0,$0.00,"$9,955.00"
1021,2163,06/24/1988,6/25/1988 0:00,52,,,,,,,,,UPS,,Net 30,Credit,"3,719.00",0,$0.00,"$3,719.00"
1022,2163,06/30/1988,7/1/1988 0:00,46,,,,,,,,,UPS,,Net 30,Credit,"10,064.65",0,$0.00,"$10,064.65"
1023,1221,07/01/1988,7/2/1988 0:00,5,,,,,,,,,UPS,,Net 30,Check,"4,674.00",0,$0.00,"$4,674.00"
1024,3151,07/02/1988,7/3/1988 0:00,2,,,,,,,,,UPS,,Net 30,Check,"6,897.00",0,$0.00,"$6,897.00"
1025,1510,07/03/1988,7/4/1988 0:00,8,,,,,,,,,DHL,,Net 30,AmEx,930.00,0,$0.00,$930.00
1026,1624,07/07/1988,7/8/1988 0:00,44,,,,,,,,,UPS,,Net 30,AmEx,"2,920.00",0,$0.00,"$2,920.00"
1027,1384,07/07/1988,7/8/1988 0:00,34,,,,,,,,,UPS,,Net 30,Visa,"25,210.00",0,$0.00,"$25,210.00"
1028,1651,07/07/1988,7/8/1988 0:00,11,,,,,,,,,Emery,,FOB,Visa,343.80,0,$0.00,$343.80
1029,1645,07/18/1988,7/19/1988 0:00,110,,,,,,,,,FedEx,,FOB,MC,"20,108.00",0,$0.00,"$20,108.00"
1030,3615,07/25/1988,7/26/1988 0:00,107,,,,,,,,,FedEx,,FOB,MC,559.60,0,$0.00,$559.60
1031,2118,07/28/1988,8/1/1988 0:00,127,,,,,,,,,FedEx,,FOB,Credit,"12,685.00",0,$0.00,"$12,685.00"
1032,2163,07/28/1988,8/1/1988 0:00,144,,,,,,,,,FedEx,,FOB,Credit,775.00,0,$0.00,$775.00
1033,1384,08/01/1988,8/2/1988 0:00,138,,,,,,,,,FedEx,,FOB,Cash,"1,238.00",0,$0.00,"$1,238.00"
1034,1680,08/13/1988,8/14/1988 0:00,24,,,,,,,,,UPS,,FOB,Check,"18,532.00",0,$0.00,"$18,532.00"
1035,1560,08/16/1988,8/17/1988 0:00,15,,,,,,,,,UPS,,FOB,Credit,560.00,0,$0.00,$560.00
1036,5384,08/25/1988,8/26/1988 0:00,4,,,,,,,,,DHL,,FOB,Credit,"4,110.00",0,$0.00,"$4,110.00"
1037,1984,08/26/1988,8/27/1988 0:00,12,,,,,,,,,DHL,,FOB,Credit,"3,117.00",0,$0.00,"$3,117.00"
1038,1645,08/26/1988,8/27/1988 0:00,72,,,,,,,,,DHL,,FOB,Visa,"10,152.00",0,$0.00,"$10,152.00"
1039,3158,08/29/1988,9/1/1988 0:00,61,,,,,,,,,US Mail,,FOB,Visa,536.80,0,$0.00,$536.80
1040,6812,09/04/1988,9/5/1988 0:00,52,,,,,,,,,US Mail,,Net 30,Visa,"3,632.00",0,$0.00,"$3,632.00"
1041,4652,09/16/1988,9/17/1988 0:00,109,,,,,,,,,US Mail,,Net 30,AmEx,"7,807.00",0,$0.00,"$7,807.00"
1042,3984,09/24/1988,9/25/1988 0:00,9,,,,,,,,,UPS,,Net 30,AmEx,971.70,0,$0.00,$971.70
1043,5132,09/30/1988,10/1/1988 0:00,14,,,,,,,,,UPS,,Net 30,Credit,"12,455.00",0,$0.00,"$12,455.00"
1044,5515,10/08/1988,10/9/1988 0:00,12,,,,,,,,,UPS,,FOB,Credit,"64,050.00",0,$0.00,"$64,050.00"
1045,9841,10/16/1988,10/17/1988 0:00,36,,,,,,,,,FedEx,,FOB,Credit,787.80,0,$0.00,$787.80
1046,2315,11/12/1988,11/13/1988 0:00,24,,,,,,,,,FedEx,,FOB,Check,766.80,0,$0.00,$766.80
1047,5515,11/27/1988,11/28/1988 0:00,44,,,,,,,,,FedEx,,FOB,Cash,"15,365.00",0,$0.00,"$15,365.00"
1048,5432,12/02/1988,12/3/1988 0:00,118,,,,,,,,,FedEx,,FOB,Visa,"7,346.00",0,$0.00,"$7,346.00"
1049,9841,12/13/1988,12/14/1988 0:00,107,,,,,,,,,UPS,,FOB,MC,"1,809.85",0,$0.00,"$1,809.85"
1050,3052,12/24/1988,12/25/1988 0:00,94,,,,,,,,,UPS,,FOB,AmEx,"6,287.85",0,$0.00,"$6,287.85"
1051,2165,01/04/1989,1/5/1989 0:00,2,,,,,,,,,FedEx,,Net 30,Credit,325.00,0,$0.00,$325.00
1052,1351,01/06/1989,1/7/1989 0:00,144,,,,,,,,,FedEx,,Net 30,Credit,"16,788.00",0,$0.00,"$16,788.00"
1053,6516,01/15/1989,1/16/1989 0:00,145,,,,,,,,,FedEx,,Net 30,Credit,"24,650.00",0,$0.00,"$24,650.00"
1054,5432,01/28/1989,2/1/1989 0:00,83,,,,,,,,,UPS,,Net 30,Visa,"14,188.00",0,$0.00,"$14,188.00"
1055,1351,02/04/1989,2/5/1989 0:00,29,,,,,,,,,UPS,,Net 30,Credit,"23,406.00",0,$0.00,"$23,406.00"
1056,1513,02/08/1989,2/9/1989 0:00,24,,,,,,,,,UPS,,Net 30,MC,"19,293.70",0,$0.00,"$19,293.70"
1057,1563,02/18/1989,2/19/1989 0:00,14,,,,,,,,,UPS,,Net 30,Credit,"1,975.00",0,$0.00,"$1,975.00"
1058,2118,02/21/1989,2/22/1989 0:00,8,,,,,,,,,US Mail,,Net 30,Credit,"12,736.00",0,$0.00,"$12,736.00"
1059,1356,02/24/1989,2/25/1989 0:00,109,,4-976 Sugarloaf Hwy,Suite 103,Kapaa Kauai,HI,94766-1234,America,808-555-0269,US Mail,,FOB,Cash,"2,150.00",8.5,$0.00,"$2,150.00"
1060,1231,02/28/1989,3/1/1989 0:00,94,,,,,,,,,US Mail,,FOB,Check,"15,355.00",0,$0.00,"$15,355.00"
1061,1563,03/03/1989,3/4/1989 0:00,2,,,,,,,,,US Mail,,FOB,Credit,"24,277.30",0,$0.00,"$24,277.30"
1062,2118,03/08/1989,3/9/1989 0:00,11,,,,,,,,,US Mail,,FOB,Credit,"18,320.00",0,$0.00,"$18,320.00"
1063,3042,03/13/1989,3/14/1989 0:00,24,,,,,,,,,US Mail,,FOB,Credit,"61,869.30",0,$0.00,"$61,869.30"
1064,2118,03/24/1989,3/25/1989 0:00,83,,,,,,,,,DHL,,Net 30,Credit,395.00,0,$0.00,$395.00
1065,6312,03/25/1989,3/26/1989 0:00,72,,,,,,,,,UPS,,FOB,Visa,"17,814.00",0,$0.00,"$17,814.00"
1066,3054,03/26/1989,3/27/1989 0:00,65,,,,,,,,,DHL,,Net 30,Visa,"19,812.00",0,$0.00,"$19,812.00"
1067,1351,04/01/1989,4/2/1989 0:00,34,,,,,,,,,FedEx,,FOB,Visa,"4,495.00",0,$0.00,"$4,495.00"
1068,4531,04/03/1989,4/4/1989 0:00,105,,,,,,,,,FedEx,,FOB,MC,"31,847.00",0,$0.00,"$31,847.00"
1069,2975,04/05/1989,4/6/1989 0:00,136,,,,,,,,,UPS,,FOB,Credit,"33,829.45",0,$0.00,"$33,829.45"
1070,6215,04/07/1989,4/8/1989 0:00,144,,,,,,,,,DHL,,Net 30,Credit,"22,354.00",0,$0.00,"$22,354.00"
1071,1560,04/09/1989,4/10/1989 0:00,114,,,,,,,,,FedEx,,Net 30,Cash,"103,041.00",0,$0.00,"$103,041.00"
1072,1356,04/11/1989,4/12/1989 0:00,29,,,,,,,,,US Mail,,Net 30,Cash,"3,596.00",0,$0.00,"$3,596.00"
1073,1231,04/15/1989,4/16/1989 0:00,2,,,,,,,,,US Mail,,Net 30,MC,"19,414.00",0,$0.00,"$19,414.00"
1074,1984,04/19/1989,4/20/1989 0:00,15,,,,,,,,,US Mail,,Net 30,MC,"2,195.00",0,$0.00,"$2,195.00"
1075,1351,04/21/1989,4/22/1989 0:00,11,,,,,,,,,UPS,,FOB,MC,"8,560.00",0,$0.00,"$8,560.00"
1076,1221,12/16/1994,4/26/1989 0:00,9,,,,,,,,,UPS,,FOB,Visa,"17,781.00",0,$0.00,"$17,781.00"
1077,1551,04/29/1989,5/1/1989 0:00,110,,,,,,,,,DHL,,FOB,Credit,156.00,0,$0.00,$156.00
1078,3041,05/01/1989,5/2/1989 0:00,39,,,,,,,,,DHL,,FOB,Credit,"79,116.00",0,$0.00,"$79,116.00"
1079,1380,05/03/1989,5/4/1989 0:00,44,,,,,,,,,DHL,,FOB,Credit,"4,445.00",0,$0.00,"$4,445.00"
1080,1356,05/05/1989,5/6/1989 0:00,45,,,,,,,,,UPS,,Net 30,Credit,"9,634.00",0,$0.00,"$9,634.00"
1081,3042,05/07/1989,5/8/1989 0:00,109,,,,,,,,,FedEx,,Net 30,AmEx,"30,566.00",0,$0.00,"$30,566.00"
1082,1551,05/09/1989,5/10/1989 0:00,2,,,,,,,,,FedEx,,Net 30,AmEx,"1,416.45",0,$0.00,"$1,416.45"
1083,1563,05/09/1989,5/10/1989 0:00,20,,,,,,,,,FedEx,,Net 30,Cash,"11,164.80",0,$0.00,"$11,164.80"
1084,1680,05/11/1989,5/12/1989 0:00,15,,,,,,,,,US Mail,,Net 30,Cash,"1,185.00",0,$0.00,"$1,185.00"
1086,1513,05/18/1989,5/19/1989 0:00,29,,,,,,,,,US Mail,,Net 30,Cash,"14,049.95",0,$0.00,"$14,049.95"
1087,1351,05/20/1989,5/21/1989 0:00,127,,,,,,,,,DHL,,Net 30,Credit,"14,045.00",0,$0.00,"$14,045.00"
1089,3151,05/22/1989,5/23/1989 0:00,113,,,,,,,,,UPS,,FOB,Credit,"2,706.00",0,$0.00,"$2,706.00"
1090,1513,05/25/1989,5/26/1989 0:00,94,,,,,,,,,DHL,,FOB,Credit,"8,507.00",0,$0.00,"$8,507.00"
1091,1563,05/28/1989,6/1/1989 0:00,83,,,,,,,,,US Mail,,FOB,Credit,"1,950.00",0,$0.00,"$1,950.00"
1092,6582,05/30/1989,6/1/1989 0:00,61,,,,,,,,,FedEx,,Net 30,Visa,"76,698.75",0,$0.00,"$76,698.75"
1093,1680,06/01/1989,6/2/1989 0:00,2,,,,,,,,,FedEx,,Net 30,Visa,479.80,0,$0.00,$479.80
1094,5163,06/03/1989,6/4/1989 0:00,4,,,,,,,,,FedEx,,FOB,MC,"4,113.75",0,$0.00,$0.00
1095,2156,06/05/1989,6/6/1989 0:00,36,,,,,,,,,US Mail,,Net 30,MC,"7,531.75",0,$0.00,$0.00
1096,2354,06/09/1989,6/9/1989 0:00,34,,,,,,,,,DHL,,Net 30,MC,"123,740.00",0,$0.00,$0.00
1097,3615,06/12/1989,6/12/1989 0:00,107,,,,,,,,,UPS,,Net 30,MC,"12,953.60",0,$0.00,$0.00
1098,2315,06/14/1989,6/14/1989 0:00,118,,,,,,,,,UPS,,Net 30,Credit,472.90,0,$0.00,$0.00
1099,1984,06/16/1989,6/16/1989 0:00,138,,,,,,,,,UPS,,Net 30,Credit,859.95,0,$0.00,$0.00
1100,1384,06/20/1989,6/20/1989 0:00,9,,,,,,,,,UPS,,FOB,Credit,"6,094.80",0,$0.00,$0.00
1101,2165,07/04/1989,7/4/1989 0:00,37,,,,,,,,,UPS,,FOB,Credit,"11,629.85",0,$0.00,$0.00
1102,1231,06/06/1992,6/6/1992 0:00,105,,,,,,,,,UPS,,FOB,Credit,"2,844.00",0,$0.00,"$2,844.00"
1103,3042,07/13/1992,7/13/1992 0:00,94,,,,,,,,,UPS,,FOB,Credit,"39,797.70",0,$0.00,"$39,797.70"
1104,1354,07/18/1992,7/18/1992 0:00,83,,,,,,,,,DHL,,FOB,Check,"51,673.15",0,$0.00,"$51,673.15"
1105,1356,07/21/1992,7/21/1992 0:00,28,,,,,,,,,UPS,,FOB,Visa,"31,219.95",0,$0.00,"$31,219.95"
1106,1380,09/23/1992,9/23/1992 0:00,15,,,,,,,,,Emery,,FOB,Visa,"3,531.80",0,$0.00,"$3,531.80"
1107,1384,10/24/1992,10/24/1992 0:00,134,,,,,,,,,US Mail,,FOB,Visa,"28,389.00",0,$0.00,"$28,389.00"