# -*- coding: utf-8 -*-

str_list = ["004666,长城久嘉创新成长混合,CCJJCXCZHH,2020-02-24,1.6128,1.6128,4.2332,16.3552,24.8297,67.2335,74.6778,88.5213,"
            "56.5673,,53.5415,61.28,2017-07-05,1,80.6249,1.50%,0.15%,1,0.15%,1,","519674,银河创新成长混合,YHCXCZHH,"
                                                                                 "2020-02-24,6.4687,6.4687,5.3140,"
                                                                                 "15.5084,29.0231,79.7810,114.5363,"
                                                                                 "163.5767,144.4062,196.2130,60.5615,"
                                                                                 "546.87,2010-12-29,1,148.7101,1.50%,"
                                                                                 "0.15%,1,0.15%,1,230.4572","008085,"
                                                                                                            "海富通先进制造股票A,HFTXJZZGPA,2020-02-24,1.2496,1.2496,3.5380,14.2857,20.5479,,,,,,25.0225,24.96,2019-12-17,1,24.96,1.50%,0.15%,1,0.15%,1,","008084,海富通先进制造股票C,HFTXJZZGPC,2020-02-24,1.2487,1.2487,3.5406,14.2766,20.5076,,,,,,24.9450,24.87,2019-12-17,1,24.87,,0.00%,,,,","007685,华商电子行业量化股票,HSDZHYLHGP,2020-02-24,1.5484,1.5484,4.7916,14.0038,23.6050,57.0067,,,,,42.2508,54.84,2019-09-17,1,54.84,1.50%,0.15%,1,0.15%,1,","001210,天弘互联网混合,THHLWHH,2020-02-24,1.2587,1.2587,5.4629,13.9301,27.3472,58.3868,74.0218,121.5241,93.4973,109.6087,49.1527,25.87,2015-05-29,1,109.6087,1.50%,0.15%,1,0.15%,1,","008281,国泰CES半导体行业ETF联接A,GTCESBDTHYETFLJA,2020-02-24,1.5892,1.5892,3.9780,13.8314,27.1869,58.92,,,,,52.8518,58.92,2019-11-22,1,58.92,1.00%,0.10%,1,0.10%,1,","008282,国泰CES半导体行业ETF联接C,GTCESBDTHYETFLJC,2020-02-24,1.5880,1.5880,3.9743,13.8188,27.1519,58.80,,,,,52.7805,58.80,2019-11-22,1,58.8,,0.00%,,,,","008326,东财中证通信A,DCZZTXA,2020-02-24,1.1512,1.1512,5.8672,13.5194,19.4191,,,,,,,15.12,2020-01-20,1,15.12,1.00%,0.10%,1,0.10%,1,","008327,东财中证通信C,DCZZTXC,2020-02-24,1.1509,1.1509,5.8591,13.5122,19.3880,,,,,,,15.09,2020-01-20,1,15.09,,0.00%,,,,","002844,金鹰多元策略混合,JYDYCLHH,2020-02-24,1.9071,1.9071,3.45,13.4436,23.8216,55.6181,64.5328,91.5721,83.0933,95.9416,47.2778,90.71,2016-08-09,1,84.8144,1.50%,0.15%,1,0.15%,1,","000534,长盛高端装备混合,CSGDZBHH,2020-02-24,2.3660,2.3660,5.0155,13.3142,25.0529,45.4210,58.0494,66.6197,55.4534,52.1543,33.6723,136.60,2014-03-25,1,60.4068,1.50%,0.15%,1,0.15%,1,63.7370","007300,国联安中证半导体ETF联接A,GLAZZBDTETFLJA,2020-02-24,2.2479,2.2479,3.7955,13.1417,26.3930,79.9904,102.6961,,,,56.3322,124.7675,2019-06-26,1,124.7675,0.80%,0.08%,1,0.08%,1,","007301,国联安中证半导体ETF联接C,GLAZZBDTETFLJC,2020-02-24,2.2388,2.2388,3.7971,13.1393,26.3716,79.8377,102.1490,,,,56.2753,123.8576,2019-06-26,1,123.8576,,0.00%,,,,","290011,泰信中小盘精选混合,TXZXPJXHH,2020-02-24,2.9210,3.1810,4.0242,13.0418,26.6146,57.1275,83.1347,107.3101,87.6044,62.5487,42.1411,241.7285,2011-10-26,1,99.1138,1.50%,0.15%,1,0.15%,1,79.2862","162703,广发小盘成长混合(LOF),GFXPCZHHLOF,2020-02-24,2.8964,5.2344,4.1683,12.7486,24.8018,59.3442,86.2517,143.0886,110.7546,149.9482,42.6096,1128.3661,2005-02-02,1,129.5087,1.50%,0.15%,1,0.15%,1,154.6522","007713,华富科技动能混合,HFKJDNHH,2020-02-24,1.3497,1.3497,5.0759,12.6252,22.4884,35.6346,,,,,33.8192,34.97,2019-11-06,1,34.97,1.50%,0.15%,1,0.15%,1,","007817,国泰中证全指通信设备ETF联接A,GTZZQZTXSBETFLJA,2020-02-24,1.2369,1.2369,6.1170,12.5068,16.5567,30.4472,,,,,22.6718,23.69,2019-09-03,1,23.69,1.00%,0.10%,1,0.10%,1,","007818,国泰中证全指通信设备ETF联接C,GTZZQZTXSBETFLJC,2020-02-24,1.2339,1.2339,6.1054,12.50,16.5156,30.3370,,,,,22.6175,23.39,2019-09-03,1,23.39,,0.00%,,,,","210008,金鹰策略配置混合,JYCLPZHH,2020-02-24,1.6672,2.2672,4.7631,12.4814,23.4871,60.0615,68.2681,73.1616,47.9326,53.4045,47.3963,139.2858,2011-09-01,1,65.6762,1.50%,0.15%,1,0.15%,1,53.3982","001617,天弘中证电子指数A,THZZDZZSA,2020-02-24,1.4640,1.4640,3.9994,12.4424,21.5947,51.8987,61.7858,82.0896,53.01,66.8756,37.2457,46.40,2015-07-29,1,71.9521,1.00%,0.10%,1,0.10%,1,","001618,天弘中证电子指数C,THZZDZZSC,2020-02-24,1.4477,1.4477,3.9940,12.4340,21.5737,51.8142,61.6278,81.7349,52.3734,65.7545,37.2097,44.77,2015-07-29,1,71.6098,,0.00%,,,,","320007,诺安成长混合,NACZHH,2020-02-24,1.7670,2.2120,4.4944,12.4046,22.7936,60.7825,102.4056,133.7301,92.2743,69.4152,42.1561,163.9893,2009-03-10,1,117.8791,1.50%,0.15%,1,0.15%,1,67.1712","008086,华夏中证5G通信主题ETF联接A,HXZZ5GTXZTETFLJA,2020-02-24,1.3165,1.3165,4.7502,12.3965,20.0857,,,,,,31.8610,31.65,2019-12-10,1,31.65,1.20%,0.12%,1,0.12%,1,","008087,华夏中证5G通信主题ETF联接C,HXZZ5GTXZTETFLJC,2020-02-24,1.3158,1.3158,4.7528,12.3943,20.0657,,,,,,31.8173,31.58,2019-12-10,1,31.58,,0.00%,,,,","002560,诺安和鑫灵活配置混合,NAHXLHPZHH,2020-02-24,1.5040,1.5040,4.4807,12.0465,23.0971,60.0340,96.8844,100.4264,46.7317,50.7014,42.83,50.40,2016-04-28,1,95.2233,1.50%,0.15%,1,0.15%,1,","002939,广发创新升级混合,GFCXSJHH,2020-02-24,2.5814,2.6264,4.0468,11.8991,23.8498,57.3161,90.2705,163.0593,114.6714,151.9261,39.8830,169.2838,2016-08-24,1,149.5071,1.50%,0.15%,1,0.15%,1,","006257,信达澳银先进智造股票型,XDAYXJZZGPX,2020-02-24,1.9582,1.9582,4.3094,11.8971,24.9968,58.8932,70.8130,94.8070,,,40.2320,95.82,2019-01-17,1,94.7876,1.50%,0.15%,1,0.15%,1,","519642,银河智造混合,YHZZHH,2020-02-24,2.1320,2.1320,4.4074,11.74,23.3796,44.1515,58.8674,89.5111,60.6631,108.2031,39.6202,113.20,2016-03-11,1,80.6780,1.50%,0.15%,1,0.15%,1,","000063,长盛电子信息主题灵活配置混合,CSDZXXZTLHPZHH,2020-02-24,2.1340,2.1340,3.1915,11.6109,25.3819,47.3757,56.9118,71.1307,24.1419,19.0184,41.6058,113.40,2013-05-10,1,66.7188,1.50%,0.15%,1,0.15%,1,95.4212","519005,海富通股票混合,HFTGPHH,2020-02-24,1.3890,3.3380,3.2714,11.4767,21.7353,67.1480,91.3223,121.8850,95.3586,137.8425,45.1411,496.9470,2005-07-29,1,107.6233,1.50%,0.15%,1,0.15%,1,81.8063","007484,信达澳银核心科技混合,XDAYHXKJHH,2020-02-24,1.6396,1.6396,4.3003,11.3027,24.3346,58.8606,63.8289,,,,40.5331,63.96,2019-08-14,1,63.96,1.50%,0.15%,1,0.15%,1,","000826,广发百发100指数A,GFBF100ZSA,2020-02-24,1.5660,1.9260,4.4696,11.2216,23.0165,44.4649,55.6661,85.7651,60.7804,58.6626,35.2332,100.4383,2014-10-30,1,76.3514,1.20%,0.12%,1,0.12%,1,57.3299","005495,创金合信科技成长股票A,CJHXKJCZGPA,2020-02-24,1.8011,1.8011,3.8158,11.1859,21.1964,54.3491,81.3431,106.6667,95.6654,,36.3334,80.11,2017-12-28,1,96.0701,1.50%,0.15%,1,0.15%,1,","005496,创金合信科技成长股票C,CJHXKJCZGPC,2020-02-24,1.7769,1.7769,3.8091,11.1744,21.1413,54.1378,80.4326,104.7592,93.1833,,36.2236,77.69,2017-12-28,1,94.2604,,0.00%,,,,","001480,财通成长优选混合,CTCZYXHH,2020-02-24,1.7820,1.7820,5.0088,11.1666,20.1618,50.7614,58.9652,94.3293,93.0661,113.6691,42.3323,78.20,2015-06-29,1,81.8367,1.50%,0.15%,1,0.15%,1,","000827,广发百发100指数E,GFBF100ZSE,2020-02-24,1.5630,1.9230,4.4088,11.1664,22.9740,44.4547,55.6773,85.8501,60.8025,58.6802,35.2076,100.0883,2014-10-30,1,76.4108,0.60%,0.06%,1,0.06%,1,57.0552","004044,金鹰转型动力混合,JYZXDLHH,2020-02-24,1.3143,1.3143,4.5751,11.0989,30.7631,54.2244,49.4542,56.2411,25.0285,,42.4870,31.43,2017-11-16,1,51.9598,1.50%,0.15%,1,0.15%,1,","001956,国联安科技动力,GLAKJDL,2020-02-24,1.8766,1.8766,3.2347,11.0809,23.8843,56.7360,80.5812,126.2054,72.1493,105.7675,52.1239,87.66,2016-01-26,1,111.2099,1.50%,0.15%,1,0.15%,1,","167506,安信深圳科技指数(LOF)A,AXSZKJZSLOFA,2020-02-24,1.3204,1.3204,3.7806,10.9580,16.3656,,,,,,30.2684,32.04,2019-12-06,1,32.04,1.20%,0.12%,1,0.12%,1,","167507,安信深圳科技指数(LOF)C,AXSZKJZSLOFC,2020-02-24,1.3197,1.3197,3.7826,10.9551,16.3449,,,,,,30.2250,31.97,2019-12-06,1,31.97,,0.00%,,,,","160626,鹏华信息分级,PHXXFJ,2020-02-24,1.0870,2.0110,3.5238,10.7828,19.6207,44.8688,55.7729,75.2445,55.2390,61.0097,33.5196,138.5880,2014-05-05,1,64.7796,1.20%,0.12%,1,0.12%,1,53.8211","165524,信诚中证智能家居指数分级,XCZZZNJJZSFJ,2020-02-24,1.08,,3.9461,10.7607,19.2563,41.4240,50.3334,60.2894,42.0876,19.5115,29.0633,-29.4153,2015-06-26,1,52.0878,1.00%,0.10%,1,0.10%,1,","163503,天治核心成长混合(LOF),TZHXCZHHLOF,2020-02-24,0.6329,2.6508,4.5597,10.6856,21.5713,43.9391,45.1273,60.5123,28.7691,31.9091,32.0743,280.5284,2006-01-20,1,54.0278,1.50%,0.15%,1,0.15%,1,19.9768","270028,广发制造业精选混合,GFZZYJXHH,2020-02-24,3.86,3.86,3.2362,10.6334,18.4776,48.4615,59.4382,86.2934,56.1489,65.2397,33.2873,286,2011-09-20,1,77.2268,1.50%,0.15%,1,0.15%,1,107.9741","519929,长信电子信息行业量化混合,CXDZXXHYLHHH,2020-02-24,1.2440,1.2440,3.1509,10.5778,22.2004,53.5802,58.6735,80.2899,55.8897,30.3983,41.2032,24.40,2016-07-27,1,69.7135,1.50%,0.15%,1,0.15%,1,","001410,信达澳银新能源产业股票,XDAYXNYCYGP,2020-02-24,3.2660,3.3280,3.8144,10.5620,23.4316,62.8116,82.5601,120.3779,139.4405,209.9919,41.5078,241.9211,2015-07-31,1,108.4238,1.50%,0.15%,1,0.15%,1,","002244,景顺长城低碳科技主题混合,JSCCDTKJZTHH,2020-02-24,1.53,1.58,2.2727,10.5491,18.3294,46.4114,44.8863,69.2477,51.4851,39.3443,28.3556,59.9293,2016-03-11,1,65.9436,1.50%,0.15%,1,0.15%,1,","519113,浦银安盛精致生活混合,PYASJZSHHH,2020-02-24,2.5280,2.5880,3.6490,10.5378,16.2298,40.1331,48.3568,71.3898,32.4947,28.1298,32.0794,166.5391,2009-06-04,1,63.0968,1.50%,0.15%,1,0.15%,1,91.3702","001468,广发改革混合,GFGGHH,2020-02-24,1.0180,1.0180,3.8776,10.5320,21.0464,42.1788,54.7112,82.7648,43.5825,32.0363,29.3520,1.80,2015-07-27,1,73.4242,1.50%,0.15%,1,0.15%,1,"]
# youdata = mydate.split(",")
# print(youdata)
import openpyxl as op
wb = op.Workbook()
ws = wb.active

row = 2

for count_key in range(len(str_list)):
    for col in range(1,len(str_list[count_key].split(","))):
        ws.cell(row,col).value = (str_list[count_key].split(","))[col-1]
    row+=1

wb.save('123.xlsx')
##一组二十五个数据

# for i in range(len(mydate)):
#     list1 = mydate[i]
#     name=['1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25']
#
#     test1 = pd.DataFrame(columns=name, data=list1)
#     #print(mydate[i])
#     #mydate[i].to_csv('C:/Users/15400/Desktop/data.csv',encoding='gbk')

# list = mydate[i]
# name=['1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25']






9244c75aabdc361c04b91fbd20433e5be375cfbc
<mask token>

<mask token>
for count_key in range(len(str_list)):
    for col in range(1, len(str_list[count_key].split(','))):
        ws.cell(row, col).value = str_list[count_key].split(',')[col - 1]
    row += 1
wb.save('123.xlsx')

str_list = [
    '004666,长城久嘉创新成长混合,CCJJCXCZHH,2020-02-24,1.6128,1.6128,4.2332,16.3552,24.8297,67.2335,74.6778,88.5213,56.5673,,53.5415,61.28,2017-07-05,1,80.6249,1.50%,0.15%,1,0.15%,1,'
    ,
    '519674,银河创新成长混合,YHCXCZHH,2020-02-24,6.4687,6.4687,5.3140,15.5084,29.0231,79.7810,114.5363,163.5767,144.4062,196.2130,60.5615,546.87,2010-12-29,1,148.7101,1.50%,0.15%,1,0.15%,1,230.4572'
    ,
    '008085,海富通先进制造股票A,HFTXJZZGPA,2020-02-24,1.2496,1.2496,3.5380,14.2857,20.5479,,,,,,25.0225,24.96,2019-12-17,1,24.96,1.50%,0.15%,1,0.15%,1,'
    ,
    '008084,海富通先进制造股票C,HFTXJZZGPC,2020-02-24,1.2487,1.2487,3.5406,14.2766,20.5076,,,,,,24.9450,24.87,2019-12-17,1,24.87,,0.00%,,,,'
    ,
    '007685,华商电子行业量化股票,HSDZHYLHGP,2020-02-24,1.5484,1.5484,4.7916,14.0038,23.6050,57.0067,,,,,42.2508,54.84,2019-09-17,1,54.84,1.50%,0.15%,1,0.15%,1,'
    ,
    '001210,天弘互联网混合,THHLWHH,2020-02-24,1.2587,1.2587,5.4629,13.9301,27.3472,58.3868,74.0218,121.5241,93.4973,109.6087,49.1527,25.87,2015-05-29,1,109.6087,1.50%,0.15%,1,0.15%,1,'
    ,
    '008281,国泰CES半导体行业ETF联接A,GTCESBDTHYETFLJA,2020-02-24,1.5892,1.5892,3.9780,13.8314,27.1869,58.92,,,,,52.8518,58.92,2019-11-22,1,58.92,1.00%,0.10%,1,0.10%,1,'
    ,
    '008282,国泰CES半导体行业ETF联接C,GTCESBDTHYETFLJC,2020-02-24,1.5880,1.5880,3.9743,13.8188,27.1519,58.80,,,,,52.7805,58.80,2019-11-22,1,58.8,,0.00%,,,,'
    ,
    '008326,东财中证通信A,DCZZTXA,2020-02-24,1.1512,1.1512,5.8672,13.5194,19.4191,,,,,,,15.12,2020-01-20,1,15.12,1.00%,0.10%,1,0.10%,1,'
    ,
    '008327,东财中证通信C,DCZZTXC,2020-02-24,1.1509,1.1509,5.8591,13.5122,19.3880,,,,,,,15.09,2020-01-20,1,15.09,,0.00%,,,,'
    ,
    '002844,金鹰多元策略混合,JYDYCLHH,2020-02-24,1.9071,1.9071,3.45,13.4436,23.8216,55.6181,64.5328,91.5721,83.0933,95.9416,47.2778,90.71,2016-08-09,1,84.8144,1.50%,0.15%,1,0.15%,1,'
    ,
    '000534,长盛高端装备混合,CSGDZBHH,2020-02-24,2.3660,2.3660,5.0155,13.3142,25.0529,45.4210,58.0494,66.6197,55.4534,52.1543,33.6723,136.60,2014-03-25,1,60.4068,1.50%,0.15%,1,0.15%,1,63.7370'
    ,
    '007300,国联安中证半导体ETF联接A,GLAZZBDTETFLJA,2020-02-24,2.2479,2.2479,3.7955,13.1417,26.3930,79.9904,102.6961,,,,56.3322,124.7675,2019-06-26,1,124.7675,0.80%,0.08%,1,0.08%,1,'
    ,
    '007301,国联安中证半导体ETF联接C,GLAZZBDTETFLJC,2020-02-24,2.2388,2.2388,3.7971,13.1393,26.3716,79.8377,102.1490,,,,56.2753,123.8576,2019-06-26,1,123.8576,,0.00%,,,,'
    ,
    '290011,泰信中小盘精选混合,TXZXPJXHH,2020-02-24,2.9210,3.1810,4.0242,13.0418,26.6146,57.1275,83.1347,107.3101,87.6044,62.5487,42.1411,241.7285,2011-10-26,1,99.1138,1.50%,0.15%,1,0.15%,1,79.2862'
    ,
    '162703,广发小盘成长混合(LOF),GFXPCZHHLOF,2020-02-24,2.8964,5.2344,4.1683,12.7486,24.8018,59.3442,86.2517,143.0886,110.7546,149.9482,42.6096,1128.3661,2005-02-02,1,129.5087,1.50%,0.15%,1,0.15%,1,154.6522'
    ,
    '007713,华富科技动能混合,HFKJDNHH,2020-02-24,1.3497,1.3497,5.0759,12.6252,22.4884,35.6346,,,,,33.8192,34.97,2019-11-06,1,34.97,1.50%,0.15%,1,0.15%,1,'
    ,
    '007817,国泰中证全指通信设备ETF联接A,GTZZQZTXSBETFLJA,2020-02-24,1.2369,1.2369,6.1170,12.5068,16.5567,30.4472,,,,,22.6718,23.69,2019-09-03,1,23.69,1.00%,0.10%,1,0.10%,1,'
    ,
    '007818,国泰中证全指通信设备ETF联接C,GTZZQZTXSBETFLJC,2020-02-24,1.2339,1.2339,6.1054,12.50,16.5156,30.3370,,,,,22.6175,23.39,2019-09-03,1,23.39,,0.00%,,,,'
    ,
    '210008,金鹰策略配置混合,JYCLPZHH,2020-02-24,1.6672,2.2672,4.7631,12.4814,23.4871,60.0615,68.2681,73.1616,47.9326,53.4045,47.3963,139.2858,2011-09-01,1,65.6762,1.50%,0.15%,1,0.15%,1,53.3982'
    ,
    '001617,天弘中证电子指数A,THZZDZZSA,2020-02-24,1.4640,1.4640,3.9994,12.4424,21.5947,51.8987,61.7858,82.0896,53.01,66.8756,37.2457,46.40,2015-07-29,1,71.9521,1.00%,0.10%,1,0.10%,1,'
    ,
    '001618,天弘中证电子指数C,THZZDZZSC,2020-02-24,1.4477,1.4477,3.9940,12.4340,21.5737,51.8142,61.6278,81.7349,52.3734,65.7545,37.2097,44.77,2015-07-29,1,71.6098,,0.00%,,,,'
    ,
    '320007,诺安成长混合,NACZHH,2020-02-24,1.7670,2.2120,4.4944,12.4046,22.7936,60.7825,102.4056,133.7301,92.2743,69.4152,42.1561,163.9893,2009-03-10,1,117.8791,1.50%,0.15%,1,0.15%,1,67.1712'
    ,
    '008086,华夏中证5G通信主题ETF联接A,HXZZ5GTXZTETFLJA,2020-02-24,1.3165,1.3165,4.7502,12.3965,20.0857,,,,,,31.8610,31.65,2019-12-10,1,31.65,1.20%,0.12%,1,0.12%,1,'
    ,
    '008087,华夏中证5G通信主题ETF联接C,HXZZ5GTXZTETFLJC,2020-02-24,1.3158,1.3158,4.7528,12.3943,20.0657,,,,,,31.8173,31.58,2019-12-10,1,31.58,,0.00%,,,,'
    ,
    '002560,诺安和鑫灵活配置混合,NAHXLHPZHH,2020-02-24,1.5040,1.5040,4.4807,12.0465,23.0971,60.0340,96.8844,100.4264,46.7317,50.7014,42.83,50.40,2016-04-28,1,95.2233,1.50%,0.15%,1,0.15%,1,'
    ,
    '002939,广发创新升级混合,GFCXSJHH,2020-02-24,2.5814,2.6264,4.0468,11.8991,23.8498,57.3161,90.2705,163.0593,114.6714,151.9261,39.8830,169.2838,2016-08-24,1,149.5071,1.50%,0.15%,1,0.15%,1,'
    ,
    '006257,信达澳银先进智造股票型,XDAYXJZZGPX,2020-02-24,1.9582,1.9582,4.3094,11.8971,24.9968,58.8932,70.8130,94.8070,,,40.2320,95.82,2019-01-17,1,94.7876,1.50%,0.15%,1,0.15%,1,'
    ,
    '519642,银河智造混合,YHZZHH,2020-02-24,2.1320,2.1320,4.4074,11.74,23.3796,44.1515,58.8674,89.5111,60.6631,108.2031,39.6202,113.20,2016-03-11,1,80.6780,1.50%,0.15%,1,0.15%,1,'
    ,
    '000063,长盛电子信息主题灵活配置混合,CSDZXXZTLHPZHH,2020-02-24,2.1340,2.1340,3.1915,11.6109,25.3819,47.3757,56.9118,71.1307,24.1419,19.0184,41.6058,113.40,2013-05-10,1,66.7188,1.50%,0.15%,1,0.15%,1,95.4212'
    ,
    '519005,海富通股票混合,HFTGPHH,2020-02-24,1.3890,3.3380,3.2714,11.4767,21.7353,67.1480,91.3223,121.8850,95.3586,137.8425,45.1411,496.9470,2005-07-29,1,107.6233,1.50%,0.15%,1,0.15%,1,81.8063'
    ,
    '007484,信达澳银核心科技混合,XDAYHXKJHH,2020-02-24,1.6396,1.6396,4.3003,11.3027,24.3346,58.8606,63.8289,,,,40.5331,63.96,2019-08-14,1,63.96,1.50%,0.15%,1,0.15%,1,'
    ,
    '000826,广发百发100指数A,GFBF100ZSA,2020-02-24,1.5660,1.9260,4.4696,11.2216,23.0165,44.4649,55.6661,85.7651,60.7804,58.6626,35.2332,100.4383,2014-10-30,1,76.3514,1.20%,0.12%,1,0.12%,1,57.3299'
    ,
    '005495,创金合信科技成长股票A,CJHXKJCZGPA,2020-02-24,1.8011,1.8011,3.8158,11.1859,21.1964,54.3491,81.3431,106.6667,95.6654,,36.3334,80.11,2017-12-28,1,96.0701,1.50%,0.15%,1,0.15%,1,'
    ,
    '005496,创金合信科技成长股票C,CJHXKJCZGPC,2020-02-24,1.7769,1.7769,3.8091,11.1744,21.1413,54.1378,80.4326,104.7592,93.1833,,36.2236,77.69,2017-12-28,1,94.2604,,0.00%,,,,'
    ,
    '001480,财通成长优选混合,CTCZYXHH,2020-02-24,1.7820,1.7820,5.0088,11.1666,20.1618,50.7614,58.9652,94.3293,93.0661,113.6691,42.3323,78.20,2015-06-29,1,81.8367,1.50%,0.15%,1,0.15%,1,'
    ,
    '000827,广发百发100指数E,GFBF100ZSE,2020-02-24,1.5630,1.9230,4.4088,11.1664,22.9740,44.4547,55.6773,85.8501,60.8025,58.6802,35.2076,100.0883,2014-10-30,1,76.4108,0.60%,0.06%,1,0.06%,1,57.0552'
    ,
    '004044,金鹰转型动力混合,JYZXDLHH,2020-02-24,1.3143,1.3143,4.5751,11.0989,30.7631,54.2244,49.4542,56.2411,25.0285,,42.4870,31.43,2017-11-16,1,51.9598,1.50%,0.15%,1,0.15%,1,'
    ,
    '001956,国联安科技动力,GLAKJDL,2020-02-24,1.8766,1.8766,3.2347,11.0809,23.8843,56.7360,80.5812,126.2054,72.1493,105.7675,52.1239,87.66,2016-01-26,1,111.2099,1.50%,0.15%,1,0.15%,1,'
    ,
    '167506,安信深圳科技指数(LOF)A,AXSZKJZSLOFA,2020-02-24,1.3204,1.3204,3.7806,10.9580,16.3656,,,,,,30.2684,32.04,2019-12-06,1,32.04,1.20%,0.12%,1,0.12%,1,'
    ,
    '167507,安信深圳科技指数(LOF)C,AXSZKJZSLOFC,2020-02-24,1.3197,1.3197,3.7826,10.9551,16.3449,,,,,,30.2250,31.97,2019-12-06,1,31.97,,0.00%,,,,'
    ,
    '160626,鹏华信息分级,PHXXFJ,2020-02-24,1.0870,2.0110,3.5238,10.7828,19.6207,44.8688,55.7729,75.2445,55.2390,61.0097,33.5196,138.5880,2014-05-05,1,64.7796,1.20%,0.12%,1,0.12%,1,53.8211'
    ,
    '165524,信诚中证智能家居指数分级,XCZZZNJJZSFJ,2020-02-24,1.08,,3.9461,10.7607,19.2563,41.4240,50.3334,60.2894,42.0876,19.5115,29.0633,-29.4153,2015-06-26,1,52.0878,1.00%,0.10%,1,0.10%,1,'
    ,
    '163503,天治核心成长混合(LOF),TZHXCZHHLOF,2020-02-24,0.6329,2.6508,4.5597,10.6856,21.5713,43.9391,45.1273,60.5123,28.7691,31.9091,32.0743,280.5284,2006-01-20,1,54.0278,1.50%,0.15%,1,0.15%,1,19.9768'
    ,
    '270028,广发制造业精选混合,GFZZYJXHH,2020-02-24,3.86,3.86,3.2362,10.6334,18.4776,48.4615,59.4382,86.2934,56.1489,65.2397,33.2873,286,2011-09-20,1,77.2268,1.50%,0.15%,1,0.15%,1,107.9741'
    ,
    '519929,长信电子信息行业量化混合,CXDZXXHYLHHH,2020-02-24,1.2440,1.2440,3.1509,10.5778,22.2004,53.5802,58.6735,80.2899,55.8897,30.3983,41.2032,24.40,2016-07-27,1,69.7135,1.50%,0.15%,1,0.15%,1,'
    ,
    '001410,信达澳银新能源产业股票,XDAYXNYCYGP,2020-02-24,3.2660,3.3280,3.8144,10.5620,23.4316,62.8116,82.5601,120.3779,139.4405,209.9919,41.5078,241.9211,2015-07-31,1,108.4238,1.50%,0.15%,1,0.15%,1,'
    ,
    '002244,景顺长城低碳科技主题混合,JSCCDTKJZTHH,2020-02-24,1.53,1.58,2.2727,10.5491,18.3294,46.4114,44.8863,69.2477,51.4851,39.3443,28.3556,59.9293,2016-03-11,1,65.9436,1.50%,0.15%,1,0.15%,1,'
    ,
    '519113,浦银安盛精致生活混合,PYASJZSHHH,2020-02-24,2.5280,2.5880,3.6490,10.5378,16.2298,40.1331,48.3568,71.3898,32.4947,28.1298,32.0794,166.5391,2009-06-04,1,63.0968,1.50%,0.15%,1,0.15%,1,91.3702'
    ,
    '001468,广发改革混合,GFGGHH,2020-02-24,1.0180,1.0180,3.8776,10.5320,21.0464,42.1788,54.7112,82.7648,43.5825,32.0363,29.3520,1.80,2015-07-27,1,73.4242,1.50%,0.15%,1,0.15%,1,'
    ]
<mask token>
wb = op.Workbook()
ws = wb.active
row = 2
for count_key in range(len(str_list)):
    for col in range(1, len(str_list[count_key].split(','))):
        ws.cell(row, col).value = str_list[count_key].split(',')[col - 1]
    row += 1
wb.save('123.xlsx')

str_list = [
    '004666,长城久嘉创新成长混合,CCJJCXCZHH,2020-02-24,1.6128,1.6128,4.2332,16.3552,24.8297,67.2335,74.6778,88.5213,56.5673,,53.5415,61.28,2017-07-05,1,80.6249,1.50%,0.15%,1,0.15%,1,'
    ,
    '519674,银河创新成长混合,YHCXCZHH,2020-02-24,6.4687,6.4687,5.3140,15.5084,29.0231,79.7810,114.5363,163.5767,144.4062,196.2130,60.5615,546.87,2010-12-29,1,148.7101,1.50%,0.15%,1,0.15%,1,230.4572'
    ,
    '008085,海富通先进制造股票A,HFTXJZZGPA,2020-02-24,1.2496,1.2496,3.5380,14.2857,20.5479,,,,,,25.0225,24.96,2019-12-17,1,24.96,1.50%,0.15%,1,0.15%,1,'
    ,
    '008084,海富通先进制造股票C,HFTXJZZGPC,2020-02-24,1.2487,1.2487,3.5406,14.2766,20.5076,,,,,,24.9450,24.87,2019-12-17,1,24.87,,0.00%,,,,'
    ,
    '007685,华商电子行业量化股票,HSDZHYLHGP,2020-02-24,1.5484,1.5484,4.7916,14.0038,23.6050,57.0067,,,,,42.2508,54.84,2019-09-17,1,54.84,1.50%,0.15%,1,0.15%,1,'
    ,
    '001210,天弘互联网混合,THHLWHH,2020-02-24,1.2587,1.2587,5.4629,13.9301,27.3472,58.3868,74.0218,121.5241,93.4973,109.6087,49.1527,25.87,2015-05-29,1,109.6087,1.50%,0.15%,1,0.15%,1,'
    ,
    '008281,国泰CES半导体行业ETF联接A,GTCESBDTHYETFLJA,2020-02-24,1.5892,1.5892,3.9780,13.8314,27.1869,58.92,,,,,52.8518,58.92,2019-11-22,1,58.92,1.00%,0.10%,1,0.10%,1,'
    ,
    '008282,国泰CES半导体行业ETF联接C,GTCESBDTHYETFLJC,2020-02-24,1.5880,1.5880,3.9743,13.8188,27.1519,58.80,,,,,52.7805,58.80,2019-11-22,1,58.8,,0.00%,,,,'
    ,
    '008326,东财中证通信A,DCZZTXA,2020-02-24,1.1512,1.1512,5.8672,13.5194,19.4191,,,,,,,15.12,2020-01-20,1,15.12,1.00%,0.10%,1,0.10%,1,'
    ,
    '008327,东财中证通信C,DCZZTXC,2020-02-24,1.1509,1.1509,5.8591,13.5122,19.3880,,,,,,,15.09,2020-01-20,1,15.09,,0.00%,,,,'
    ,
    '002844,金鹰多元策略混合,JYDYCLHH,2020-02-24,1.9071,1.9071,3.45,13.4436,23.8216,55.6181,64.5328,91.5721,83.0933,95.9416,47.2778,90.71,2016-08-09,1,84.8144,1.50%,0.15%,1,0.15%,1,'
    ,
    '000534,长盛高端装备混合,CSGDZBHH,2020-02-24,2.3660,2.3660,5.0155,13.3142,25.0529,45.4210,58.0494,66.6197,55.4534,52.1543,33.6723,136.60,2014-03-25,1,60.4068,1.50%,0.15%,1,0.15%,1,63.7370'
    ,
    '007300,国联安中证半导体ETF联接A,GLAZZBDTETFLJA,2020-02-24,2.2479,2.2479,3.7955,13.1417,26.3930,79.9904,102.6961,,,,56.3322,124.7675,2019-06-26,1,124.7675,0.80%,0.08%,1,0.08%,1,'
    ,
    '007301,国联安中证半导体ETF联接C,GLAZZBDTETFLJC,2020-02-24,2.2388,2.2388,3.7971,13.1393,26.3716,79.8377,102.1490,,,,56.2753,123.8576,2019-06-26,1,123.8576,,0.00%,,,,'
    ,
    '290011,泰信中小盘精选混合,TXZXPJXHH,2020-02-24,2.9210,3.1810,4.0242,13.0418,26.6146,57.1275,83.1347,107.3101,87.6044,62.5487,42.1411,241.7285,2011-10-26,1,99.1138,1.50%,0.15%,1,0.15%,1,79.2862'
    ,
    '162703,广发小盘成长混合(LOF),GFXPCZHHLOF,2020-02-24,2.8964,5.2344,4.1683,12.7486,24.8018,59.3442,86.2517,143.0886,110.7546,149.9482,42.6096,1128.3661,2005-02-02,1,129.5087,1.50%,0.15%,1,0.15%,1,154.6522'
    ,
    '007713,华富科技动能混合,HFKJDNHH,2020-02-24,1.3497,1.3497,5.0759,12.6252,22.4884,35.6346,,,,,33.8192,34.97,2019-11-06,1,34.97,1.50%,0.15%,1,0.15%,1,'
    ,
    '007817,国泰中证全指通信设备ETF联接A,GTZZQZTXSBETFLJA,2020-02-24,1.2369,1.2369,6.1170,12.5068,16.5567,30.4472,,,,,22.6718,23.69,2019-09-03,1,23.69,1.00%,0.10%,1,0.10%,1,'
    ,
    '007818,国泰中证全指通信设备ETF联接C,GTZZQZTXSBETFLJC,2020-02-24,1.2339,1.2339,6.1054,12.50,16.5156,30.3370,,,,,22.6175,23.39,2019-09-03,1,23.39,,0.00%,,,,'
    ,
    '210008,金鹰策略配置混合,JYCLPZHH,2020-02-24,1.6672,2.2672,4.7631,12.4814,23.4871,60.0615,68.2681,73.1616,47.9326,53.4045,47.3963,139.2858,2011-09-01,1,65.6762,1.50%,0.15%,1,0.15%,1,53.3982'
    ,
    '001617,天弘中证电子指数A,THZZDZZSA,2020-02-24,1.4640,1.4640,3.9994,12.4424,21.5947,51.8987,61.7858,82.0896,53.01,66.8756,37.2457,46.40,2015-07-29,1,71.9521,1.00%,0.10%,1,0.10%,1,'
    ,
    '001618,天弘中证电子指数C,THZZDZZSC,2020-02-24,1.4477,1.4477,3.9940,12.4340,21.5737,51.8142,61.6278,81.7349,52.3734,65.7545,37.2097,44.77,2015-07-29,1,71.6098,,0.00%,,,,'
    ,
    '320007,诺安成长混合,NACZHH,2020-02-24,1.7670,2.2120,4.4944,12.4046,22.7936,60.7825,102.4056,133.7301,92.2743,69.4152,42.1561,163.9893,2009-03-10,1,117.8791,1.50%,0.15%,1,0.15%,1,67.1712'
    ,
    '008086,华夏中证5G通信主题ETF联接A,HXZZ5GTXZTETFLJA,2020-02-24,1.3165,1.3165,4.7502,12.3965,20.0857,,,,,,31.8610,31.65,2019-12-10,1,31.65,1.20%,0.12%,1,0.12%,1,'
    ,
    '008087,华夏中证5G通信主题ETF联接C,HXZZ5GTXZTETFLJC,2020-02-24,1.3158,1.3158,4.7528,12.3943,20.0657,,,,,,31.8173,31.58,2019-12-10,1,31.58,,0.00%,,,,'
    ,
    '002560,诺安和鑫灵活配置混合,NAHXLHPZHH,2020-02-24,1.5040,1.5040,4.4807,12.0465,23.0971,60.0340,96.8844,100.4264,46.7317,50.7014,42.83,50.40,2016-04-28,1,95.2233,1.50%,0.15%,1,0.15%,1,'
    ,
    '002939,广发创新升级混合,GFCXSJHH,2020-02-24,2.5814,2.6264,4.0468,11.8991,23.8498,57.3161,90.2705,163.0593,114.6714,151.9261,39.8830,169.2838,2016-08-24,1,149.5071,1.50%,0.15%,1,0.15%,1,'
    ,
    '006257,信达澳银先进智造股票型,XDAYXJZZGPX,2020-02-24,1.9582,1.9582,4.3094,11.8971,24.9968,58.8932,70.8130,94.8070,,,40.2320,95.82,2019-01-17,1,94.7876,1.50%,0.15%,1,0.15%,1,'
    ,
    '519642,银河智造混合,YHZZHH,2020-02-24,2.1320,2.1320,4.4074,11.74,23.3796,44.1515,58.8674,89.5111,60.6631,108.2031,39.6202,113.20,2016-03-11,1,80.6780,1.50%,0.15%,1,0.15%,1,'
    ,
    '000063,长盛电子信息主题灵活配置混合,CSDZXXZTLHPZHH,2020-02-24,2.1340,2.1340,3.1915,11.6109,25.3819,47.3757,56.9118,71.1307,24.1419,19.0184,41.6058,113.40,2013-05-10,1,66.7188,1.50%,0.15%,1,0.15%,1,95.4212'
    ,
    '519005,海富通股票混合,HFTGPHH,2020-02-24,1.3890,3.3380,3.2714,11.4767,21.7353,67.1480,91.3223,121.8850,95.3586,137.8425,45.1411,496.9470,2005-07-29,1,107.6233,1.50%,0.15%,1,0.15%,1,81.8063'
    ,
    '007484,信达澳银核心科技混合,XDAYHXKJHH,2020-02-24,1.6396,1.6396,4.3003,11.3027,24.3346,58.8606,63.8289,,,,40.5331,63.96,2019-08-14,1,63.96,1.50%,0.15%,1,0.15%,1,'
    ,
    '000826,广发百发100指数A,GFBF100ZSA,2020-02-24,1.5660,1.9260,4.4696,11.2216,23.0165,44.4649,55.6661,85.7651,60.7804,58.6626,35.2332,100.4383,2014-10-30,1,76.3514,1.20%,0.12%,1,0.12%,1,57.3299'
    ,
    '005495,创金合信科技成长股票A,CJHXKJCZGPA,2020-02-24,1.8011,1.8011,3.8158,11.1859,21.1964,54.3491,81.3431,106.6667,95.6654,,36.3334,80.11,2017-12-28,1,96.0701,1.50%,0.15%,1,0.15%,1,'
    ,
    '005496,创金合信科技成长股票C,CJHXKJCZGPC,2020-02-24,1.7769,1.7769,3.8091,11.1744,21.1413,54.1378,80.4326,104.7592,93.1833,,36.2236,77.69,2017-12-28,1,94.2604,,0.00%,,,,'
    ,
    '001480,财通成长优选混合,CTCZYXHH,2020-02-24,1.7820,1.7820,5.0088,11.1666,20.1618,50.7614,58.9652,94.3293,93.0661,113.6691,42.3323,78.20,2015-06-29,1,81.8367,1.50%,0.15%,1,0.15%,1,'
    ,
    '000827,广发百发100指数E,GFBF100ZSE,2020-02-24,1.5630,1.9230,4.4088,11.1664,22.9740,44.4547,55.6773,85.8501,60.8025,58.6802,35.2076,100.0883,2014-10-30,1,76.4108,0.60%,0.06%,1,0.06%,1,57.0552'
    ,
    '004044,金鹰转型动力混合,JYZXDLHH,2020-02-24,1.3143,1.3143,4.5751,11.0989,30.7631,54.2244,49.4542,56.2411,25.0285,,42.4870,31.43,2017-11-16,1,51.9598,1.50%,0.15%,1,0.15%,1,'
    ,
    '001956,国联安科技动力,GLAKJDL,2020-02-24,1.8766,1.8766,3.2347,11.0809,23.8843,56.7360,80.5812,126.2054,72.1493,105.7675,52.1239,87.66,2016-01-26,1,111.2099,1.50%,0.15%,1,0.15%,1,'
    ,
    '167506,安信深圳科技指数(LOF)A,AXSZKJZSLOFA,2020-02-24,1.3204,1.3204,3.7806,10.9580,16.3656,,,,,,30.2684,32.04,2019-12-06,1,32.04,1.20%,0.12%,1,0.12%,1,'
    ,
    '167507,安信深圳科技指数(LOF)C,AXSZKJZSLOFC,2020-02-24,1.3197,1.3197,3.7826,10.9551,16.3449,,,,,,30.2250,31.97,2019-12-06,1,31.97,,0.00%,,,,'
    ,
    '160626,鹏华信息分级,PHXXFJ,2020-02-24,1.0870,2.0110,3.5238,10.7828,19.6207,44.8688,55.7729,75.2445,55.2390,61.0097,33.5196,138.5880,2014-05-05,1,64.7796,1.20%,0.12%,1,0.12%,1,53.8211'
    ,
    '165524,信诚中证智能家居指数分级,XCZZZNJJZSFJ,2020-02-24,1.08,,3.9461,10.7607,19.2563,41.4240,50.3334,60.2894,42.0876,19.5115,29.0633,-29.4153,2015-06-26,1,52.0878,1.00%,0.10%,1,0.10%,1,'
    ,
    '163503,天治核心成长混合(LOF),TZHXCZHHLOF,2020-02-24,0.6329,2.6508,4.5597,10.6856,21.5713,43.9391,45.1273,60.5123,28.7691,31.9091,32.0743,280.5284,2006-01-20,1,54.0278,1.50%,0.15%,1,0.15%,1,19.9768'
    ,
    '270028,广发制造业精选混合,GFZZYJXHH,2020-02-24,3.86,3.86,3.2362,10.6334,18.4776,48.4615,59.4382,86.2934,56.1489,65.2397,33.2873,286,2011-09-20,1,77.2268,1.50%,0.15%,1,0.15%,1,107.9741'
    ,
    '519929,长信电子信息行业量化混合,CXDZXXHYLHHH,2020-02-24,1.2440,1.2440,3.1509,10.5778,22.2004,53.5802,58.6735,80.2899,55.8897,30.3983,41.2032,24.40,2016-07-27,1,69.7135,1.50%,0.15%,1,0.15%,1,'
    ,
    '001410,信达澳银新能源产业股票,XDAYXNYCYGP,2020-02-24,3.2660,3.3280,3.8144,10.5620,23.4316,62.8116,82.5601,120.3779,139.4405,209.9919,41.5078,241.9211,2015-07-31,1,108.4238,1.50%,0.15%,1,0.15%,1,'
    ,
    '002244,景顺长城低碳科技主题混合,JSCCDTKJZTHH,2020-02-24,1.53,1.58,2.2727,10.5491,18.3294,46.4114,44.8863,69.2477,51.4851,39.3443,28.3556,59.9293,2016-03-11,1,65.9436,1.50%,0.15%,1,0.15%,1,'
    ,
    '519113,浦银安盛精致生活混合,PYASJZSHHH,2020-02-24,2.5280,2.5880,3.6490,10.5378,16.2298,40.1331,48.3568,71.3898,32.4947,28.1298,32.0794,166.5391,2009-06-04,1,63.0968,1.50%,0.15%,1,0.15%,1,91.3702'
    ,
    '001468,广发改革混合,GFGGHH,2020-02-24,1.0180,1.0180,3.8776,10.5320,21.0464,42.1788,54.7112,82.7648,43.5825,32.0363,29.3520,1.80,2015-07-27,1,73.4242,1.50%,0.15%,1,0.15%,1,'
    ]
import openpyxl as op
wb = op.Workbook()
ws = wb.active
row = 2
for count_key in range(len(str_list)):
    for col in range(1, len(str_list[count_key].split(','))):
        ws.cell(row, col).value = str_list[count_key].split(',')[col - 1]
    row += 1
wb.save('123.xlsx')

# -*- coding: utf-8 -*-

str_list = ["004666,长城久嘉创新成长混合,CCJJCXCZHH,2020-02-24,1.6128,1.6128,4.2332,16.3552,24.8297,67.2335,74.6778,88.5213,"
            "56.5673,,53.5415,61.28,2017-07-05,1,80.6249,1.50%,0.15%,1,0.15%,1,","519674,银河创新成长混合,YHCXCZHH,"
                                                                                 "2020-02-24,6.4687,6.4687,5.3140,"
                                                                                 "15.5084,29.0231,79.7810,114.5363,"
                                                                                 "163.5767,144.4062,196.2130,60.5615,"
                                                                                 "546.87,2010-12-29,1,148.7101,1.50%,"
                                                                                 "0.15%,1,0.15%,1,230.4572","008085,"
                                                                                                            "海富通先进制造股票A,HFTXJZZGPA,2020-02-24,1.2496,1.2496,3.5380,14.2857,20.5479,,,,,,25.0225,24.96,2019-12-17,1,24.96,1.50%,0.15%,1,0.15%,1,","008084,海富通先进制造股票C,HFTXJZZGPC,2020-02-24,1.2487,1.2487,3.5406,14.2766,20.5076,,,,,,24.9450,24.87,2019-12-17,1,24.87,,0.00%,,,,","007685,华商电子行业量化股票,HSDZHYLHGP,2020-02-24,1.5484,1.5484,4.7916,14.0038,23.6050,57.0067,,,,,42.2508,54.84,2019-09-17,1,54.84,1.50%,0.15%,1,0.15%,1,","001210,天弘互联网混合,THHLWHH,2020-02-24,1.2587,1.2587,5.4629,13.9301,27.3472,58.3868,74.0218,121.5241,93.4973,109.6087,49.1527,25.87,2015-05-29,1,109.6087,1.50%,0.15%,1,0.15%,1,","008281,国泰CES半导体行业ETF联接A,GTCESBDTHYETFLJA,2020-02-24,1.5892,1.5892,3.9780,13.8314,27.1869,58.92,,,,,52.8518,58.92,2019-11-22,1,58.92,1.00%,0.10%,1,0.10%,1,","008282,国泰CES半导体行业ETF联接C,GTCESBDTHYETFLJC,2020-02-24,1.5880,1.5880,3.9743,13.8188,27.1519,58.80,,,,,52.7805,58.80,2019-11-22,1,58.8,,0.00%,,,,","008326,东财中证通信A,DCZZTXA,2020-02-24,1.1512,1.1512,5.8672,13.5194,19.4191,,,,,,,15.12,2020-01-20,1,15.12,1.00%,0.10%,1,0.10%,1,","008327,东财中证通信C,DCZZTXC,2020-02-24,1.1509,1.1509,5.8591,13.5122,19.3880,,,,,,,15.09,2020-01-20,1,15.09,,0.00%,,,,","002844,金鹰多元策略混合,JYDYCLHH,2020-02-24,1.9071,1.9071,3.45,13.4436,23.8216,55.6181,64.5328,91.5721,83.0933,95.9416,47.2778,90.71,2016-08-09,1,84.8144,1.50%,0.15%,1,0.15%,1,","000534,长盛高端装备混合,CSGDZBHH,2020-02-24,2.3660,2.3660,5.0155,13.3142,25.0529,45.4210,58.0494,66.6197,55.4534,52.1543,33.6723,136.60,2014-03-25,1,60.4068,1.50%,0.15%,1,0.15%,1,63.7370","007300,国联安中证半导体ETF联接A,GLAZZBDTETFLJA,2020-02-24,2.2479,2.2479,3.7955,13.1417,26.3930,79.9904,102.6961,,,,56.3322,124.7675,2019-06-26,1,124.7675,0.80%,0.08%,1,0.08%,1,","007301,国联安中证半导体ETF联接C,GLAZZBDTETFLJC,2020-02-24,2.2388,2.2388,3.7971,13.1393,26.3716,79.8377,102.1490,,,,56.2753,123.8576,2019-06-26,1,123.8576,,0.00%,,,,","290011,泰信中小盘精选混合,TXZXPJXHH,2020-02-24,2.9210,3.1810,4.0242,13.0418,26.6146,57.1275,83.1347,107.3101,87.6044,62.5487,42.1411,241.7285,2011-10-26,1,99.1138,1.50%,0.15%,1,0.15%,1,79.2862","162703,广发小盘成长混合(LOF),GFXPCZHHLOF,2020-02-24,2.8964,5.2344,4.1683,12.7486,24.8018,59.3442,86.2517,143.0886,110.7546,149.9482,42.6096,1128.3661,2005-02-02,1,129.5087,1.50%,0.15%,1,0.15%,1,154.6522","007713,华富科技动能混合,HFKJDNHH,2020-02-24,1.3497,1.3497,5.0759,12.6252,22.4884,35.6346,,,,,33.8192,34.97,2019-11-06,1,34.97,1.50%,0.15%,1,0.15%,1,","007817,国泰中证全指通信设备ETF联接A,GTZZQZTXSBETFLJA,2020-02-24,1.2369,1.2369,6.1170,12.5068,16.5567,30.4472,,,,,22.6718,23.69,2019-09-03,1,23.69,1.00%,0.10%,1,0.10%,1,","007818,国泰中证全指通信设备ETF联接C,GTZZQZTXSBETFLJC,2020-02-24,1.2339,1.2339,6.1054,12.50,16.5156,30.3370,,,,,22.6175,23.39,2019-09-03,1,23.39,,0.00%,,,,","210008,金鹰策略配置混合,JYCLPZHH,2020-02-24,1.6672,2.2672,4.7631,12.4814,23.4871,60.0615,68.2681,73.1616,47.9326,53.4045,47.3963,139.2858,2011-09-01,1,65.6762,1.50%,0.15%,1,0.15%,1,53.3982","001617,天弘中证电子指数A,THZZDZZSA,2020-02-24,1.4640,1.4640,3.9994,12.4424,21.5947,51.8987,61.7858,82.0896,53.01,66.8756,37.2457,46.40,2015-07-29,1,71.9521,1.00%,0.10%,1,0.10%,1,","001618,天弘中证电子指数C,THZZDZZSC,2020-02-24,1.4477,1.4477,3.9940,12.4340,21.5737,51.8142,61.6278,81.7349,52.3734,65.7545,37.2097,44.77,2015-07-29,1,71.6098,,0.00%,,,,","320007,诺安成长混合,NACZHH,2020-02-24,1.7670,2.2120,4.4944,12.4046,22.7936,60.7825,102.4056,133.7301,92.2743,69.4152,42.1561,163.9893,2009-03-10,1,117.8791,1.50%,0.15%,1,0.15%,1,67.1712","008086,华夏中证5G通信主题ETF联接A,HXZZ5GTXZTETFLJA,2020-02-24,1.3165,1.3165,4.7502,12.3965,20.0857,,,,,,31.8610,31.65,2019-12-10,1,31.65,1.20%,0.12%,1,0.12%,1,","008087,华夏中证5G通信主题ETF联接C,HXZZ5GTXZTETFLJC,2020-02-24,1.3158,1.3158,4.7528,12.3943,20.0657,,,,,,31.8173,31.58,2019-12-10,1,31.58,,0.00%,,,,","002560,诺安和鑫灵活配置混合,NAHXLHPZHH,2020-02-24,1.5040,1.5040,4.4807,12.0465,23.0971,60.0340,96.8844,100.4264,46.7317,50.7014,42.83,50.40,2016-04-28,1,95.2233,1.50%,0.15%,1,0.15%,1,","002939,广发创新升级混合,GFCXSJHH,2020-02-24,2.5814,2.6264,4.0468,11.8991,23.8498,57.3161,90.2705,163.0593,114.6714,151.9261,39.8830,169.2838,2016-08-24,1,149.5071,1.50%,0.15%,1,0.15%,1,","006257,信达澳银先进智造股票型,XDAYXJZZGPX,2020-02-24,1.9582,1.9582,4.3094,11.8971,24.9968,58.8932,70.8130,94.8070,,,40.2320,95.82,2019-01-17,1,94.7876,1.50%,0.15%,1,0.15%,1,","519642,银河智造混合,YHZZHH,2020-02-24,2.1320,2.1320,4.4074,11.74,23.3796,44.1515,58.8674,89.5111,60.6631,108.2031,39.6202,113.20,2016-03-11,1,80.6780,1.50%,0.15%,1,0.15%,1,","000063,长盛电子信息主题灵活配置混合,CSDZXXZTLHPZHH,2020-02-24,2.1340,2.1340,3.1915,11.6109,25.3819,47.3757,56.9118,71.1307,24.1419,19.0184,41.6058,113.40,2013-05-10,1,66.7188,1.50%,0.15%,1,0.15%,1,95.4212","519005,海富通股票混合,HFTGPHH,2020-02-24,1.3890,3.3380,3.2714,11.4767,21.7353,67.1480,91.3223,121.8850,95.3586,137.8425,45.1411,496.9470,2005-07-29,1,107.6233,1.50%,0.15%,1,0.15%,1,81.8063","007484,信达澳银核心科技混合,XDAYHXKJHH,2020-02-24,1.6396,1.6396,4.3003,11.3027,24.3346,58.8606,63.8289,,,,40.5331,63.96,2019-08-14,1,63.96,1.50%,0.15%,1,0.15%,1,","000826,广发百发100指数A,GFBF100ZSA,2020-02-24,1.5660,1.9260,4.4696,11.2216,23.0165,44.4649,55.6661,85.7651,60.7804,58.6626,35.2332,100.4383,2014-10-30,1,76.3514,1.20%,0.12%,1,0.12%,1,57.3299","005495,创金合信科技成长股票A,CJHXKJCZGPA,2020-02-24,1.8011,1.8011,3.8158,11.1859,21.1964,54.3491,81.3431,106.6667,95.6654,,36.3334,80.11,2017-12-28,1,96.0701,1.50%,0.15%,1,0.15%,1,","005496,创金合信科技成长股票C,CJHXKJCZGPC,2020-02-24,1.7769,1.7769,3.8091,11.1744,21.1413,54.1378,80.4326,104.7592,93.1833,,36.2236,77.69,2017-12-28,1,94.2604,,0.00%,,,,","001480,财通成长优选混合,CTCZYXHH,2020-02-24,1.7820,1.7820,5.0088,11.1666,20.1618,50.7614,58.9652,94.3293,93.0661,113.6691,42.3323,78.20,2015-06-29,1,81.8367,1.50%,0.15%,1,0.15%,1,","000827,广发百发100指数E,GFBF100ZSE,2020-02-24,1.5630,1.9230,4.4088,11.1664,22.9740,44.4547,55.6773,85.8501,60.8025,58.6802,35.2076,100.0883,2014-10-30,1,76.4108,0.60%,0.06%,1,0.06%,1,57.0552","004044,金鹰转型动力混合,JYZXDLHH,2020-02-24,1.3143,1.3143,4.5751,11.0989,30.7631,54.2244,49.4542,56.2411,25.0285,,42.4870,31.43,2017-11-16,1,51.9598,1.50%,0.15%,1,0.15%,1,","001956,国联安科技动力,GLAKJDL,2020-02-24,1.8766,1.8766,3.2347,11.0809,23.8843,56.7360,80.5812,126.2054,72.1493,105.7675,52.1239,87.66,2016-01-26,1,111.2099,1.50%,0.15%,1,0.15%,1,","167506,安信深圳科技指数(LOF)A,AXSZKJZSLOFA,2020-02-24,1.3204,1.3204,3.7806,10.9580,16.3656,,,,,,30.2684,32.04,2019-12-06,1,32.04,1.20%,0.12%,1,0.12%,1,","167507,安信深圳科技指数(LOF)C,AXSZKJZSLOFC,2020-02-24,1.3197,1.3197,3.7826,10.9551,16.3449,,,,,,30.2250,31.97,2019-12-06,1,31.97,,0.00%,,,,","160626,鹏华信息分级,PHXXFJ,2020-02-24,1.0870,2.0110,3.5238,10.7828,19.6207,44.8688,55.7729,75.2445,55.2390,61.0097,33.5196,138.5880,2014-05-05,1,64.7796,1.20%,0.12%,1,0.12%,1,53.8211","165524,信诚中证智能家居指数分级,XCZZZNJJZSFJ,2020-02-24,1.08,,3.9461,10.7607,19.2563,41.4240,50.3334,60.2894,42.0876,19.5115,29.0633,-29.4153,2015-06-26,1,52.0878,1.00%,0.10%,1,0.10%,1,","163503,天治核心成长混合(LOF),TZHXCZHHLOF,2020-02-24,0.6329,2.6508,4.5597,10.6856,21.5713,43.9391,45.1273,60.5123,28.7691,31.9091,32.0743,280.5284,2006-01-20,1,54.0278,1.50%,0.15%,1,0.15%,1,19.9768","270028,广发制造业精选混合,GFZZYJXHH,2020-02-24,3.86,3.86,3.2362,10.6334,18.4776,48.4615,59.4382,86.2934,56.1489,65.2397,33.2873,286,2011-09-20,1,77.2268,1.50%,0.15%,1,0.15%,1,107.9741","519929,长信电子信息行业量化混合,CXDZXXHYLHHH,2020-02-24,1.2440,1.2440,3.1509,10.5778,22.2004,53.5802,58.6735,80.2899,55.8897,30.3983,41.2032,24.40,2016-07-27,1,69.7135,1.50%,0.15%,1,0.15%,1,","001410,信达澳银新能源产业股票,XDAYXNYCYGP,2020-02-24,3.2660,3.3280,3.8144,10.5620,23.4316,62.8116,82.5601,120.3779,139.4405,209.9919,41.5078,241.9211,2015-07-31,1,108.4238,1.50%,0.15%,1,0.15%,1,","002244,景顺长城低碳科技主题混合,JSCCDTKJZTHH,2020-02-24,1.53,1.58,2.2727,10.5491,18.3294,46.4114,44.8863,69.2477,51.4851,39.3443,28.3556,59.9293,2016-03-11,1,65.9436,1.50%,0.15%,1,0.15%,1,","519113,浦银安盛精致生活混合,PYASJZSHHH,2020-02-24,2.5280,2.5880,3.6490,10.5378,16.2298,40.1331,48.3568,71.3898,32.4947,28.1298,32.0794,166.5391,2009-06-04,1,63.0968,1.50%,0.15%,1,0.15%,1,91.3702","001468,广发改革混合,GFGGHH,2020-02-24,1.0180,1.0180,3.8776,10.5320,21.0464,42.1788,54.7112,82.7648,43.5825,32.0363,29.3520,1.80,2015-07-27,1,73.4242,1.50%,0.15%,1,0.15%,1,"]
# youdata = mydate.split(",")
# print(youdata)
import openpyxl as op
wb = op.Workbook()
ws = wb.active

row = 2

for count_key in range(len(str_list)):
    for col in range(1,len(str_list[count_key].split(","))):
        ws.cell(row,col).value = (str_list[count_key].split(","))[col-1]
    row+=1

wb.save('123.xlsx')
##一组二十五个数据

# for i in range(len(mydate)):
#     list1 = mydate[i]
#     name=['1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25']
#
#     test1 = pd.DataFrame(columns=name, data=list1)
#     #print(mydate[i])
#     #mydate[i].to_csv('C:/Users/15400/Desktop/data.csv',encoding='gbk')

# list = mydate[i]
# name=['1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25']





