要实现的是将所选行导出。例如勾选这两条
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAw8AAAAxBAMAAABuaoilAAAAAXNSR0IArs4c6QAAABtQTFRF6/P/////zc3NAAAA8/Pz+Pj44ODh7e7vuLm7wFLXEAAABWpJREFUeNrtXMGO1DgQtdrSLMdOW1o4pvuAOLrk/QDQ9IjrIi134DBcAaHdK+xpPhu7ynbcndjudhwyIFeinkQTJ3a9evXK7qjZf4Ptu8BOTnK265a7+irblz11X+H+82zLAiA+d83Wsi3bDXbYxU4q234xO5Q99eLBLuaVLXs7WM8COznJ2WZ71dVsMevLntpXuP9cC4D4u/wuW9asHhCNEY0Rzc4ZcXN/f/+uMWJ1Rtz8fzgcXnwqYYTEnevt9zYu9TCZUkouyYgnH/V84ktfwgiCAD+57qb6TRnBFZPchV1Nu9N2q8znnWbEEzOx+/cb/UtjjjsnrwYHo7DfOud7RqxFDJ6IAJ5sRi3pgMfdbP4liRGpZ11tR21/6U2bYYSWiPsP3wh7xt1OHRgOmBoxguhAkWIw4cnY5Bf4powRMuZC/VSVbEYt6UBKGaMOt5fhk+QiQLwMgWBJICYYYYFwsZT28FJAMJZKGTzTTPoDGcXMBJmSTiMqA3G8PU4wAr2KvsWkZICw2WmUmjwj7KZ7mWaE4bUZDasseX087DcJIKgZtcQDzlmaEcxdWxcIJMQ5I7xfWSDDNrBiGoFklcSMDCOIO4+UEUymNII7XtRmBBFixAiJzpcjIMb+C+YR0rs5oxEaNi7rawRLaATPNAuAiGhcj+Wr9KBW14jjpEZYXfCFaUiP8czaIsWzQHhZX2LWIcsYcSbWnEevVXgbzNHVxVqpyaoJUzj3iZyqWcb4OLUbjeCujJAXaATDIlGpumnW1vkpZUo0w6o1U772hiqIAM+UymUa4RmxwZn1u4KZtQkhKUkp+IrziOUnKtyMk1cfXwCEZsTNi4eHh+cla02mBgoK11Q19GuvNSla5ai+xnHKCPaHnllfv9TUVl/n2+vB+uJ1xrb6Ot++Dvay/C6NEbMteIujMWJNRgRAfGqMWNE2gx02sZOs7a66ul/MDmVPvXiw13nlCjv5Yqi96bfmm34BEG/aC3crvunXGNEY0SzBiKfuZeTGiFUZ8Scu+hVRA3AXesubvUqcttfN8QuXxx27pofQuQGIhRjxDF+n2ZcwgjqFnyLtTn01mEvsKOzIwEI5a2w/gRHQ2YirDETwOo0mwjN8nea7xR7MLoxfh1M8EGM/W+f7roksfwbAwDMCNCbzxiaU2SPB7EaQaKY7gH2AeM/BdBOjR29QC4jgLQ7DCPxi6Dtir31q3GoClwJV+KA/7+eus/+hqDa9FMnYFILGQe0CIGYzAn0Dk0/1I5hqJqgDdKDvAVFG6J47RkA1SmztMjgC8SoEwnveeYqSjjuAcdonIBxGIqsRIDo3+A7BBjEbCPQORMI5DoQNIKIpMbNLMgLZ1QmAroOaQKjjBCMs4Oh+YUJcb+AOumlG2C2dYFAjhIPAfgKGcoZLl+RwFYFy5wuKqWbKZzTAYxG/PyYlYa4AqCURSUZ4vwbCNLh7WiMov9hwT2ZyEmu6DHkAxoUg5pMdokEq4nQbMhq4s4S6OfYulJrOGQEXA7E77WcGCB+bYkhNTiNmAmF5HONhLJHsR0BEeOk0QmF6MN1dQqxHGnEOhEgwwiMlskB0ThMBwTgBAoQQc/lQQIgTINDBIiVBg1hD1dR0O6kRpkZ1FexZ+TqlEc6zxrl5jbBicA6Ezk4zNUJneqUiVZN+5PT8Zm/LV+qMcIViqmpy4VRXrMk0I3Y4s35fUr+TeCk3UctUTT4HdFXL1+XNMkF4JVwACA33U43D4fmbgpk1+EAUljWZOa4ihSbdVvQ5e4lj+Zk14ODA5VallmFE94/+e9cWQ1dYfQ1ep2nfR6y5+hq8TvOqBeaKjGi/TtO1X6dpFgDRfp3mcfw6zQ8ckQSG96eR3wAAAABJRU5ErkJggg==" alt="" />
导出为aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA0oAAAA5CAIAAACH5kxIAAAeDElEQVR4Ae1d/2tcV3Z/EwL91RJO85NDZY+8TeKEIrutkXabH4RLZFPqpLZL6iym/WG07cJKsOSXYIgMob+YgJQSWgnaYnbdhdh1XUqkUONAuh2TLYpYEsVmLSmC+CevjeX/YHruO2/OO+9+e29m3nvzvtxhmDn33PPlns89c++d+741zl+d8NwrFwQ+OvVZLn7q6+Sbb755+eWX6xt/XpE7nPNB2uHscM4HgXy8uHzOGeeGW97lgzh4+bvf+4fcfDlHDgGHgEPAIeAQcAjUFoFnaxt5/oFP/c5k/k7r5fFYw1vv1CvkoUTrcM4HdoezwzkfBPLx4vI5L5w7HTEPiuXd1e99mY/Teno5/5uj9QzcRe0QcAg4BBwCDgGHwFAQeGYoXp1Th4BDwCHgEHAIVBKBhWOX4J1DaLk5yiEW5yJ1BNzB2dQhdQYdAg4Bh4BDoL4ILKy/hwsvIEwoWNZ/Fi3JWhJHkoor1gcBcWlFGQ/O4m8DfwacLmDP0cHZ7HBWEVA5aSGTneUUWpjNuR1phZzcTnJJAI0LczoFPE0mssHZ5K1XPoKAWvaZMjlcqqTK6bWd8fJZ4pxH+7sRJvelSqqcrtX0vrPBOUnLSUYipNgojVFMqtUWSUXUtm8szH395Kc//vCt/UgL5pvnFt59URDide/tYx+PogAy8PPBL3/yxmejEUle3SOdDc49NiIUJ8xDVmJqEN3ETvoVPNYIz73r10aaevasjWSq2a1qJKGi2WQJaihqIDBelYNhEN8elRY01NVWSdaSeEliRzJbhKIlNAl53tqSBstDyJS2oKr1S3jacxLEQEC8zTsoWvucqbpQOVy+RHQSfDBYbVCDoKoaVFFVOapWhTkEr9QFxMfYk6H0+PV//trzXmnD2g6Wa7jO+/69n7zx8duvvffzKWHpwC8+b3qv/BcISK8DL95/9bPjNz5//YcvfnpAqqtRUcU5yc9n6AAV6+CslLuAjpTciBcxiQD+9M1fBbX+aM6rkF+xTx4g4gYcYqpIYvhf//Uf/fuPZ0xQkLpJIAnf5Bp1U3GRpBlZyBDOYJzC5BEBE4sqQe0hebJAVUiEAoMtTSSzhS2qOBCG9jYjyCCsWrArJq9FF+HY4p9QlZ275A1LRTIWQIyUuoMTSPNmDAILtqSqOHOUtLQKplYMmNQFCWlhp/0/x7+CvboXxRWU3z0a9bztF/Z7B/Y/8bzm5/e8KdjAu/faBw+f/PSM7hLL/d+ceP74Vw+P/+zep+FWn7Ba9hdhTgRFpGYy5udffLTGZ09VjCwUhCjW8i4hKIg1CCO+2D23T//xD97/NKGFyoipGaZyeLCv/Ov/wZtzktCRMSWNTZEkTismw5NWHVAo2AjU/nrd3qGk6AgVgVSgQyM4tqgGeVeqtWqTqsSheDkIfQdYMZwBk1t//+cn3v1PIAgoEzggkBBDlOTCRKMXLHKPRz+HrTvvydhzJu/GrTtf4cH3X37ywcPRG/eOvusvEE1WSsWXQMO2q9CpMZGiWgUcDrtWIGdmKZd3OWNUJXf23bvBI7Vn/y8vvj64i9wsSLEk+fFT2yRd4BOHCBImQnJBQ7k6akiSZIETSWS4fEHonpqNyKCK1H7OVAGUhLVFbgEFkANpzFd7yOzPhdZvMZkqGmm1U7VcZ5xjUYVM4ylnort27r14Q5BPYMcOXi88B5t2o9899l54LLbxXrNv3QkN3Ocb9X773AOgfU6ZPyjZEEYo4i+Xw8jjIz6KRXbvCr+XX+7lHXWV2h+cU2GaEEi+ciIVLSyYxLyK8puY0g+D+ECo6rwW6BLtsFIsHAFOS6HxIkKk5ahVIEadgk7JCwpTkQwSH+WJX16CEMAQpGLANJxFJ4GgwtUfLGhWbUllDhRAaFnsMPWKduVxjgVEzTGLCk9vojkBdPiLeCCWcZ73/OMXfJMHfvDh0qOFuY8WPhCXVnw4ZT7rLmzBc49f9ZpfPTz8v48/VU/OC8XKQYXI+LOVwKp7CxteRcEAE2W0tSRWTKLkyzvdaXbYDdRnxcQ9rVapwaqBS3nJiyjMOVLDTAKgAlXibZhxJTuVLEL4N//xfMLQEEkQJgIVqWhCEvkghpImMakZPQlLukMsQnS85UQjQQ3jxb43pMkIECZUUYa3Sgh35wNqjyMsCBBcAjrDcIEylcEZw2n/6R/AW0RtDhxxo8AJRrRARSKQL8mTMDoSn7LH331EG29Tby6sv9k1SGfdPX79bz4Sp+jBlt5ScL1FV2b/o6bn+VVdTum/CTGIBHMSQcPAkFP6IPGpFcUJg4NenFaVqyWUrNBsbZqqIHMOV0E+ceSieYXHDRJ6ZIc4pSO0CGhx5gjYA7fXEkSqGHDAC52NTpJ1IAiNoEeyWW9J3Y3AIuywrD/9t1dBgFpSedgRjSzCdDirqFJeSbCHfGWhTJIkI8z611Ko9pFDZ90d+MU/Hf/q+S/+40ePfnbpz+ZuHF1/U3eZhclMafgEEbQ4ghIrggyJoUzwWfhDsWo3FGv3TkJc9IF14LbXqtE6DiGgpqwEJhbVHiELQEAtiJkkSVeyzC2UiNaGSTFKgSAyAiJ7ArMxWmtfMpuwmKKphB5TF7PjJrnDXqCok+iSMJgCWrxZX6B94nBhIe9LnvaFpCpULMUntjyLHSYePscHaPGuOs48ZIAC4jUFTkChihBW8FHhIi0kyJ1eEk+2k3SCIm3deUd3H8KdU2CH77djz3tVOc1ODZogwh5RBZBDYloB6qxAmI3wdkWttUyZxVre9RoqommBu1eDpZOXYk/efq7IabIgZSrKSEwQVjlkoRoEgaNNNorRhAPXMsmQEYkg18jvSb0nYclvEYoct17bA7oAnXgrK4meTMn4d8fxAc321IYiCxMOElC9tllSpyLZ79VgKeQpTGgtbgYDgSFjFdBEYERcRYpRW8UA1FwYQVt3kiml+Pi5bcELLs5QqsvLkNCGQLQwEj+Q744qUu8UEIdyL++0gPI+0wpUicl+wEmvWuAq/SVof1qlgx3DpJGXt1/FkNdyGg6e8qsseVUszb1ohVFAvVolVlFrrT5MKYEBLuCId3fgRiiwyIWRplpeVS70pJabEOBBUexAaIHiwgFE/oKYhE1eUIA3iXyBHdRCQnVRNA6PgtqmDVyKCzeDSQUJSRGKkgAUtR5DMbwv8VcP938nXfcabt2BcLhp193GCy14j/aLE++6F2ewijqQPBVLF2/5lnccbhNdum7IrcHa+95xGKEl6iCCAsSXBp3cGp+zI4pXO/LaG0OQ0lWWxCFFsk8cRxACKlxUpRIgnPzKcVXdwsFm1LaneC/Q/xxEg5AhwgJjbFUqRmK9ZC3QaxTavOrVSFxQwYUR4mYoU+FDKaStuwdvnfni1kfH37gE1raXoifeBdfesosz4lyWpR6hxtZymrefZzvnl4J+phSt5I0EuPkbq+h3QgRXqR6tDgEqR4oaBOAmCMDcPfX7BCDKIGifLJ6VVILa6F9wrYyWCR7xra2tJBN7AULjeUhoE1HJ2NMNCrFKYhNv0w3LaBQOss7f55j671+rGYh9xDsIFLFI3Sf5DVSiPwQSJkLSKmwxCCe6FaRFgFAC4td/2NRGpFUEyeReyGygUk6ctfGGofloowwxkxAmeJPoosyXr70CxOjuI67y4K0fwfWz7PqJ/Z/+SzCx4mPKQmG8OAMfehFyq0ABtggvBMPpKsTmx1C+3TuEnn5Lolf8ZURhu+Tq9770CvkoZULMMuhQFRGkBYRAPjpJRGq7VVpdLlkZ2oJGZWIsWiBwYxRY4VGO2bsAxbQywBT5HE1plEQ+BK5VLBog9vZYENAqakOONWIRqCTOlngJVQocOFpUBT+6tCXdgYipP/ni1a+P9/vYCf+hF89/8UO4AbJ7lQyBxvmrE2L9MewXprWpFdKPQf0NcA7Q0nEEk9kc+Od/c5R7SQVqHiwaj+WQABCwe3fl0l/yVgENfNi9OzV/TdDdZZnJuJ2PteonuMi8X9JeRqttBo4aGnAk0ARHGalVaySmtallgiNTG7TywkW0Q01iPfDTxlk00gAsb5UlEBVtbhMVtTLcPqlwR6glpS43xWnJ2qDFtHGObapdgGqJoAA5h9MkIBGqDHKqgbMU7PCL7RsLc18rN7RL0q57bx/7uPnmuYVUHjibdj4nCUArg8mmrQIm//mjjF2e21F1eW1O9LFGp9MBX2J5l5PL+rmBxVwWyzsJSHWgBAEtE/na5Z1FRXI3SNHUqkFsRnQzGD6kNktF8K5ysElavpYZCaEUhexxlmDoGzdSJEKyrBZJEgkQoCEbONITyVCdVFRrA3FSxTlhI9WoKQSqAg5hgrVknAjSMhEkSWbJJnDKi7MpXscvzlEsyj2pU0x8SazoRbe8y6GHrp7fkFbPwMnBr3PhEHAIOAQcAg4Bh0A9EWi32xB4Wc+9K0WfdTrLb//bMm8qcHjR0eki0GjMOoTThVRrrXFplvM777ms5nikRjucU4PSasjhbIUntUo3PqcGpdUQ4Dw5OQkiz/78ryIjtVXLVToEHAIOgQgCbm0XgSOzgsM5M2gjhh3OEThcocwIuN27bHsPV89F+NfSaLQ6nRUercrBWs7nNNetFc1B4LQWhFgBrZaFyQ1ymlSASbRKSJ2uCgzCcXPhIOgl13U4J8dqEEmH8yDolULXMlpqh0rtkMsj5QKc5jLDorNZ3m0fmxqfuCNi2lvcujbXxOgOzTam/fXF7mrn1kwkYqiaeAkl1040To5FKlu3O8s7EY6nMxUqcqdcT9EKVbpiGl/dqpJ/Q+7y5ON0r5GBrklF+wsxCZeFr0IntbzXqFMH0NQAiyMphD6KhZ4Lw582Gw3041IfoeeqUmictZBqmbli1o+zoeI8ujR1Zt6fMicXr7fnnogAKIcnN7ba68EsGolMmdHETYnPjs+P8JlXcO5uKHNoxFCtCtrRMtOhcljwZrG8OzQ7PnFkdaUNKzhI0PETh/3F3Nrs9Obi9c7ck7XZ1snZQyzbMEf3FhGDmVv+Jb1+QQwTY+fekdZ2nsYUSJ70VjsrYtXInHJYNVoJfHEL5aUpd4mAWJDW5ro9UpMKN263ULpaDBkCNMXOIzLhQLpEgFZCm9y+lpacchda+QGZQ50L49quHw3041KcrSHXFxpn+JutGeq1zCHDGOt+uDivzZ6Z9za2OutNMeVNL526NufBjDbWWl1ZnvFXbFOeusLTzGjbxy7MP13tXJuBSfDCsVNiUXjosuDIc2gsIHUQ0I690kAKOEgcPrRyC0hzztAxzGB5t3ZwBf5t4O7czLctb+L+tjfTPHRzZe/clvhTMvPOxuT4wbXlHRDBvxqTrd3JlX0KFqNLFya8xevdzT+q15lqrrfFfV78V+i0yxHfOq2w3uQrlCg7xZOSYpESF/hSdoKWxFFV0JrWPjmqAIE4qOHzwCWseNSqIq8dnObNGNxajIUFz9M8/TJGKb9q7WiwpR2X8mtUP54Wio2zdqh3OPfc02JuWtzy9+dE6q4LA2sjdyY3rvjTaHNuozU/8cn2enQqNMxok3vjrAHbSxObi7fdpU8MEkHSaIwEHzw5jZISRzKFRRr5QZhorWSezAyWd7Alhms7Hsf2yKb39DTuLzf3jnhj/prP8w7DX5Yd8ZdFXd6tHZ2/s7va9repk5jqykBCr3hPV9FXl+mZGoACJl+kXj/ClKNJcr1iaCEUFDgRECZUUbASYrzIaZK3E3YVe63dcq1qw9GgqRuXaoVF6sFqh3otM3XXVTLI5yZjXCN3tzyPT2pci6ZUUL8zEgge2YOtu9n5pxc7yhxq9FKXChzDY0dREABETGJYqwqAcZNKzvhmsLxjEcDusdjJg6TcZlxGNmdMm8ajS++PwVkI6kKRaSuk2NmGc/7gn5B0bp8iGWH05StioSIFbVKqyUppTWHzFQ8xK0NoEVBDVjmEgKWKZCRCdUoCajepPQLCfTglF1UgzKNBOC5VIc5CxKCFVMssRHML1Ygt2Kjb85bONsQ5cx4ekPXG9ybvTFxeW4eDsx7skgI/SZub61cWz46LRQlMgjtwcMxt3amw8dGS05IkDrP8kwsQH5jqWF2QsTfD5R3k1knac+bAJKG3D358Z+/clR7/dvg72+KAb/eEvySuvP58JTJdICFLHmMrMV9VGjj29I21XCAU+m0KIkDgAEFRc9yQL/22JYHkTeBOSUtrDT1ilVaA1GtEGEaDgcalGsHXQ6haSLXMHozWSvTOxPvnrndgm038Jzm7JK4yXG+vjjROtsTFiK2Nxcmxu8kAac5d68yhaLB1J052F1bUKxqTWayclDQ+Y3wwbPJApVEUh2KuyGmuCLSkK9XmWcxqeSfWWPMeu2y2x6DEH5rdK7Dt5798a+KfjcjRrT2fMH7gmQpw8Hf8E7yGKE4r6stot8wVllyksOwy9loyUmECEFB/typHRUCrqIppOajLq1xHcDRiaRoNZvzBZNBxKdZf/QS0kGqZ9cMmecS7F/Fq2ea35yYnguOw4ZV/cF3t2Ev8lLoEhoOz7mC9uCku2oDdwfHIFY0JTFRXBMZtHhwfVLGKc1CShmK1ikyZdEkgZ+KZLPxpftvi5IB9sOQSL/+kgcPdpZu2AWs3xzxx6kDwEv9IOiv++9ZMYlMJtSRfXZ+V/eaZzWkKGJiUwVoBkqwtYYKFQ8fBATxNKlxsEFpynbW7QZo6LF3NuDSsplTFrxZSLbMqEWcQBxyHtVsVx5eeyjNmzDwoLpgVS0bYvPCNNw8/9TZHDCdJ2d1Xs7a7ohAbm/yFfM4h2lIFMjgCgwzJD53IYHknrs1W9+12TrdG5i8fgoDXLk/caX1rPalu9P6m1zptOi1PZwquA2+cWPPhFCdTT+6eorVhgLFOS1TZfQXKZf/CyR4/If9o7uc0xog5SvGqAiQGkvgm4QoThBiFzAnCZFi/bWgMuTZ1WYV7Rw5NOxroxyVZ1ZV7QEALqZbZg9H6iTbXL7bG3l8aFZH7F/mdhtkRdt0aZ5f85ZhhxjTNaMKMv3X3pZhku2vH7fv7+I6JEKr3Cwdw+LTDQOOqXQxquWSs2VhrqQg8m4oVbkTkIly+M96a73LxXNGZ5dutxnRjZdo/CcC0dEOdkbv4j6NrQfrWmJq5tRWcUgqycJKB5iaQGi1hN8aX5LoaRUxEvibAuDAp1dRUJXkqVwMTSxQUvho1VYG6Wstt2mu5ZB+0ZFwq9mGw3Cq60cA0LpU70qG2Xgvp6Zv68X+oLS2685nl6/enzjT8KROmS7EsExdJjI3jNCpua4wzprj78d2L4mZ48DLMaFDjb93hBbOwdjzSGm9MJJh2hc1qv2i4to+QKEbCKlEWlBruEew5dNVwH0pG2QmRAs3jtWc5SXILxCSCbCa0RoqpE3nijFGbQrbUElym8NFmQjEwYpc0tdDkPQk/T5yTtKeqMg7nfHrW4VwHnGGc1A6GNH7SwEtipKISiBjxoUh2sIqM5IMt9+Lns7gPsFvecViyot3wkRWyUbsO5ygeWZUczlkhG7XrcI7ikVXJ4ZwVslG7DucoHlmVfJzF8i6Dc++yarOz6xBwCDgEHAIOAYeAQ8AhEI9AI17ESTgEHAIOAYeAQ8Ah4BBwCJQBgXa7Dc10B2fz6Cu3KZ0HyuLsh1l3LmkOUDcuzXIvw30cO29JxWiHcz4d6nDOCWc3PucCtDs4mwvMzolDoOoIuLVdPj3scHY454OA81IZBNy5d5XpyphApOt6QFrloAnO53SMA1ddPwTcmiOfPnc4O5zzQaBWXmB2wwnOMs2hjPRZFpSyWd6JWzLiPW+DGzP6cByaDZjB/YcFUycJNz1naDLhEFSNqXgtna+uSTDIm9plV+gbrtPmSQx031dus94J7mxMnAoB5kKJQaA0aw5xl2N1OIqJrjjVpcE5gKysY+kwcdamqJYZyUvLPBhOZ2JmnBUPFHAvQgAHBChKkyDwSYYIkOFv4gdEfDfJGrmV07+tMdxTcXZ84sjqShtuvQiRj5843LklyNnpzcXrnbkn4gnHwcPv9JJbd0fwTsgmFHSmvDgtvS/fBfxIple8vUWTv/LzKWuJgJiQlvI7SawmFW48iZ16yEB2TbwknhHeU7j9afXkYiDhYc6FPTUc/tSd9FY7/q1i2XDUk40hCpcG5wCjso6lw8RZm6JaZjQRNfOgeGTI09XOtRlI9QvHTrXh9v7iFserHftzBKJ2a1DCKUydsIAPTGmCU8VChBJ0UyicO5XB7t3awZXJjXf822p7M9+2gkfNHrq5snfu1BMIcOadjcmVg+IBYnpJeErYnvXxyTpT4tliVi29L3h4C+wUTm+2dmOe+pd7x6TuEFJWfatepOTGdOdiIKB9cxlHVxyBhfLE11xv+38vRYvD4agk7V8oSTv9ZpZ4LB0uztoU1TIj6aCdBz1vcm+ciYVPJ2NMR1oQkNZ2ICnNmxHd+G6KiOdcyGD3buZWB9d2PJTtkU3v6WncwBDPQh67v+3NaCX9p4RtXmjNi+eS7S2q2x5aU03xbDGblt6X5x3e2OrsNGENvrKPt9fR0jqPAFGzn6ocoSCAmxnw5MezXpDJ4rFCfm7Do/PErrZ4QfqNi0c5wcvft1a1/Dr3MRgC4mnU3tPV3rZRB3NZK203lg7c3doU1TI97TwIDbgzsgWPNAPiyB5s3c3OP72ITycbuG2VMQBTG8VCNBFQJc1xvIoUVULfTapcjpwMlnes9bB7DDt5W5Br/qORWY1MMklYCHrnrqy0m2Jrbbx7bFdWkMoi15Nqhb7gZzDjdq1DKCGPpcyGOuBIfDXdVa3QaK2pnWW4eTg7OLs2e2b+yO1Oe0fkdnCKwujShbFzWyLhxckM7x97Z2Zd0qo1hKkEHyyg4e9id0mdillnhCHgxlIGRu+kNkW1TItt8aTas+Ni+QKpLgaZzcXbyxb5WlbRbEXzGhEqHiSsVoWcXrsp1MyWynB5B7l1cgWSDA7/x7wikmK3cx0VmnMbrfnpm2uwzxdjAR7AnFAr4ivOapXq1TWZFB1PcU6DmLrC40kfa1lyVOOiOJ4Cwy4g0Dy1Ozl/cG15x0/tkfnLh+aWdzzTHnONIUsndH98gN9+0r+L6Xh1VhwCiRHQpqiWaTXZnLvWmUOJYOtOnOy+Ahx2uMBqoc6VfOKLndfCSbD3bsoH5KyWd2Iknfc0h1aVsKySey9Nendh709YG/FVd1e39hQbEkOn5R8Is/qSjFSqGCaiOSy7jL3WbNXVSAiMzI+35gPenjhFoflkrn37bmO6sTIN7MnF6+05cYqqe6WOgP93ccLHPHXbzqBDIAUEtCmqZcY6g2OFYusONpY24QSkdS88XBCrWiMBaT3HpzlOAyJcUgtQf92kNZUWM4NLK4LVWHRtJ8632wcDq3j5Jw0c9vf04tZbcEaduGBC/CMJrgy4NWMwxRDRaWlbxXTqQ/I/JZwmBHgeawVI0hG9IwC7d3SNC11OC8dwfebq7p35o+KqI/dyCDgEHAIWBGLmQXHB7EX4o7g1gif1Ng8/9TZH4k6SsvirWhVObbiGg08+6/FQ+QwINL25TGHpDJZ34trs6NpORL9zuiWOQAG1dnniTutbcUxKKwmnHzWCe935J8ntnpIP7upMxWppfYmG1eKFOYqfmMoYNqeRAzKY8SYBEitXomOzh/0Zpq44zS7Ic7iQIrxJlXTh27AbXH7/Ic5wEGBiZVIdT8ofo4ug1AhoU1TLjIQZDibhlNoV8LfuvhST7Pge3hRi+/4+/2KLrkSNv3Hm4tMczowICaclkECF3kFVfDdJNnItpn9wVqQaXL4THoHCiwG9meXbreAIFJwEIE4/Mkje2gpODgURkNScuqeagpOW7FoGX7liXRxnmNmQxzzFoXmY2Wp+q5KSYnFCK15L4FQBcUD27urK8gz/FcA23jX/xLud5dWDjeD3Asxb/t+ZiFbxgipPi+JGhvJE4lpaUQS0KapleuK6+7sXxUgCL808GCDkb93hBbPN9YtHWuONCX8yddcRCoCkyYtmNyICFLsHZFU+CcQuPELJYVAN9wj2HGAf7qPueXYCzeOVEp1XcZpb4HykyWZCa6qFtDjDxTmtKIpvx+GcTx85nB3O+SCQj5dC5TNOW9KcxZl81qM5jgMl6fKq4dI+znDLBi/93bvhBua8qwjwLOS0Kmni2LXstSabju8QcAg4BBwCDoGhIKCdtjjTRA+ltf05zeDcu/4a4rQcAg4Bh4BDwCHgEHAIOATSQKCRhhFnwyHgEHAIOAQcAg4Bh4BDYPgItNttaMT/A6weemypSMCPAAAAAElFTkSuQmCC" alt="" />
我的前台是easyUI实现的。所以前台代码为：
{
{ id:'btn_export',
text : '导出所选行',
iconCls : 'icon-print',
handler : function() {
var arr = $('#dayrec').datagrid(
'getSelections');
if (arr.length <= 0) {
$.messager.show({
title : '温馨提示!',
msg : '至少选择一行记录进行导出!'
});
} else {
$.messager.confirm('温馨提示','确认导出?',function(r) {
if (r) {
var ids = '';
for (var i = 0; i < arr.length; i++) {
ids += arr[i].id+ ',';
}//从前台取得所选行的ids,拼接成字符串，传入后台
ids = ids.substring(0,ids.length - 1);
$('#downform').form('submit', {
url : "<%=basePath%>dayrec/exportSelected",//交给指定的url处理，后台可以接收到requestparam ids
method : "post",
onSubmit: function(param){
param.ids = ids;
},
error : function() {
$.messager.alert('温馨提示', '导出失败');
},
});
$('#dayrec').datagrid('unselectAll');
} else {
return;
}
});
}
}
}后台处理逻辑为：
@RequestMapping(value = "/exportSelected", method = RequestMethod.POST)
public @ResponseBody String exportSelectedUser(@RequestParam String ids, HttpSession session, HttpServletResponse response) {
List<Object[]> dataset = dayRecruitService.exportByid(ids);
String[] headers = new String[]{"日期","所属公司","招聘企业","面试人数","入职人数","入职率(%)","备注"};
if(dataset == null || dataset.size() < 1){
return "没有查找到相应的数据,请刷新数据后重试";
}
response.setContentType("application/vnd.ms-excel");//;charset=utf-8
response.setHeader("Content-Disposition", "attachment;filename=dayRecruit.xls");
response.setHeader("Pragma","No-cache");
response.setHeader ( "Cache-Control", "no-store");
try {
OutputStream sos = response.getOutputStream(); ExportExcelsUtil.exportExcel(headers, dataset, sos);//如果不需要额外数据exportExcel(headers,dataset, sos)
// ExportExcelsUtil.exportExcel(2,1,2,"用户信息",headers,dataset, sos);//如果不需要额外数据exportExcel(headers,dataset, sos)
response.flushBuffer();
} catch (IOException e) {
e.printStackTrace();
}
return "成功导出"+dataset.size()+"条用户数据。";
}
DayRecruitService的逻辑：
public List<Object[]> exportByid(String ids) {
List<Object[]> objList = new ArrayList<Object[]>();
List<DayRecruit> dayrec_list=dayRecruitDAO.findById(ids);
if(dayrec_list!=null&&dayrec_list.size()>0){
for(int i=0;i<dayrec_list.size();i++){//循环遍历查询到的数据结果列表 将每一条数据插入到对应行单元格
Object[] obj=new Object[7];
DayRecruit rec=new DayRecruit();
rec=dayrec_list.get(i);
if(rec!=null){
obj[0]=rec.getDate();
obj[1]=rec.getCustomer().getOrganization().getOrganizationName();
obj[2]=rec.getCustomer().getEnterpriseName();
obj[3]=(rec.getViewerNu())==null?"":rec.getViewerNu();
obj[4]=(rec.getEntryNu()==null)?"":rec.getEntryNu();
if(rec.getViewerNu()!=null&&rec.getEntryNu()!=null)
obj[5]=(Math.round(Double.parseDouble(rec.getEntryNu())/Double.parseDouble(rec.getViewerNu())*100))/1.0+"%";
else
obj[5]="";
obj[6]=(rec.getRemarks()==null)?"":rec.getRemarks();
objList.add(obj);
}
}
}
return objList;//返回了对应的一行一行数据
}DayRecruitDAO后台逻辑为：
public List<DayRecruit> findById(String ids) {
// TODO Auto-generated method stub
log.debug("get DayRecruit instance with id"+ids);
try {
List<DayRecruit> list = new ArrayList();
List arrList = new ArrayList();
if(ids == null || ids.trim().equals(""))
{return list;}
StringBuffer hql = new StringBuffer(
"from DayRecruit where id in(?");
String[] id = ids.split(",");
arrList.add(id[0]);
for(int i=0;i<id.length;i++){
hql.append(",?");
arrList.add(id[i]);
}
hql.append(")");
list = (List<DayRecruit>) this.getListByHQL(-1, -1, hql.toString(),
this.toStringArray(arrList));
return list;
} catch (RuntimeException re) {
// TODO: handle exception
log.debug("get failed",re);
throw re;
}
}其中涉及到的hql语句模板是
public List<?> getListByHQL(int nStartRow, int nRowSize, String strHQL, String... strParams){
//log.debug("HQL：" + strHQL + "\n Params：" + ArrayUtils.toString(strParams));
Query query=getSession().createQuery(strHQL);
for (int j = 0,i=0; j < strParams.length; j++) {
if(strParams[j]!=null) {
if(!strParams[j].equals("")){
query.setString(i, strParams[j]);
i++;
}
}
}
if (nRowSize > 0 && nStartRow > -1) {
query.setFirstResult((nStartRow-1)*nRowSize);
query.setMaxResults(nRowSize);
}
//log.debug("BEGIN：" + DateUtils.getStrOfDateMinute());
List<?> objList = query.list();
//log.debug("END：" + DateUtils.getStrOfDateMinute());
return objList;
}
此处还涉及到了工具类 代码为：
import java.io.IOException;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import org.apache.commons.collections.map.ListOrderedMap;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFPicture;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor; public class ExportExcelsUtil {
/**
*
* @param dataset 数据
* @param out 流
*/
public static <T> void exportExcel(Collection<T> dataset, OutputStream out) {
exportExcel(0,0,0,"sheet1", null, dataset, out, "yyyy-MM-dd");
} /**
*
* @param headers 标题
* @param dataset 数据
* @param out
*/
public static <T> void exportExcel(String[] headers, Collection<T> dataset,OutputStream out) {
exportExcel(0,0,0,"sheet1", headers, dataset, out, "yyyy-MM-dd");
} /**
*
* @param headers 标题
* @param dataset 数据
* @param out
* @param pattern 日期格式
*/
public static <T> void exportExcel(String[] headers, Collection<T> dataset,OutputStream out, String pattern) {
exportExcel(0,0,0,"sheet1", headers, dataset, out, pattern);
} /**
* 导出数据
* @param colSplit 需要冻结的列数目，如果没有传0
* @param rowSplit 需要冻结的行数目，如果没有传0
* @param dataBeginIndex 数据从第几个字段开始导出，每一条的记录，如果没有传0
* @param sheetName 表格名字，sheet1的名称
* @param headers 标题
* @param dataset 数据
* @param out 输出流
*/
public static <T> void exportExcel(int colSplit,int rowSplit,int dataBeginIndex,String sheetName,String[] headers, Collection<T> dataset,OutputStream out){
exportExcel(colSplit,rowSplit,dataBeginIndex,sheetName, headers, dataset, out, null);
} /**
* 这是一个通用的方法，利用了JAVA的反射机制，可以将放置在JAVA集合中并且符号一定条件的数据以EXCEL 的形式输出到指定IO设备上
* @param <T>
*
* @param title
* 表格标题名
* @param headers
* 表格属性列名数组
* @param dataset
* 1.需要显示的数据集合,集合中一定要放置符合javabean风格的类的对象。此方法支持的 javabean属性的数据类型有基本数据类型及String,Date,byte[](图片数据)
* 2.或者Map,key是string类型，value属性
* @param out
* 与输出设备关联的流对象，可以将EXCEL文档导出到本地文件或者网络中
* @param pattern
* 如果有时间数据，设定输出格式。默认为"yyy-MM-dd"，目前不需要
*/
@SuppressWarnings("unchecked")
public static <T> void exportExcel(int colSplit,int rowSplit,int dataBeginIndex,String title, String[] headers,Collection<T> dataset, OutputStream out, String pattern) {
// 声明一个工作薄
HSSFWorkbook workbook = new HSSFWorkbook();
String sheetName = (title == null || title.equals("")) ? "sheet1" : title;
// 生成一个表格
HSSFSheet sheet = workbook.createSheet(sheetName);
try{
if(colSplit != 0 || rowSplit != 0){
sheet.createFreezePane( colSplit, rowSplit, colSplit, rowSplit );//冻结首行(0,1,0,1)；2,1
}
// 设置表格默认列宽度为15个字节
sheet.setDefaultColumnWidth((short) 15);
// 生成一个样式
HSSFCellStyle style = workbook.createCellStyle();
// 设置这些样式
style.setFillForegroundColor(HSSFColor.SKY_BLUE.index);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
// 生成一个字体
HSSFFont font = workbook.createFont();
font.setColor(HSSFColor.VIOLET.index);
font.setFontHeightInPoints((short) 12);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
// 把字体应用到当前的样式
style.setFont(font);
style.setWrapText(true);//设置自动换行 // 生成并设置另一个样式
HSSFCellStyle style2 = workbook.createCellStyle();
style2.setFillForegroundColor(HSSFColor.LIGHT_YELLOW.index);
style2.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style2.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style2.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style2.setBorderRight(HSSFCellStyle.BORDER_THIN);
style2.setBorderTop(HSSFCellStyle.BORDER_THIN);
style2.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style2.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
// 生成另一个字体
HSSFFont font2 = workbook.createFont();
font2.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
// 把字体应用到当前的样式
style2.setFont(font2);
style2.setWrapText(true);//设置自动换行 // 声明一个画图的顶级管理器
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
// 定义注释的大小和位置,详见文档
//HSSFComment comment = patriarch.createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5));
// 设置注释内容
//comment.setString(new HSSFRichTextString("可以在POI中添加注释！"));
// 设置注释作者，当鼠标移动到单元格上是可以在状态栏中看到该内容.
//comment.setAuthor("leno"); // 产生表格标题行
HSSFRow row = sheet.createRow(0);
for (short i = 0; i < headers.length; i++) {
HSSFCell cell = row.createCell(i);
cell.setCellStyle(style);
HSSFRichTextString text = new HSSFRichTextString(headers[i]);
cell.setCellValue(text);
} // 遍历集合数据，产生数据行
Iterator<T> it = dataset.iterator();
int index = 0;
while (it.hasNext()) {
index++;
row = sheet.createRow(index);
T t = (T) it.next();
if(t instanceof Class){
// 利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值
Field[] fields = t.getClass().getDeclaredFields();
for (short i = 0; i < fields.length; i++) {
HSSFCell cell = row.createCell(i);
cell.setCellStyle(style2);
Field field = fields[i];
String fieldName = field.getName();
String getMethodName = "get" + fieldName.substring(0, 1).toUpperCase() + fieldName.substring(1);
Class tCls = t.getClass();
Method getMethod = tCls.getMethod(getMethodName, new Class[] {});
Object value = getMethod.invoke(t, new Object[] {});
// 判断值的类型后进行强制类型转换
String textValue = null;
if (value instanceof byte[]) {
// 有图片时，设置行高为60px;
row.setHeightInPoints(600);
// 设置图片所在列宽度为80px,注意这里单位的一个换算
sheet.setColumnWidth(i, (short) (35.7 * 400));
// sheet.autoSizeColumn(i);
byte[] bsValue = (byte[]) value;
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 600, i, index, (short) (i+1), index+1);
anchor.setAnchorType(2);
HSSFPicture pic = patriarch.createPicture(anchor, workbook.addPicture(bsValue, HSSFWorkbook.PICTURE_TYPE_JPEG));
pic.resize();//这句话一定不要，这是用图片原始大小来显示
} else {
// 其它数据类型都当作字符串简单处理
textValue = value.toString();
} if (textValue != null){
HSSFRichTextString richString = new HSSFRichTextString(textValue);
HSSFFont font3 = workbook.createFont();
font3.setColor(HSSFColor.BLUE.index);
richString.applyFont(font3);
cell.setCellValue(richString);
}
}
}else if(t instanceof ListOrderedMap || t instanceof HashMap){
//HashMap<String,String> map = null;
ListOrderedMap map = (ListOrderedMap) t;
Iterator<String> keys = map.keySet().iterator();
short i = 0;
while(keys.hasNext()){
HSSFCell cell = row.createCell(i);
cell.setCellStyle(style2);
String keyname = keys.next();
//此处根据keyname生成标题
Object keyValue = map.get(keyname);
String textValue = null;
if(keyValue instanceof byte[]){
// 有图片时，设置行高为60px;
row.setHeightInPoints(300);
// 设置图片所在列宽度为80px,注意这里单位的一个换算
sheet.setColumnWidth(i, (short) (35.7 * 200));
// sheet.autoSizeColumn(i);
byte[] bsValue = (byte[]) keyValue;
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255, i, index, (short) (i+1), index+1);
anchor.setAnchorType(2);
HSSFPicture pic = patriarch.createPicture(anchor, workbook.addPicture(bsValue, HSSFWorkbook.PICTURE_TYPE_JPEG));
//pic.resize();//这句话一定不要，这是用图片原始大小来显示
}else{
textValue = keyValue.toString();
}
if (textValue != null){
HSSFRichTextString richString = new HSSFRichTextString(textValue);
HSSFFont font3 = workbook.createFont();
font3.setColor(HSSFColor.BLUE.index);
richString.applyFont(font3);
cell.setCellValue(richString);
}
i++;
}//end while(keys.hasNext())
}else if(t instanceof Object[]){
Object[] object = (Object[])t;
//忽略前两个id字段，之后可以作为参数传入
for(int len = dataBeginIndex;len<object.length;len++){
String textValue = "";
if(object[len] != null){
textValue = object[len].toString();
}
HSSFCell cell = row.createCell(len-dataBeginIndex);
cell.setCellStyle(style2);
HSSFRichTextString richString = new HSSFRichTextString(textValue);
HSSFFont font3 = workbook.createFont();
font3.setColor(HSSFColor.BLUE.index);
richString.applyFont(font3);
cell.setCellValue(richString);
}
} }
workbook.write(out);
out.flush();
out.close();
}catch (SecurityException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (NoSuchMethodException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalArgumentException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InvocationTargetException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
// 清理资源 } } }