EXCEL读写NPOI--导出功能

时间:2023-12-14 14:41:50

第一步:将NPOI中的一下三个文件复制到项目中

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdwAAABCCAIAAABy2vAlAAAatklEQVR4nO2dd1xT5/7Hmy477+2v42p37bq1Q3tvh9XaW+1Sa3FURcVR66xFxQEKahEVN0vQClWWgCwZYYaZhEAYCSvskcFIIJCQkE0S8vz+SC83JSfJISRw0Of9el68jifPeZ5zzvP9fM43j+ec3HcyNAcWWGCBBRaMlPsABAKBQDADNGUIBALBENCUIRAIBENAU4ZAIBAMAU0ZAoFAMAQ0ZQgEAsEQCKYcQtPhG7Wp9erkWlVStTyxUppAG4wvG4grEdym9MWQe6OJ3FsFXZG5nPBsVlhmW2h66w180x/JDSF3GMEJNb/HVl2LoV2NKg+MoF4JKz5ylhCfVjvxBwaxLTAqIIaQSCQajdZQ39RQ3zL+UltTl52dXV1dPdmHhQkQTPl6qVq/oNPphoeHtVqtVqvVaDRqtVqtVg8NDalUKqVSqVQqFQqFXC6Xy+UymUwqlUokUvGgRCQeFAyI+4VivkDU2z/gdiYriy3YfTgkPAbfyuyQK1Q63cQeIsQWwKiAGKI3ZS6XJxYNjr90c/n0qsYrgVcJBMJkH9nkg2DK14qVurFLRAeAVgfUWqDSAKUGyNVAOgQGVcDVK61IDk7EcVzcw1IyClkcrkIJFTj1gFEBMYREItFo9IGBAZu0NihRsNi9pWUVR44coVKpYrHYJs1OURBMOahIPjw8PKZWTGlPrASHPFMJ/cCNBJwjWS5HbqZmEFmcbqjAKQeMCoghJBKJRqseGBDZpDWlaqivf6CqqppCoeDx+Ht8HgPBlANJUo1Gg74JM9obUICDJ5KTOOCXPLApG2y6wdx/OCQ1oxCNAu+77z74105/rQAjUQHBCLbNlDVarVQqq6+vr6lh1NU1BgeHpKWl2aTlqQiCRK8UiNVqNcrtzWtPIAcHPBKjGsGmbLA6A3ybCr4Patt74BpU4CRinS/DqIAYop9TtpUpAwBUKlVLS0tbG7NfIGpnsnbv2kWlUkUi22TiUwsEfQbkCoeGhtBsbFF7fXLgciQuhP6n9uYmgtlxYL5Pi/O+qxYVaHVOB7EHGIkKCEawhykzmUwul6vRaCVSRTuTnZ2dXVFRYav2pxAIxuef3adSqSxuiUZ7vTKw73DM6gyACwE4fznubD/uOAd3sPGF3cQ9e6+kZ5O6eXy12uSX4vv+ytgObOz1Efuy+tow0g5im1Ycka2wrl+sRQUwGjLzJ3lMsYTZscMOJBKJRquy1ZwyAECpVDY2NnI4nOHhYbVa09cvqqlp9vcPzM7ORrO5/aJiVMtmFmwVFQit+GX0KBQKM9voABjWodIeTwouXcm94J9zzifr7KVM7wvpZ86nnTqHP3gw9VfnG2cuXadXN8jkyH0ZnrjxH6dF7NHdfWbNfWoJGyNRocd4sEYtmDrz6M/53TR29mBMpqzVauWKoX6RlMMfaOoSNnUOMLsH+4UyueJ/372USmVNTQ2Dwejp6enp6WGyOiqrmgqJZA8Pj8rKSjT3Y9gvKkZtbmzKaBpBD0JDPmlcuVyOWFuhBr6ZTJezN1ev37Rz506L2uNKQNcgKMgH2QSQng6Sk0F8PIiOBuER4OSZ5F37PfOIVJFYYv5eqwkWwF1vytb1i6moMFTFqIOCpjwxjGn6QqVSd3YNFFa2BRPKj8WUnIgsD4hjFJayOrn/83SlUkmn0wkEQlpaWlpaGh6PT0lJTU5OTklJSUhIoNFoFnuxX1RMvilfTu2SyWSjViq1Sr6Cz5doTtzI23bgpIODg4ODgy9JJlbpzGuvQwzYIsAaAO1C0CoAzQJQWA5CbwLP03c27nDLzCELB8SI8jNztKa+gCBWGLXS/Lkb9Slis2i+pyDukvm+MA5GokIPovxMKWSspnz3jZ09QG/KHYIBQn2DNyHZIyvKjRC9PTFjc3jpT8HNhyPbfZObk4ua2N1CuUKl0Wj4fD6Hw2lra6uoqCguLqZQKLm5uQQCITc318vLq6CgwHxH9o4KxI4myJQvJXGkUqnhmniJ/yHuD7uZ35aLydWMhjPnLjk7Ozs6Oi5Pv7id7Plu+ivuNA+U2mvsB4UVIDQMnDiV6LTdNYNAMi8/46M1dRkEZk80ynNnUX5o2kGzPxb3xH5Y1y+mosKiJKyWH8bHDjuguSVOpVbzROKUplIPYtimtPN7C66cKIvenZe7OpHx7Y3uJYEdjgGVB2/kpxU1tHfwVSq1VqsFAGg0Gh6Px2KxmEwmg8EoLy8vKipKT08PCAgwv0v2iwrE+sYXAIuNoAShoQsJzMHBQcM1WxsWHuY5OHMW44URLBYLj8d7e3uvX7/+s8K3Zme/+hZ+xkt3nnkj+l+lHZpeKeBJQbeB9pgDoM1Ae/V9oLAChEeAY14J5uVn8cxaZ8rmzgVSnbvPlK0DI1GhB5rypIPm4ZHeQUl8WfXP5JNfl6/8nR+QLyKSe5gXqju3k/p/yJD8GNe/PqJ+241812sZibn0vn7x0JAaADA8PGz4+D6fz6+trSUQCJNoyoj+O6GmfC62ddS0+ovBT7vyHPZyluCFkYbym1f41oeE1/6Z/sIrSc8+6/vu4TSJRe3V8QGRBiIigIdn/KRkymg6GmfGjXFhW9cvpqLC/NCDccvP4lbQlEkkEo1WaZgpq1RDAoGwoaGVwWhWKlUSqbKE2bAGf2Ju8fLlHId8RSRHVd86KA3tlO2rUS4rVK1MFP6cQTlICdpLOOaTdyO/ok4glnK5vWWlVSxmh0j0Z7AplUo+n08ikVCaMuKC8T/tasrjDA+Ejc/GNOvv2dbq1ILh7lJxwSnhhiM9y/d1LE0b+Iv85hPf/jBnpl5+M2Kf+yL2t5CGhPYBpRnt1fSCQhqIugXcT8RZzJRHMeqjUdUM1xtvYrzS1KemGjezBs3OG+8n4k5iFoxEBTAacYB6uBHH10z7d83Y2YOROWWNRqtQDAkEIjarq6a6vrCgpJhCk8uVzK6+G2TC88FLXyL8ZzX7p0JBMlPMrhcNh/QP72nWLSaqf4jr30lK/a3L2bl98UHKXt9UPKevr72dg8fnkYlljNqmHh5fLBpUKVUajYZKpZo3ZftFxaihN2zfuC+bBAbCxt63GvQXwKieQD/VT+ckTp7CNYjye+zytEcDHp527aEnwh6ZEffU36Memxb64G/lvma0V90DCukgOhocPX4bZaaMKe4CHVp3CDAqIIaMmLJcruJ0CnNzS29FJEVFJtfWNCrkSq12OJdev+eP8Gc8tvzDb+eCZO9zpfhbDe1h7VrnruFlDN2CbPV3ob1bcyOP8pbvEr6zgbZ4e8Llhl62TKbgdPSkpuRGhCXejk6tKKvu4fHRmPLdBII+T0fUCQQCAIC/YH/A0Nbz0o1eA47u/JUuXd+f6toxIj/HDY64kzjcWRzuMg4XhHsi4hG9/BbFn0hv1prSXiUPEOkgJga4HYtBOaeMHe7l/AgjUQHBCPrpCy6Pz+HwcnKoaWmFOQRydVVDf79QXyE0m7ro6PXnNvtO3xv+rneWQ3DF5sSuzXnKb6jqeQTt3AjVwkvc5fHB6xoWfsua8XHunC+C99O6mjUarUymaG1hUYoq8Km5aal5ZaU1vXwxkVR0T5vyqdCa/v5+AMDc6I8WEd/byPhiRH67md/+3uodmXXT1f/ArN/eevLSoy+E/98/wv/+zK0nZ8Q99cC1+++/ilsUdiKkQmNKezQuIFaC2Fjg6h4F5TcpWHdRgVEBMUT/8EhnJ6+lmX0nMTs9vYBKreRwukViyZBaMzw87H+H/OG2kBeW4p9fTX1lV/1b7vXv+7XPieieHS/81w3ZJ2dl8w53fn7lj7mExf8kvv58+Eezzu6hsprUGq1crurtFdTVteTmUhLjM/LzqJwOQUEheeJN2cvLC/2n5iuPCSRT/qOyr69PB8DaW444TxzOC7eY9KFH36qD3cv2sL7b2rLQkTHPgf7xN9TZC8jvfJT3+nuZL7+eOv2hgAdxnjjcCdyi30/4FmtMaa+iGxArQVwcOHzk1pTLlO9lMBIVEIygn74QCAQSiYzF5hIIRaGh8VeDIotLqoQDEo1GG5ZG++7X2Fe+SXt+GfHFnykve6a/7Y+fcz3748DyuSfZc38Z+LdT5yyXlFcvuc24vOlFD+f5BwNpLR3iQUVLG+/27Yzg6zFRkcmkwlIWs0OhUBUXl0xKpmxotYguPLLSeMFqEIzP63oFn8/X6gBbyF8afPLzK78eYC07ZiC/dXXzV1R+srhszn+KZn2a/+b7WS+/kTr97ej31/icXH1o77aTV/0oSlPaK+sCxCoQHw8OukWilJ/Fg/T6LxaroWkETVNTGuuudndfVKAc8XshJKxgZE5ZrdFIZQoWs7O0tBKfmpuVRaJV1CkUSmI58/A50mvzMp/+LvZZl2vTY93fLvCYW3Tuq4ywRVfzPz/QMGdj03u7qO8cT33L49ZnR2O2n85uYPZzONysLEpSUk4OgVxb09jVyZMMStHMKY+MkcWFMfmAMaPqgL+6s03iBEGfJ6+V9fT06N9gQGgb9uYeOy1ef7z/x+0tiz7JenNN9Wfr/yu/V+OeeyXu2Q+yX3kLP8M7q+rQxVvrtuxwcHA4ey3GlPaonYBYBRITwYHDEWgyZTQnEXHZuBr6diDGYCQq9NgkKtCMOMrougcxfqJPLpezWZ2kwtLCAqpcLmd3iG7Fts6en/PUd9eecHf5O2XxzI6ln/Y7fct0/YpwZb5f0gf7iR/uY3x6hD33UJPT6dqgiLoOnqStlZ2SRKBV1HK5vSMto/yPvlG2aGzKYCyDaHHoR7Vpwys3gil7BpbweDyVBig0QKYGH4TO3t/x/dbmhQ9eegB3HPeU3+Pr6z9fUfnJ54XvLAt6/ljE2+7J77x659mKxk63U/7rNzitWLHCyf1aRKW6viKYEvk1tTTdUHslnYBUBZLugP2Hwm2SE6GXDTRlPdZlyndfVEBTHg/GD49otVqVSiWRSCUSqVarlck15fT+dVsorzuEPLTT+f7E+U80zH1+cNEsxeoPeFs/oLnMivD78FLBF7/xvjnCPHa9jVLeIRIrlEqVSDQok8kN3xOLZVM2lU2PBwR9ngigcLlcvfYkQ2DL7R24MzicN+4B12n/vnD01bPfOzUsWFX96TLKbHb0VxKigyh/sTDnK4lEQiQSfXx8nJycLhx4vz3utZaYFxqjnmUkzjXUXlEHIFWDpGSw70AoyjnlCTNlW53TuxKMRMUIKIfJ4pcn8yMOTdkUxg+PjEKj1XF75LfjW7e4Zs/c4POQx5oHYr94tPbj/+teML3rm5fqfpwZ5zHnUsKSYw1HgtqS87m83kGVCvlXFNDfEjdqvOxnymYixy6mfMyX1N3drdfeoAqIlGDmqTefPvbG4TTh/mTx9oSyp64//rc/Hv2Hz7SCo7Msyu+ay3s3aeoR7ZE5gFQDUlLB3v03bT57aKtc+O6Wn3WZ8pSLCpR1zNeEpmwKNC8kGhpSC4SDUbEtjr9kztzk+TfP1Q/HfXQ/ec4jZfOeKVrxdtTxhZdjdp8rT81lcTpGP649PKzTDuuGh3VgHKY86i8Y4yCO2tbieiu6QARBnx6XCzs7O0e0J1QAgRzE12nPFKry2tS1PD7ODYc7jnvm0AO8pCVSkoMofwmC/OJntt5+sSnquUzf992zZCPaI7IBqQbgU4Hzvhs2yZQNgaZsPzASFSOguVSjPzpoymMFjSnrX1ff0SkiEFvd/bKXnD352oXvHw7495OBP/wz0GNDcMKlhLIcCqu7Z1CpGv2bBhqtTjWk047FlBH9196mPEHTF+4X8jo6Ogy1x5cBw3fKVBWeZBBWdBf+qKCskZKWiwuWCnO/NpSf96+zGsJfaoiYXhf+dH3kU7Vhj5XffJ5IukVkgwIWINeAtDSwxznE5vIb5/QF+h6nNNZlylMrKsaaR0NTHisWpy9GUCqHevjiElpHHJkSUBDjRfzdmxgTSCKmlrXQm3p4vWIl0qyFVqtTa+xryuP8sjWhmfKRswQOhyM2ob0OMVBRd2jLfhqiOikoa6WkFXr5DYqFI/JzWfZCyj4c4Tiu6CKOHvxwbdjjVTcezA58L4+py2MCEgNkZIBffg1Gf/fFWOd3bFUHMgJGokKPxdFEzFxgVNgQNG+Js45hnW74vxMXeqy+Jc74L/qU1rhB4wqmNrR0iBZAMGW3M1lsNnvAhPbYIsCMXawt/3mIulFJcZSRV4oLlgpzv+mrCRqR36Gl0xN349JdcURvXGkgjhH2RGnQg7Gn371ersllAhIDZGaCXXuuw8cEJgXrMmUYFRBDbP7DqSMM63RDat2QemymbCtM+bWp67ex0dvFlF290phMpkntDYCAZbggR1ycy9My0moZeeVg4fcDed/253zdkr2DEL419dT7pFPP1oa8WB82oy7smbKgv11bjwtyxF12muVDGSK0AzIDZGeBnbuvwSf6phAYiQoIRjBlysx2DoVCKyLTKUW0YgqtiEwrItHHVEpLavr7BzWayTFlLIBgfIc8U9vb2/vkyNprE4KbP8/z+RLn+zWOh18iJ6/6U36EL3sz53HTPu5Kmc1JeoeZ8EZb7MvN0dOTXR/xWYjz+RJ3ymXf6QJlVhsg1QECAWzfeRXKb1Kw7moHowJiiClTJpFKrwREBPhEXvGPCAyICPCJ8L8cib74XY68fjWew+EZtglNGRw8kdzW1qb//R7Ed5Nn0HvPHf2t8OJCZfE6OXnVYOGygbzvBISF/Kz5vPRPulLndCTNYiW+2Rb3SnPMjIZbz9z8bZGb81HXFMHpAmVmKyAyQE4u2LYjcHIzZThLOCYwEhUQjGDKlEUD4q6unq7Onq6unj8XxlLY7B42my+XqwzbhKYMDngktra2mvm1iEqe7gJpiJG0RVWyXl70Y+2Nf93a9QT96qwR+UX/8lj0nkdaYl7Wyy8o9MSu+AG3DOnloqG0FlDIALl5YOs2y/Ibz0yNxfpWmLKp/bFi30zNW42qM9Y9RIN1VzusRQWwNJ03ao1tZ/0gpkyZxeqkUqtKKFYWCrmKWsIYEP7lh8esu0/ZVIXxx4nhp2Yi0GoQ9OlyJK65uZlr6fd7bux6rzH88xK/dwMccD5f4kLXPa6XX2PUOz4Lcb5f4a47PpB96smEQ9Pc3Y8cy5JktoK0FoBvBoUMkJ8Pfvo5wOb3KaPHujYNR24CdgBT3oGRqNBjPBCjFkxdMjF1Sqc0pkyZWEj19wvzvRjuc8HK8ntgLIfNNWwT/S1x5sfXOBIsBpLFpsa6IRoQTHnf4Zimpibz2qvpBSFb5vktxvkvwZ3/bJrzDlfP9Z/3ZS/oyfiUEfb2NsftW7ccuLBgmv9SnN9inNsR72NZUr32UppAfi0oKASbt/rZ9oHaiWRKm7J1mTKmosIwTxlZY7gATdnemDJloVDUwenmsLlWl86OHoVCadimrTJlM6ZsXVOIoWUXU957MKqxsdG89qp7AK1DeWXZm97fvL7tFm9dOH//Pterq++P3PHolRW4//h3fB3YudKPceqrmWe+en1vAt8rT67XXlIjyK8FRCLYtMXX6kzZ1NcNxAqjVpofBjTfQUZ9itj1WBtB3OdR7Rg6kamDNa5j2IjFvTIDRqLC+DBNnSvDyojLkPFgevqiu5RaM55Cr6gXiSSGbdrVlBHVajFOLKp1PCCYsrNLZENDA1sEWKa19+evRbCG3bNke5PEB1JEGfn0S/NxPl/iLiyY5hDCu0SUEdrBSYJkT6LILUPqVzyk196dBpBXA0hksHGTj3WZsrHwLErRVB3zHaGvZqu+0Bzp+OtYlyljKiqMrzFmRAVN2R6YMuW8HOrFc6HjKUEBMWyWNdMXYCxzyqMu6maWzXSEuMn4YwxBn3v2htXV1bEGQLtZ7enf8hXH0ITShkhsHZkDUrNKDu85uj2oYnNUfzxDk9UGMltBeKXmerk6uUmn115CPcitAUVFYIPTZesy5XGasnksXuusM1NbtWNqKzP2BJACyAowEhWjjgia8mRhypT7+waY7Z3jKRw2Vy63y/SFcc0pY8q//HqTwWAYaq+hD9TxQS3Su8kN3ylTwAKH8IN7k8R7k8R3GoZH/g9nJBtKqAdxdSCnGlAoYL3TxUnJlNGAxkxtmJVbdBaLhmuxU0P/si5TxlRUWDxqaMr2xpQpc9jcivK68ZTqykaxWGrYpm0zZcOFcZqy+QWrQdDn7t0htbW1iNqr4gG6ae3lMUEuExDagT4bQtTe7TpAqAYlJWDd+gsWM2Wvv2J4RgxPgeGXEcMFY6GaT4QR+zJVAXEHrOjIzD5b7MhUa4h1TO0MSjASFcBoxE2dGVNnz/zQQFBiypRzsovPn/ljPOWKbxSb1W3Y5pjuvvAy660o1Wo+QhBla8PQQjDlXbuCa2pq7KS9aAbIrgKlVLDW8fzd+pgABjVvuEvWZcowKiCGmDJlPl/Y2sIZT2G2d8lkCsM2rX54BINKRAOCPnfuvF5VVWVOe12g2FrtRdWCrCpQVgbWrD17V777Amu5mK12BiNRAcEI9nshkTHWmTJ2NDhWEIxv+/ZrlZWV5rVHsVZ7kTUgqxKUl4PVa7wtyk/vy/CvPf6OFexEBQQLYN+Upy4I+ty27SqdTkepPUL72LQXXg0yKgGtAqxadRrKbwoBowJiCDRl+2HKlCV0OrBfCaGDlStPbdzhlplDhvKbEsCogBgCTdl+IJjy1q2BW7YEbN7sv2mT38aNvk5OPhs2XF637uLatefXrj2/Zs25H3/0XrXqjHVl5crTy5efcnDwWr781O4DJ3MLSkRiCZQf9oFRATGETCZXVFQIBAKt/RkaGiopKbmnTZleXe93NWKXi+fGHW5O213HWjZsO7z+50Mbth3WF8Q6G3e47XLx9LsaQa+ul0rlE3/YkLECowJiSHl5OR6PJ5PJVPtTUlKSkZFxT5tyb5+AXl2fR6Rm5pAzCCTrSjqBaObTzBxyHpFKr67v7ROoNaN/yBaCQWBUQAxhsViBgYG+E0hWVtZkH/QEgWDKao1GKpWLxBLhgNjqIhCKzFcQiSVSqVyt0cBvqVMCGBUQyMQwJe8FhkAgkLsVaMoQCASCIaApQyAQCIaApgyBQCAYApoyBAKBYAhoyhAIBIIhoClDIBAIhoCmDIFAIBgCmjIEAoFgCGjKEAgEgiGgKUMgEAiG+H+JY/x1uhQlOQAAAABJRU5ErkJggg==" alt="" />

第二部在项目中为其添加引用,在右击引用,在浏览选项卡上。

在导出的按钮上添加CLlck事件。代码如下:

 private void btnExportToExcel_Click(object sender, RoutedEventArgs e)
{ SaveFileDialog sdfExport = new SaveFileDialog();
sdfExport.Filter = "Excel文件|*.xls";
if (sdfExport.ShowDialog() != true)
{
return;
} string filename = sdfExport.FileName;
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet = workbook.CreateSheet("员工数据"); IRow rowHeader = sheet.CreateRow();//表头行
rowHeader.CreateCell(, CellType.STRING).SetCellValue("姓名");
rowHeader.CreateCell(, CellType.STRING).SetCellValue("工号");
rowHeader.CreateCell(, CellType.STRING).SetCellValue("入职日期"); //把查询结果导出到Excel
Employee[] employees = (Employee[])datagrid.ItemsSource;
for (int i = ; i < employees.Length; i++)
{
Employee employee = employees[i];
IRow row = sheet.CreateRow(i + );
row.CreateCell(, CellType.STRING).SetCellValue(employee.Name);
row.CreateCell(, CellType.STRING).SetCellValue(employee.Number); ICellStyle styledate = workbook.CreateCellStyle();
IDataFormat format = workbook.CreateDataFormat();
//格式具体有哪些请看单元格右键中的格式,有说明
styledate.DataFormat = format.GetFormat("yyyy\"年\"m\"月\"d\"日\""); ICell cellInDate = row.CreateCell(, CellType.NUMERIC);
cellInDate.CellStyle = styledate;
cellInDate.SetCellValue(employee.InDate);
} using (Stream stream = File.OpenWrite(filename))
{
workbook.Write(stream);
}
}