Hello friends, This tutorial will help you to insert excel sheet data into the MySQL database using PHP I have also included the snapshots which will help you to understand more clearly.
Import Students: You can import students by clicking on the “Browse” button.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABQAAAAFYCAIAAACDFMYpAABOjElEQVR4nOzdBXzU5QPH8d/lbt0dLGCMscE2ukM6pFuUkBIUREAEFFFQUlBCBKQRSREQkZaS7hg9GLGN9VjdLv5324ABK3SD/bnPW15y94un7ni99t3z3HPS6PhkAQAAAACAN530dTcAAAAAAIBXgQAMAAAAADAIBGAAAAAAgEEgAAMAAAAADAIBGAAAAABgEAjAAAAAAACDQAAGAAAAABgEAjAAAAAAwCAQgAEAAAAABoEADAAAAAAwCARgAAAAAIBBIAADAAAAAAwCARgAAAAAYBAIwAAAAAAAg0AABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAPy6pBz/rNW4Y6ry47bMaGApet2tAQAAAIA3XqEC8MJudddHuXRbtLyXl7y4G1REtKk3/li/N9a9edf6rvm3WZsReez3lb/uOHzudnyGIDVzKlu1TrMOHZsEWj0dm8KXVkL83zUYAAAAAIrdmzoDrEk4u2Hl6vBqFTrmmwC1yRd//nT48msqQZDZuHpZiR5F3r24Z93FPZs2dfr82w+q2UpeprSS4/+uwQAAAABQ7N7UAKxOiU8p+CrllVWTdOlX6ttj6pc9K9vKBP2EcPTZbYumL7molEifLEwuXGklyP9dgwEAAACg2L2pAViTGpda4EUZdw8cihQE65aDemSlXx2RzC6ozadLmmRIjOXilyrtpUnEBV/zLxVPgwEAAADg/9m/CcDa+F3DO3x1rdq0tRP9w//4aeHqnecjU8VWvg16jhj8tp+pKOX2niULlm85cTdFYlW6VqePhnQOshQ/c+/VqpPXTPC6tP7n1VsOXIpKFZu6BTbo3Kvv2/4WOTOhNiPqxO/LVm47dPZekkZs5h5Qu1WXdztUcpSLnmtJjWlrv/K9vnbW3F/3hSWJSlV2uH0iIuuCo581a5r5wHPQ6rkdXZ/vrTpDo/u/SPT8HlQimXH2wmF1xG/93ptzPdfSNKGz3hu8Mda936KFPd1lj+9NvzTnnYFbYn0GrlrUzknypKVpd/evW7xy2z9XYpViC88azXu+V95Yd4/yuaHNiDy2aenKrQfORqQKMmufkEbder3byNtE/PzITwp8uG+5rryTYfEZcju/+j2HfNimjP6y/BosFTSJFzctWbLhwNnwJI2gcPCv2rhjt84Nvc2KL4oDAAAAQEnx72eAM6LO/v71lKX7oy3dfb2d7tyMuLp79rA0yzlNLn01YWOYsUtpb9cHN+9d379weKzpqimtnXPWpLq2dlLvU6ciZA6+5YMdE2+ev3l263cfn74zde6QiuZZYUzz6OKSsSOWhSoFiZ1fcDnT5Ftnz23/8dyefd2nzegZ8Exiy0i4f/LHHyZuDBdbOjs5O9ZtVD3Z9c7NPdvOJAm21VrVctZlWamTr/mLIU/mUsXf7Neo2M0/LKs1sXc1W9kLVwgi0zJN27fxzbU0TWGHSpN09qdRI1bf1N1g4RUQaJ1x/9Sarw/JJM9dpk2+tHTsJ0suK8V2ZavV8zBLvn7k6LqJx8/c+35mL1/jpyE94+G5P6fMXLDzvrGTj6e3POxmVOiOmZ+m2i7+oq6VOJ8Ga1MvLxj+0S/hgrlPjaa1LVVRl//Zv+qrk+HGSz6vZUkEBgAAQMFU8VcO7t57+OLtqGTB1L5UhWoNmtYoa/WmLivFm+c/vFdvrVwaX2vAnKVty1mItSmXfu738erwQxP7HDIN6jntt64htlJt2s01Hw1eGHph/fZ7zXqXyhkv405d8u8ybkqf2m76YKeKOfzjsNFb763/7tfmi/qVkek3cTo6Z5wu/RoF9Jn5ZbeAzLiZFLp27KiFZ34Z953fsnHVcia2yz9NDrVsMmbV4Ibuiqyc2Chuz/VtZy7KS7cdMriqSZ5dMA3pO6Teqcl/31wzssffVdt17d6mcbCTIud8sNg8oMuA8oUrLQ+axKNzxuvTb6n2k7/pX9NO1z2t8uHJVdO+XHI2xzplTdKxeZ8vuazy6TTtu94h1vp0rEm+tGzwxyuXzNzSaHZn96cv1c0VCyJDek6b2yVEl9l16XrukOHrIg6uPR5Xu7FtPg1+dG7V+nBBHjJ66aTG9vrh06beO34otkx10i8AAAAKpFXe2z//6/n7H2gFwbb5F6OrXZj+5S8ndq3eUO+jUQMauMhz+WbP2f1H+H0ztbGd/sfNtAvThy33//rbFvbPzwP9/1I9PPzznKV7w1LFpi6VW/cd0MxXcmff3ykhjctZFPwTdsrJL4dtbjZzQnXTwlaXdrvQhb8WW2cvcnuvT1CxNE8Zdf5Cuk+Qu8l/Lfw/BGCR/wfff9XGNTPXikzKtmrvvfr7m4J7z5lTe/hkhkiRwqtpZ/9FX124fyY8TXgmABvVHjd5cJXHL7XUtkafj5v8PXJHxM5tt94b6itX3d/+095EQVrx49FZ6VfQR1G/zp9/eLLr9FO7Fm/rHdLt6aJjQZvi8f5PH73lnssMbgEkDo3Hz7f59cfZSw6EH9s469jG2c7Brbv26NYy0K6oNk9WRexcuC9JELwHfp6VfnVEcvvKXToFrjh7TPXksgfbf9oVL5Tq++V7WelXR2zq32lQnQ0jD2w/FNW+q8uT10rkN2Du1PbuWS0Um5dv29xj3ZI7dy4+UDa2VeTZEI0yMV4pCNaOTqbZ7xqRsWvVRq5F1E8AAAC8ydQx/8wevfBGmVohmoOnIiUKUzMT/Sf6BPtgn4S1386VTfiojs2bkmw16akambG0oKilTTy2eMn1qp8v/dJD9ujq/uNqtVb96NJf21N83ipMRs3lFwb5UycUvvAiVMjRKE5arSY5/NSJdOeK7i89Hfm8/xCAFY4eNk8jp8TCzVYm3MywKeXwdApVZGzvbCZcSEpJTNMIOdcgi2XPjqDItEx9X+mOkzEXridofG1jzu67qWtbhXa17HJeJrar9naQ9NTxsL3HYzq7P/2AraxKj+YeL59+s0htK70zbnGHu8e3/LZu3bbTD05vmnl608paQ6aMbFva+KXflS/QxJ3fo/9Ern+HJq75NFETe1Z/mXvdKjaq1JQnsVjQ2pdxFA5EhkZmCE8DsMLZK2c+l1q5W4uEO6nxqdr8WiK2CGxSUXr57J9fjLH4cFD7OmWt/u2QAQAAwNAknVn68z+JpYcO/aDi2ei+M0J/+3TQVg9/dwvf1h8OCjr5xYAfV9UL/jDErHCFZUQdXDxv3cnYDJHCs0mfD9r7mYmER4cmjt7rFSS5FXbv/iOvtt397uz+58bdSEX9UZ92LKMQqR4eXvzjhvOJGSpZ6bZDBjYt1u/61CgToyMfaBUWFhZWJgppnplArUzNELT6HYUk5r4NGmoTT82duPbaHfHkYafLvzeiQ8SUCXd6zRpcVq6K3DJq0oMB0/uXlQvKiL8XzP7laIzEzsM1OSO76Bd6p9SNxj7vEMXdO/fCI82bjB7T2iP91I9PCx/5rsnOmXMPxggisWujYSNaehi9/tF4IvXS2mXnHLzFUZHRMWlO1eu5PTwbGhEdLw/s2KGWiyzt0pqfj5i4miiVaYkJkjLNOtby0KUuVcKlndsOXn+kFmQOIY1a1NQvFE69tG7lFVf35JtRgqUs4eb9GPG6n256NHqnpe9/6U7RLdcXiWUvDoZIIs1cy6vJN5rpyS0ddP9e4h9FJ6sEy9jbMbpDdj7OzyVQkbFzaVvheGTsrTiV8DQAS81Mc1tx8RLExm7VOn9YrWPf24c2/jxnxaEHh+YMlTmt+rSG1X/9TYcqqy82PqVy+RByzsvC9JeFrxjYcsWLZ+VpqvwGUCyR6Lqv1WjzH2WpU6uJ3yZ89c3S42sm9Vsjd6vcomOHTi2eW/MNAAAAvOjUbweSBSF0zvARVnH3M3/qNK3Zu6P53K/mjxilP6K59duxD0MaPn9b+rUVo/ps1P+wKmiVsQkO/roHqvvbvl8W2XjSvPr2ytAVI2Yv9p76YbCp/ifiu9paM8a+L77wfb/pW3y/+Xyic8K2cZ9tuNpqtH/8th+3mnSb+EMZRerln0cvP1L1s7rWxddZqbmjk7lGlfroUeL9iGiRkbWTjWlu2wVZVe/d6fDU0YNO1G7dunWzEDeLkP4fv3VtlvGI7zq4S9VRW168RfVg2w/L7tWasKiFm/bO759+eTr74HO9Gx2iG41wbY0ZI/sYPfht+KQt15sMKZ+z8EdHP98lfnf6zOrGaXGpsmJMv4UfjZzUSdFCufc7NRHf2fz9b8dce3Z91zr5+Kplh+5V7eSpn1LOsK/VvpqDLOPuX8u2HfLt08g28cTm3XFBPT8ItFTd3bto6y6nXq18FLqRibsaWXNQ92YWYlXEvsWb5O371bT7r8sMSszn1TXqdP28p1icuRYgO8nlkqiz/y4wUP8rYpNSdd6ZEBL0Y59PNjzYt+pQv2ot7f5rAs7aY1osLqCcrPDq1Hrsp/VefFGltt55L21+CWLLCj1nrGh17eiOzX9s2XZi06wTm1bVHTlrVLN/sXocAAAABuRsuMQpuJrtnUMXY7IOyMpUMr66NlrQCPfjHAOCja5ePSUILwRgozI9n/kMsKDf7efiwSjvrlUddElEWrpRI7MJB8KVwX76D1C6lPc0FQkqaxcbGyt/B7kgNnO2Fg4+ylAnXDxwM9Zoy7xp+m89eWQkc097Rd3W/4z+wlfGPCFSlGo55vs6N45t37D6s41/dftmZKMCiksKPRxdulN9dyNdmfbu1jJ9ANa82Dt15mj460dDsHS1UJ5PUT9bkHHpxgG//Dx9/v2WLZtW8vjv/Syc/EcjB5HcxsNRIRLUZjbmZqYeVlJBbGxjJlzST+uJBJHU3MFKP4Epdyhtm7o/Kk1tfOdiglM9XytdDpI4BwUb/3IxWuXjpivHyD2oTBEv+C4pAVidcDPskX6Rs4e1VJDalLIRhJiYsIh0rc8zc7tpkTdjdX/ZeNoUX8NFpr6N6thtWBv98FasSsjvs8CizG/y1ajy2w5aYu5gLghR8XejlULZvH83I7X2sNZ1OTHJqlxghf+8sD1fMusytbt8UrvzoDu7fvh88rb9MyaHVJrd3L6EfpIeAAAAJUGqWc1+w4d7Xkof+O2JDEGwqtS9rXfilij9KXFA72HDzZeN3FjowrQ5v4hU+0KiEj2d9hKJRZkTRVqt3LPtgE8qF3q/qP8kIykiJi5Fv+jX0sWyoEW/Ugufmp1HVQpeMmr65pv1muc8JXp+haZWo9KKZLLnf/J+sXePbj4tRJzL7J/Etu6QGRVvHd++cepHf3eaMqKeXWH79vJeajRe9OSlFL04HCplhlYiFYvyeUsU+cRnCQnAynu7N+leZHG5t/zMRYLYpmJdT+Fa2JlNh2NqNH06B6uJPv77ad2/t1L1KtvmP/UtkmZ+yZBKmW84Vccc+f2YVdOmfqbPvAe1aQ/vJen+tnCwkORXmkhhqZ+XjQ+PUz3d4isj4vz1hBwXSazLBtgIN2IvbT+dUKPu0/2Wtar0nKWJbYN0Xb4ednjtwZigJrb/MY0WpvsiE4/Ggwfs/GvCyVvn7qc1ty/e1A0AAID/a7bK/VM+CTOPvaP7aVwwqj5waHs/k1RNDdOTfydrzs/8bIT4obLe4EKVJLb0r2W39o9jDyvUs1Pe2LP7kV8fN7nux+gCbrFdtWbnzfJtvBUZcZHp5k7mxZljJHJLOzenArd9Sr22ccUJp1Zta7gYqxMfRCjNyphLjEwlqfoPdQpSscLaOP1oTIpWEMdcvhClttV3xKJ0gMnGQzeTK5Y3UcaEx2bk1btc6xM/LVz58PI9aRmvGp37pp8Ze/qBUJwBuJCjUXha1aPoeKWXvSjm4tFom/LOCrGJe3mLA8euJngGWKgizp5JdWtiq3t9VTnuEcmMxMpE/dT4/+kS6NTja9Yede5W1Uk/v6uKPvLTxMVhgmDd+L0GmTORMtcWA+qv/WzfqRlT1rmP7+Sv/9pfTfLV9ZN+OKEUzBr2blngkl2ZrYe1cC7u1uGryTVCTHP9NYXq/h8TRv90UbNhf89+fTrWKm2d+RlmdeKV32d+dyhdkAa0qfN4i/bcS5PZl/MyFu4mH/7tUFRAIwepoEm6smH6mLmXn1mgoPBp2dL19xX3Ds+Yu9trRCP3zB7HnP5lwvRTOdOpzLXlgHrrPvv7+NSvl9t/2TPYKqtqdcL1Y6Emlaq5vNyn/HNrsPrh399PP+Pbu08Lv6yPI2tTbp0P17XVxsOaFdAAAADIT5VyxrsO38le/px+/diFyNJed4+FJmc9fxgpmNSqXsiipK4th/WMmDdh0Hq1oPBo8tGQELOCZhWlrq0+fj9q3swPd2ukMuvgbp+8X8W6GLecFhsZFybuKdyCS+9dOHnQ7GStSOZQpePQVs4KSbXG7pMmD/40sOsnH1VvW2fj3LEjdrt5+Xu6KR7pb5F5dhzYeMaicaOtHS3NFCYmkjx6l+uP51KHx4V37lcvasO6BfHqjFStR5th/2lTqAIVcjQKTySk39m34kJ0gtKkTP02Ifo5QtsqbzeI3bZ67mGNLmQFt27l8/xuxBLLskF2a9fPW1aq3nvtgv9L7a9rBjj90vKR76229/ZzUyRdvxSWpBtY765f9Qs2z+qp2KrGkK973h+54tyCgV03lQvwMk0NOxcaqRSkZbt+/Um1gremUng3a+ywdW3Un8MH3qnqbZSYWn74xF6+z6RIqVOjDz86P37W/mMrvj22QjCxc3Ew1SY8eBCn1J20azhmVFNnSf6lGQe0bWp/YNPDI9926vFLWTv1g+t3ExybjBh0f8aPF57WI/N+Z9Q7Rz5eee3vyT2OLS9Xxl4ce/3i3WTn4CCr02fin1ym6/JHk3pHjVhyecXQLlvLVArwMNfG37lw8ma8vMoX676qZ/0yb7tcGvxls+u79v9z7I9//lpZvkpFTxvpo7Djf1+KEawaD2juRgAGAABAfvw7dSl/7bdwZdazjBM/jTyhf2BpYZl5QF7q7Y4BL9714YLpTx4rAkbMn5r1UO5Yd9CEus9ealZr/OJamY+krp1++C7roHHQJwuDMh/JHGoP+LL2gKLqTpEQGXs17P9Nw/7PHHRp/sXcx+ugHXp/N7939uMO2feYlm3/xbT2z5X0Yu+ejIZgUnniwsrZl+Us/NPKPYumG0Wn1YfvZ/7t33Wof+YDiW3tgX2zzsm9237orX+QquuHXUjbbt7PZjOrgJbdn3sHGT8pR3+BTeXuAysXQSNfUwA2bzj++7eurlqyZf/pmxkyK5/aTbsN6Fa/VI6gLzYPfP+7ZRU3LV/558Fzp49qxGZugU1bd3m3fWUno8KsO1eU6zd5rHrWoq3nLh6JMnYI8ElO1wrP7hUtNinTfszSOm/v2vTnrr9PXrl7PyxakFq4BtZr2Pad9nW9cn7Hch6lGZcfMOtT0bRlf56JuB2a7hzU8uMPerfwuDX5RyFHANb9y/B7b86P7kuWrPnrxM3L5yIsvaq/M7bfO0F3xnQ5cypne8zK9562ouLWFav+PHjm5IFrgtjUqdxb3QZ2aVf7pdJv7g1WO7aYsNLv4MbVW/ceObnrYoauOpegpoN69Wob8p+3ugYAAMAbTube7vMf273uVuCNUMCX1xSvQgXgfqv398vxVGTVaObuFzY4M64y/s/9zx80Chi2Yf+wF0tUqyQO1buN0f3Jp1qRzLFqp5G6P3lfkWtLHtft2nDotIZD86lAX4LcPrBFP92f/C/LqzSR3L3hkB8aDnnmYIUxf/71XL/Exp6NPpjQ6INnDnrM+nP389XI7ELafaz7k0drc++vafVp+/4qTIPNvOu+O7buu7kXDgAAAADF65l53dfgNc0Aawv+YmAAAAAAAIpQCdkFGgAAAACA4kUABgAAAAAYBAIwAAAAAMAgvOoAnO+2VQAAAAAAFBdmgAEAAAAABoEADAAAAAAwCARgAAAAAIBBIAADAAAAAAwCARgAAAAAYBAIwAAAAAAAg0AABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAAwAAAAAMAgEYAAAAACAQSAAAwAAAAAMAgEYAAAAAGAQCgjAGo3mUVJKalqaWq1+NQ0CAAAAAOBlSSQSY4XCzNxELBbndU1+AVir1SYlJScnpxRD2wAAAAAAKDJqtfpRcrJW0Jqbm+aVgfMLwBqNJi0trXjaBgAAAABAEdNlWGNjI7lcnuvZAgKwv2+pjIyM2NjYNFZBAwAAAABKJIlEolAorK2tddE3/MHDfxOAtVqtLv0+ePBAV4qFhYXuafE0FQAAAACAf08kEqlUqoiICGdnZ40mz+iabwDWaGJjY3XpVxemSb8AAAAAgJJJl1h1uVWXXnUZNp/wWsAMcGpaKnO/AAAAAICSTyqVpqamqkW5r38WCgzAGo2G9AsAAAAAKPmyM6z4Xy2BBgAAAADgjUEABgAAAAC8OfJZxUwABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAAwAAAAAMAgEYAAAAACAQSAAAwAAAAAMAgEYAAAAAGAQCMAAAAAAAINAAAYAAAAAGITXH4DVD9a932X2DVn1aVumVjP5t6WkHh/79icH0j0/+GVxV7fi7dRLNbhoeveSNPEnF0+YvPpkZIZ5ldGLp7ZwlBRxBa9wtAEAAACgqBR9ehlev+4Jjc+HaxZ1cpYImphtg9pNvqyo+93vEysbF3ldBUg581WHj3Yl5zji3m/l0p4esmKpLSPy0PLvF/x2+FaiRuEYWL9j3wEdQmxFRVCw8src7v3WpDT5Yf24oMJk6PTQpROXn4wR7CrWqVK1rPXT9JtrC6UvXf5/8SrrAgAAAIBnvDHTdyJx3lnT3i/IVaF/IPdwNRYXT/3pVxYN+2z1PUEwd3U3TQg/v/2nn0vXDOzs8rh1/6FoZXRYrCAoCnu5JinscowgiIOHfTOprnmBLXSXvWT5evmNdr7+RV0AAAAAUDReXQDOXgzs2qi585WDp8KTLcq3/Xj84AZOz0VD5b19i2Yt3n4qLFHuEtiwx9DBLUubiAVV7Lltq1as/+t4WKJGaleh7dDPP6jnKNWkXNk0/duFu26m2leoaq7Oq2b31mNm9PJ8Mu2rfrD543emn8ko1Xvpz+9Ifu3Tc9FtiybTVo+tZhxz7JfZi7YcCY1MNSlVr+/4MR1LG4uU9/YunD5/08kH6cYedd8dMapbkGludaiiTv2jy5bioC9WzmpkLTwKOx9hG+guE7IbJUk5seDj6VtORmocaw2eOr6jl0Lf0+dLthC/cLCT4+4hXWeGagXh0Y6Pmu0wbzZ7/ZiKj6fScxurtKNje0y+rDupOT2uZeuWc9d+GmicTwvFD37r/0z5M6faTxu04r5V63lrRwaoD37UfMwZwW/Uhvmt7IW8RjuXIYrMfK19ew4qd2btlvMxosxet1P8OejZvqwbpFz97ay1R8JTReaetdoPGNa3lsO/eGsBAAAAQGG88hnge7v+Nm/YoK7Rzn0XN074ytNvduscJ7VJJ74b8sW2GMHcJ6hs4pmzW6YNjpKvmNzUQfvo/KYNJ5N9K9X0vnvkzLn1X0/xD5xe7dqM4bN2JQly9wDH2FMXMvKq8u7WySPPGosEiXWNwaM7e8mdmw3v9du7C2+snr+rtONvtwVZ0MB+lc1Sznz/wYiNEYLIvlyIT0qcuZudkUj76NQPH47fHG3kXauJW+Tf+38arXZb/ZVvLnVIbX3LWghhiWe+GTL2SucObzcJKZ1zrjn1zJqtzl4OxsK9yEPz5x5tPK2u5PSLJU+qdOv5gy7zO9So63n97zCVYF+pUZXS+iXL+Y5VfbvgOn6ndoSmChZBjZsF20jzb6HGxOP58sNzHURt0vFcRzu/Ibq64qdHletVcf/7aLi+12+Ne64u08s/jll2JMmqUssm1nePX42RyAvzDgIAAACAf6foA7Aol8WxOY5Jq30x88uaivte4V3n3Ljw19n4lhWfnNPEH12+PUYQ3HvP/am3R9KOjztNPH105c77b/Vwd+/8w+/tJRkPrlw8nHF1wfGUK0fuPJSt3ZskCA6df1g0xF979LM2Iw+l59oibdSlU1H6B2a276gEQS7IPTuM6Lx10Nojkyfojnr0GtrEURS/e+nvEfrS5i4fHGCS1V5N3NFlf0QLihpjpo2vZRbpE97zx2NbL6UMz60Sk+CPvxum/mrurjuH1sw4tOY757qDvx7TydcoewACRq6a3drsxLh2I/en3b0Wo6xw68WSL95TrXv+4LZ7Yyf1bbDz7yV3zYLfGzH66edm8x6rjgNa7dwRekXi12344BqmBbawUo9nylfeXJjrGCadynW0dc3Ie4gkIeN/mtFAdnpC+2G7U+5eizN5/9m6Uk8e1U8ki01cq/YY+JG3pawoPjENAAAAAHko+gBsqst8Kcq0DI0uAAlaZap+qlBm+mRuTySS6GKOxNLVSqyLT8lxKZqnt6oTwqP1tzmVtZcLYrNSZayF0w9jw2IyBJeEEysmTF59Jk6XXzObnJ6cmhQZo4uzgkugu7EgpIrz/pSte5/lS3MsgdYzKdO8kfPaFQ+UgrRS73ZeckF9/06ULoxJvSp5mzyJYeqEOw91B9X/jO/Q5PGxpMR0jZAbsYlv+y9WtOx/dtdvv6749fD9/XPGl6q0rE9WYpWaOZhLBLGppUIQ0jQZmlxLjo0Ky606rWtu1eU9VrlenncL+7nnOXA5q8tjtPMdIrHcRJdpdf/XvfopmowXxs046MMJPeO+WXFgwdgDC6yr9Js0oWeAWWFaAwAAAAD/QtEH4PJOwr6b9w6feNjNw0UUfXr/bd0xl3KORkJ2/tFqtLoQGH72nu651N7FUpcLMxOnVquLxe52YuGuOuLKQ2VN40e3r+nyrmDjaStLPT9/4uozSS6dZ8zt67xrYPe5t3TpytjOQp+hY+/EZQjmWo2+2MLSRO9fsP6BIDIWtKmn1+64V7eLq4Wrra5q1a2TN1OrBxgLGrVWLJFkHRQH9J80sKJZZislFp5W4h2PG5yDNuXGzj/vlm1RJ6jloLIeyV0Hb46LuROnFnLf6licW8ml7K/sfLE6a3Gs/lcGgipNmbOEPMcqz07n1UIPUc7yRWKZfttoZYpSI2hSE9MeV2ea+2jnNUTbc2+D6Jm6dME98J3pG7uGH/xl6terji+cuaPnz+3zbD8AAAAA/DdFH4Drd660cPLJi7O6d9roLrp/O1olGFfvXMteLERmns44+nm/D3xF1y5ECILlW11CzCVaO10IFjJOLlp5dXa3d5vbnvkjfMnggafdEs5c1t/bs4mLVBut1sfn5PCTf/x8bcOtzIJEFhVaV5afOXZnybivHvo/OnBImVeLwrd888mpzI2HxVbVhozt4aM8tWj2P6nS4E+n1No8dM7lBdO21f2udbXujSzP7ohaO6TnhSCHxBupDabN6+dbvUcjq7M7Liz6fnGDIEdNxG1tky/HlzN50uDQoP5+mQVrk0/P+WTi1ljhe3NXL+v08Du6OGpWo4mPkZCWa5PEVrmV7JfbQX+p4OOhEMLT9k8ZPb524/cHt3aXZ3Ul97HKYxDybqHUJmf5fd8t7SYXwlP2zhivcbyzLzT79rxGO/eOlM3rlxHP1PVWu4DTX3x7vlTd6u7pcbryZBaWeb+tAAAAAOC/KvoA7Njsq+9TZs9evefSnduC3N6/eY9hHza0Ez/ZD9mzimPcyZNq69KN3vtseBVzkUhbuU+PgKvLL1w/HRrft+3HcyaYz1z856kzoXLnCq16DBvSyF6XNgP6fdzs+vTt/6zbGFendlWLLcd0uVJi13DMpFtfT/v15N/bkgPqvOW+e3fu+zcJD0PPPMx6ZGKdoEm7smrGtjjBulXvBhXLenfZMODXM3Nn7Koxpeknc8eZz/j5j9OXTiXal6trrVVrxBbVRswdbz1r8Zbju7dJLdwD62tSlYLj0wbHqf2c9ROmItOK/Sd+Il+6YffJsFtJgql75fa9Pupb21qseZB7k3ItWeSUy0GtyLzKhyNaRHy37caZvfssG/dp5S7Xz6KKzCvnPla5r9DOs4WC8Fz5YwcOrHVzzqHw42es2n3U6+z3S69nNjiP0c61I9q8vufomb6YV6tetUHFq9v3bDkrKJwrdfng07qFeYMBAAAAwL9TDLtAi83Ldxwzv+OY3M9KXNtN+vbbnAuDRaaB78/74/3HT10bfDC9wQfP3SVzbjJmeZMnRY7M/tukWv+Z6/s/Pjp+/HN3mQR98ef+L15sw8DV+wdmPyz3wZr9TyrzaDL0+yZDn71W4f7W4BlvDX724DMNzu6XVUCbYdPbDHuuKolzpyX7Oz1+FjBy8/7Hbc+95FwPyl2ajF7SZPQL/ZDnOlZi+7cX7n/7hYvzamEu5Xf8dl3HJ0869Hn8yCaP0c6tzXn2+rm6WtRo8/GLDQIAAACAYvDKvwZJq36Jz+oCAAAAAFBEXnkABgAAAADgdXh1AfjZxcAAAAAAALxSzAADAAAAAAwCARgAAAAAYBAIwAAAAAAAg0AABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAAwAAAAAMAgEYAAAAACAQSAAAwAAAAAMAgEYAAAAAGAQCMAAAAAAAINQcACOiIh4Be0AAAAAAKBYFRyAvb29X0E7AAAAAAD4j27evJnPWZZAAwAAAAAMAgEYAAAAAGAQCMAAAAAAAINAAAYAAAAAGAQCMAAAAADAIBCAAQAAAAAGgQAMAAAAADAIBGAAAAAAgEEgAAMAAAAADAIBGAAAAABgEAjAAAAAAACDQAAGAAAAABgEAjAAAAAAwCAQgAEAAAAABoEADAAAAAAwCARgAAAAAIBBIAADAAAAAAwCARgAAAAAYBAIwAAAAAAAg0AABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAAwAAAAAMAgEYAAAAACAQSAAAwAAAAAMAgEYAAAAAGAQCMAAAAAAAINAAAYAAAAAGISSE4DTHx5u+1to+RY9p7vJiqmKtNhLX+0+tiNOKbH0n1pFNWV3mEfN9nPKW6iLuuqcFf3UvnZQcXUIAAAAAFBoxRGANWkRa44eW30j4r5KMDK1r1224sCK3l6vIgSqroeeO2zi293DLJd+aR9t239wR7L7kMblvSWmpaVXrRUKK7lYVOSteLYin5LzOwaDk+/7AQAAAIChKfpgoIqev2Xz4kf2bYLrVDITx8eGbzm3q29Cs9/e8rAs8rqeo0k9cfHkSgfXzrkGHnXSmXjB0iu4i5eTsf55jVU9a2Q3uWib8XxFeE3yfz8AAAAAMDRFHgxSos6ti5M1bNZinIdR5uRq2S4V48IEy2JPvzpaZbRSm/dZrUoryKRicbE3I7+KtFpBVPSTzq/I/1nj838/5H/r/1dPAQAAABRG0c+MaVRKfX54GjwkCmufnOfTI9f+88+y61EPNVJX13KD61RtYiHJvaS8r9Qoo7ccP7b82t3bSsHc2rNbtZpd5afabw6N1527/Hvty4Jg5LugR/2Qx91TJV7ou/bwRY0gXNxU66LgX7fHfNuzHfL+3G9eVWtV8X8eOTDvyoMItcjC2qNtSNX3faxNctyYe0WbInq3r5lxev9PN+MtKrTfWN1Omha57ujRFTciIlRiW3uvrlVq9HQzyWqs/rPQmx70bFNdfeHoshvR8VqFv3/tqdWd7108POPMjavpEme34AkNg0MUz+Sz5Ht7W/9xp1bLbl+7yrO78OhSr18OmzTsPq+0iZB3dY9u/9Hwr4Qe7bsMtcscW3XsvHXrl1k0293Cwyy7Mc83Xp5zoF54IXp5mMn1y+CLpoOZF99r+1aFtKvnfr8TlygYeXtVHFWnYuXMs/k0XhKxv3Vu74e8XtkCewoAAADg/16RB2Bje//GxmFbd/85pWbNvmUc7Z/Ntlpl5Nzff1+W4TmofsvKJmmHTx8Ys0Vt26l2pReiRj5XajOi5m/etDjeplWVhh/biO/evvhXeHznapWXtHOcuuXvCx4N51WyVYiNXHL0TWLqPba5MGP74avudaZUsLW1MpYk5dmFvKtWXz355xeX5d0bvN3CUnPr9qU/IpLSvK1NRAVVpI3/ZecuS49qP3S0szaxlCkjfti8eUWKc/caTaqbKM9dPjZ328awJh3GexpnTxprY2ZtPfBWlTo/VzOLuLzno1O7et8zM7evMKptNbuEi59uPzHmhNum2g6KHG02dSzfzOTaH5cjk1zdzTOLiL53LVTs9JWLsajA6vL3bONzvlC5vhBd3M1kGRGzi7CD2riFey+2r1VnZX0rIfbq9F1HBm+Xrns7wCPf1ivscnk/FPD2y7unAAAAAN4ERR6ARUZuo1s3UOw7tH7/7+v/sa7vX7FXhdIB2cFHczf00LIE++GdG3W31B8JtBFf/WXPz3crhXg/92nZfK40uht6cHGsSbuWrce4Zq6ydvfumnmPlZW5uUiQGZl7WVsrni1OJDHxdbCxFQtGprYVnRyMBCE9zwCcT9XCzYgkwaZWV28nF7HgZ+/S/MXu516RKta6/uIa3jb65mrunDu0It68Z9vmQx30w1/T3dFs05pZh890cavhn/16iAJqtproZyYRhFKBIdXO/nXMtPKyBr4OutstK/Z1Pjfm3t37GgfvnAlQatuurMXa85fPpLvX0dWqTT157aHEqX5VY234+QKry1/Oxj83ULm+EJo7oUXbQUnNt1qO8TTSP3QJHFczvMWecxtiy31sl/vCgewKpCbuz78fNOEFvP3y6ikAAACAN0JxbA6ksCozuq137wfXfj13bs3ZffvOnWnbqOVnXqYSXSq7ES04NGhqkZ1sxHK7GpaaJQ+SlM8F4Hyu9FIfvxYtmAd3djIqlpySXyPtKpZ1Vez/Z9i+jIEVytaxMy70ztaSyv5u2bFKX36MYFmptd3jsRdbNPG3n7X/9oHEqv42WaFOYmNmlB3vJApHmSA3NjPL7q3ExkQmJKSkaHQ3PlOFl285n9Mn199Pq+2lENIjtkaKguu5WgmpfxdcXaEb/8xApeT+QhR9B0Vy6ZOuisztXN2Ee6ej0zR2poVo/HMNy//tl0dPAQAAALwZim13XImjs99Q57L94q5P/2vvpr0Hajo3bShLj0gXhMS9TRfuzXmprYP+E8PP5A5N3ldqlBFKQTC2tCmmzazyqVoQu/g1Xa04N//0uVEbjxnbePerVfsdZ0UhGiISP9lSSZMeqStfYWH1tMMiU1MTuZAUmceOTc/txqR/qhVevFRq4dPF4dj0y/fiPH2kEVfPCU6fuyrEmriXrS6/xueU1wtRbB3MIpZI5YKQrlRrCtf6nA0r6O2XR08BAAAAvBmK+ethRCbWZYZWvbJ118OjieqG9nJ7XXZxbPDX22VsXwga6TmfiPO+UvvIQXcqLSlBK7xYSBHIp2o9qbtnyCTP4DFxYUsO7P3hjx1mXVq1N3+ZLC6W69ufrm//48lGbXJyqlLQHf9v/RGZ1g90nb4v9ESam8X1CI1TncydogqqLjPy/Zu9krM68uILUXwdzJSREhctiLzN5JKXbXy+r2x6bncAAAAAeKMUdQDWxt4982uaV+/SVo/XNKtj4lM0gsLVSKyLw5W8rIUTF7YnePewynfxbT5XikxCPK2EE1c2RgV+4pSdqLK/tEYkNpIIaemql54bLGTVgqBSqcVSia4nptZe/Ws93LHhwpFE9csFYF353jbCsat/xFYYkrVIWJO463KUYBJQJ4/dsAtftLVbQG3Jrt/v3Hd8oKlY0yVzDraA6sRShamgjErXjZn+qSY9PixNECwK1ZE8Xogi76BWpXkccrVpJy/eihXsB2SG6QIa/9z7ofBvPwAAAABvpCIOwNr00FtXFl8+vvFC6bbezp4KbVTk9ZWX461LN2mV+cFLD/9aXa9snbl5e3TVwLo2cmVixJ5wTctaIRXkgkgikwuq8IiHMS4utmJx3leKPf1rtgvd9uu2rWmVKza0kUTcD10VbvN1m6r+EvNgK9GWO6d/uSWUF4t83F0cCpdMC1l1oHB/6vq/zjgF9/NzLSVLO3Hmyn2JY3+rlx1Cffndr2xZuvXPjGqB1UyU50OPL3xo3KxxULn//GKIjJy7eMoGHTuqUDl97pK1NruA6hTWpQIk1/efvnTaooxDSviyQyfPqwrbkbxeiHJF3EH1wV1bvggObGgruR92Zvb1NI8KTZuZiQtu/Avvh3zefgAAAADefEUcgEWKmnU6bnQ/t+j81Q3HridpBCNT+3pVmn9UwT1rNazYyGV4u7aex46t+Gf7igxBbmJXxy8oa08iuaVPB+eLP5w69HvpDn2sxPlcKVa4fdq2pfuR478e371JLbK08ehQqay3viemTerUPrrryPydf0jMvCe2dW5sUqg1t4WsWiR1fL9upfmnL3299ViKILax8/qoRa0Wpi+9rFckdx7W5m2nI0dWHt6xSi22sfUc0LxGL3eTovhQsyygvI/d1QtxblUrPf6i4PyrExt7fVav3OjDR/utPmpm7dWrdqtx59ePKFwGzuuFEAlF20FpzSp+5mHHRx9PVits3qraalQFR9PCNF704vshzzcVAAAAgDdfMXwGWOrhGfKVZ0hep8VGDh3rtOpY54UTEpt3W/d6tzBX6uowcX23oeu7LxxXWJeb1KncpFwrlrl807v/k2dG9jX/7F/zJauWOLhV+EL3J9fyC1PRk/IVTt3rt+1eP5e7n79e6jimZ/8xOUqv1LDXiXwqN7GxFyTefi459qDKrzrdSZfSdZaXztFV5z7/5Nv4nPJ6IYq2g0bWviMDy498ycYLub0f8npTFdhTAAAAAP/3inkTLLximvDrFy7LS810Lcze1P83/s0eXQAAAADwHALwG0KrvPkg8mbM9XnH4nwqNaxi9LrbAwAAAAAlDQH4DZERtWjnnzsyTCtXaPpVkA2bOgEAAADA8wjAbwi52zfv9f/mdbeiyPHRXAAAAABFhgAMAAAAADAIBGAAAAAAgEEgAAMAAAAADAIBGAAAAABgEAjAAAAAAACDQAAGAAAAABgEAjAAAAAAwCAQgAEAAAAABoEADAAAAAAwCARgAAAAAIBBIAADAAAAAAwCARgAAAAAYBAIwAAAAAAAg0AABgAAAAAYBAIwAAAAAMAgEIABAAAAAAaBAAwAAAAAMAgEYAAAAACAQSAAAwAAAAAMAgEYAAAAAGAQCMAAAAAAAINQsgNw8uERbcefFUzqT/t1bJDxfytLdX/9oPd+ChOcuu1c0adomgcAAAAA+P/xigLw7C6NN8cKZYb+MqeVvVgQNFFbBvf44brg2X/Zj51cSnYIBwAAAAC8EQwnfIpEYtHrbgMAAAAA4LUpAQE4a52zrHyHt61O7zl6M07iUrXLx6N6BFmKn7tQm35339K5y7eduJsitvSp3aHf4E6VbDI7oIq98Nevv2zacyosQS2y8G7Q85OP2via6vKuNuni+lmzVu4PS7H0b1gx+TX0DgAAAABQMpSAAJwl4+KGDTIHT2fzuPD7x5aPm+KybOJbtjkvUD/c883gyYdTdA/Fgibhxv7Fo6/Gfjf/g0BTkSpi15xZv90QBJmpkTo58eaeuZ+blFk6tLw8cvvXoxacVupvT7i0Z/9r6RgAAAAAoEQoMQFYkFYcuWxKE7uEPZ+98+3J9OObjsU0aG7y9LTy5saf9enXpvnkhR9XTP5zzPszT0dsWrC346xWjlLXVp9+7pQeWNPPWnt71YD3l4bHHj1wN72MeMsqffo1rjpywYRGphfmDhi5+eHr6yAAAAAA4HV6RQFYkrmcWavVZj3VajWZj8TSp5/LlVs7mEkEkUWZik7CyXAh6npMhvA0AGvir5zVh1ez4EblLURS81otys48fV64dTw8vZWjiUhh75KxYcFnM05dDotN11//6GGSOiXuQqTuoaxCm1pOUrHKwdlUEAjAAAAAAGCgXlEAttVlz2ghKTJJJTjIBUGdGJGkOyoytTZ+4YO+aqVa/7dELnl2z6rs7JzLRlba5HPzBn3ye4Qgda/RspvF8dV/3Rc0aq0+ZutPi2USdr8CAAAAAIP3igKwfzlL4XZC5PY1+5sMrWsTtfuXv6J0R12CPU1FQnrWJcqYBwmqiurQHXvu654Z+VRwkum3btbvZKXOUIssywbaC9cePjq151JSYIXkw9uv6m/yrOxuJKRf2r47QhCM60z44Ysqqj3Df/3rfmZaNnH1sRYux6VfO3knrZKfkBiT8mo6CwAAAAAogV5RAPbr3LnsjoVXEvZO6bt3SvYxRdUezdx19WcHYNX573o2/y77nEubHsHmumxsXcpaOBObfmjSjLNLBvatsX3yP7F/fNp+u0hQ6yOuY5v+DR0kgtrCxVoQHqX+M//rz38NP3Ihe65YF6Jbt/TYuvJO5LqhvU94aMLCYl9NZwEAAAAAJdArCsAy906Tv1csWLBu3/mIVEFk6hrUqPugPo3sJU8vUZRvFJL8z+GwdLsKbT4Y1dtPoTtmVLpT/8anZu4MT7p3K9G689g54qVzl207eS9FZOldp33/wZ0r6L/rSOrRbmTfyxOXHgs/fVnR8J0OYas23MgsUu7dfdLnyVPmbb4QfS/Zr0H7iuc37uVDwAAAAABgmF7ZLtAiM7+3h3/39vA8L5A4Nh392afGzx6UOr41avFbox4/dW8wYHKDAS+WbVqu66RVXZ88f2/g40cyp7ofzKz7wZMzg8b8u9YDAAAAAP7flZyvQcrasQoAAAAAgGJRcgIwAAAAAADFqAQEYNOa03fufN2NAAAAAAC84UpAAAYAAAAAoPgRgAEAAAAABoEADAAAAAAwCARgAAAAAIBBeEUBWKlUhoeHP3r0SKVSvZoaAQAAAMCgSKVSMzMzNzc3IyOj192WEupVBGBd+g0NDbW1tbW3t9e9JK+gRgAAAAAwNCqVKikp6cqVK35+fnK5/HU3pyR6FXE0PDzcxsbG2tpal35FItErqBEAAAAADI00k1arvXv3rre39+tuTkn0KgJwUlKSg4ODXC6XSCQEYAAAAAAoDrroKxaLLS0tb9y48brbUkK9igCsVquNjIxIvwAAAABQfHSBSxe7dOFLF8Fed1tKqFf0iVxRpldTFwAAAAAYJpJX/tiSCgAAAABgEEpoANZqtbkezPX4/6O8fjHDb2sAAAAAoJiUuACsi7gpKSlRUVGRkZFJSUm6p5pMugcSieR1t64oqdVqXdwVZ9I9MDc3d3BwcHR0NDExIQYDAAAAQJErWQFYl3LPnz+fkJDg7OxctmxZE2PjrHD4Rm6glTWbrYvBWTPbKampMTExJ0+etLKyCgwMfPP6CwAAAACvVwkKwLoQmDXx26BBgyeTvVkpUZvHoug3gDizp7q4aymXW1paenh47Nu3z8nJyd7engwMAAAAAEWoBAVgnYiICF9fX7FY/CZ93LcwsjqrS7xSqbRMmTIPHjzQBeDX3SgAAAAAeKOUoACsC4HJycleXl5Z21297ua8Bpm9Ftna2t6/f1/3mBlgAAAAAChCJSgA66hUKolEoouBBpl/s4nFYt04vO5WAAAAAMCbpsQFYKlEIhh2ApYQgAEAAACgGJSgAKzVajMyMsQSSWb8NdwALJXJdONgmIvAAQAAAKD4lKwArFarxWJx5rf+vu7WvD5isSjru5Fed0MAAAAA4I1SggKwLvfq0q/+UeGWQO+a9P6C0/Fq/UORsa1n+Vptenau5aZ4EzaOytoHu2jLVIZvm/nNipMxJlUH95Gt/Cm647QvGzxaMfSryAHzPw0yLqI6biwt2gJzkX5t4UcT4z6YP6pi8dUBAAAA4I1UggLwY9pCLoGOj4w3qvT+iHYe4tSEB5f/Xr9x1hfJ1nMG+f//56I8+75rdOeFQs+ZE1u7ZL5uKacmDVpR7ptp7V0LfhnTrv22IdR72MI5lU00j64quyYFWImFR0XY6H8r486aT2eqh07tXkr2upsCAAAA4M1W8gKw9vGfQpDZepctW8ZIEAKCAm1u9/v2ytW4DF0Afnhw6bx1/4TeS1QJRt5dJk3s6Bx96JcFq3ZeeKg0dqnU4r1+HSvZpp+eOmBSVLe5U1o6SgRl2Mqho042mTWtnS5ZZtxe/fHI/TWmft/d7sameT/+dvx+qiCz8u84bmyHUnJt2t2/V8xftedKnMrErWq7AYPalDMr6jnnfPoukknvblp2qOan9WzFL1eoJi1Bae7rYiKRyCSW5Ru30B9T/pdWFhVNanyqxvxl7njJngMAAABAlhIXgLPzbyEXAOu/MFirUaXEXN+343KGTa2yVhKtNj3u8tELyYG9RzV0lyvVdnZpZxZ9PuuQfYteo4LMow6vWf7tlxnfTO1Rqkop0aJzd1JbOJhqEq9feKh9cP52ShtncyHp5vlok3IVHbU3Vs/85UqZXmOGlDVOjoo1t5FqNYknF46fe75cj2FflhFf3zp/5eQF7nOGhRRZBM784t98e25crm2ViF9/ORsyJNj8mVpVMcfXzP9lz8X7aaYeIc179Wtb3uJpUEy/tvSz6efT1ec/6bm33hdTmx37NHOhsr/wXAm//rhy75VopYl3g14fvVvD/umbQx136pdZC3ZcT9Iau1RpP6h/c29jUX7X512gOu7sxkUrd569HS84hrTrXSds/g9H47XC6F7bzIKGzxoZYprrXRkPj6yas+Svy3FS10rVrZTC//8sPwAAAIBXr8QF4Oz8m/2ggOsSdo59Z+fj57b1PulYWpG9glpk6VspONBeIgiamL0//p3sP3Dyu/VtdJEwwEN9c+ia9RfajPCt7Kr84+S9tEq+qlvH7wkyTdipO2nV/TW3T4RLfFp7yFU3Y5IFK9+g8qVdpIKPvgZ1zNENh7X1xgx6O0CXwPyc3z0xcNHeG2nBFYoojz1OtHl3XJuhdnv7nTLjl2y8Xu69Mk+PK29vmPTDsfIfThoebP7w4IKJU2aYTvuiqaMk+7RRmV7fjggfsMz3mxld3GXKG8deLDnj9m/fzrtQafh3nwUY3d367Tfz/i4z7i277AKUYb//vM/svR9WVDdPuHEx1t5IlPv1FgUVaHlv0zdTd7m9P/bH2k7K62fuO1TuMEvx9YAlPhNnZi2Bzv2uuxu/+f6wZ//JP9eySzy1dsYpDQEYAAAAwMsreQE4O/8WYh8srWBaffCYDqXk6vTEiND961bPGGf05dTe/pKs+JxdgjLi0j2NY5sy5uLMp1KbcoG2ymOXH2oCK4TYrz5x7qHK/dHx21aNOzr9s/dclNI7/cTVDK+uvqaCokzrVl4TVnwy/FyTlm+3rB9gL1dGhD5QJV37qte+p40oE5uqEYp25638+q1Vq81CenbaNnrR9kYTmzyOzOm3tu+K8e/fuYqTsUjwqNez046hfxyMeKtDIT4bnC395vbdSVWHtgu01GXeUg1beWzefiOloV32LLPExNZCdfLU6Zv+dUuXrmitv/5abtcHF1Bgbas//4oo12tc/VL6gstVs9VdmFJgM2rb7NjzsGzPLzLvMg+uXc5qX1xh+wUAAAAAT5S4AKzNXNactba5wIul5k7u7u5GukeepX0dEy58tm/v7e7lvB4XpdXm+EDx4wK1WlFWLTLnKkEWW4+dj6wYe1koN6C6/71NW85FVkk6+8itub+57hJF6c5fz618bMfvG1Z8/ecfTcZO7CHVagT75qM+aez4eNxEcmvzQi/YLvQI5HdWK4jt6/dpsWPC4oOVWsmlmQlVFf8gxdTHLjuHi82cHeVJ9xNUQuEDsK6E+Lh7C8ePlmeuws5IMnJUa56clTi3+GyM0dq1s4Yslwe16d337UBZvtfnVaAy/kGyuY+zSZ6/L8j1LlVCRLK5p4vpm7C/NwAAAIDXqMQF4OwEXIgArD+d4zp16qMMQSqXPE66j0/J7H1dRIfPXEts6WQt1kWs2MvnY+RuZWylWrl77Urme/ft2pOe7POuh41LVafIfbt3p8a4NA2yzv4aIom5V40Ow6rU2vb58FWbQzv293EUDt6IM+0ZnHMPqqL+xqKCS5O5tehbc98PG2/4ZAZFQWrlZJJ8Pzpd6yXTPdckP4hUmlW2eJnXVmrpaGnl8P6ED/wVuZ6XWJRt8v7njXuE75nz5fSf3OYMzfV6ZXT+BaaHOpo8Co9Ky2pnjh4/HsHc77pkbZQW+0j9Et0BAAAAgBeVuACcI/8WHASVMTcuX0wXK5Pj7p7fvWlfomPLum6yxzOo2UWIrKu0r712yqJZq1RtK5pHH1m7+rZDk74BJrrzRh51Kpvt+WO3Ucgn3gqJIqim49JVuwXPd0Js9Pk3I+KfXZflpdytpMk3rsUJRm7Gcusqbauunblk6oLUttXczTQJD+LsqjfwMxcLqntbvh67Sdbj29GNHaRCxr3NE8b9btJz8qiG9vpnWyaM3Wzc85uxb9kXbgQKJjIu2/G9siNmnUh20M93G3k1bWjz+co1xz16BJtFHVy+9q53h2HOBb62IrFErFWp9DO3Rt7N6pt+uWRttVFdQ+zEj+5ej7Hy9TTPTvnalOs7/rxbukkdHzM7Nydj0R1NHtcXWKBXk3pW45YuP+jSq6aLJuzICWVgPW9TO0XizduJajczrSTXu8xK1QmSfLf5UIR/IydxwpUjl+M1TpntSg/bPGdVTL3BvStbFWZgAQAAABi4EhSAxWKxRqPRap6sgC4gCVo4WKafXjb5tP6x3NK1TNXuYzs28ZFrtconS56zijCt0GfcB4qf1yyZ9keG3DGwxSf9OpQ2ypx1lJdqWMtm985S9X11eVhkE1LbfdVqRaOqdhL9rcrY6wfX7FieqItzxk4V23zYrYxcJKk8cPygX5euXzd7X7ogMnGt1qNi3bJmosdTmNl1Zi291jzz7Oka7AKItBo9kSj/Fb8ii+AeXX2PzY/NfCb36jRmqGbBqs96z0g3cw9u9umIJk92wMqb1CGogvnWeYsuzB0aYOzVaeyHwoJln/Scki6x8KjWYYhXKXOj7DaI5IrEA99/9HNshmDiXrvP0BBzkcw8l+vlBRbo02XsR+r5K0f3ni1YuFdo/I6/1sjn7Y4VJs0f1G1pQP+pYxvldpdphd4j282bN+6D30zNLD2DyjjJkzJHWxV/++qVCL9UQSAAAwAAAChYCQrAusiny8BqjfpxkCwgLtYfOaf+Cwf1d8l8es1Z/vhJJplzrffG1Xrv2csyT3h2+35Vt+wjEsfmk1c2f3La2K/H1/N6PF+43KX2u2Nqv/vcUYlLq/GLWz1+JnVp/dXPrZ8+a/VV5rnCBGBRZv6VSCS5BuBGk5c3evJEYtfwi1UNHz+T2lfpMbZKjxfvyWZS6fMVlbIeyn16/bgs62HggLlrBjwuwa5ytzGVu+XWKGOPer0/r9f72aO5XW9aYIEyxxrvja/xXs5Drk1Hzmv69Glud5mVbTvq+7ZPnmbfbhr04U/Lc2kvAAAAAOSmBAVgIXMSWKVSiXUpsHBLoN88uk4rMzKk0pL1ugAAAADAG6BkBS1d8FMqlQojeWb+1RR8wxsla8pXq1IRgAEAAACg6JWsoKULfiqVSmskf7zHs1C4PaHeACKRKLunapWaAAwAAAAARa5kBS07W9uY6BgzM1N9HNQKmUuhX3ebXonMD/yKsjyMjjY2Nn7dLQIAAACAN00JCsBisdjVzW3nzp2ubq5SiUQQ6bdRFj2ZBX4jk7BIeLzPsp5YJFap1ZcvX65Ro4ZuNF5v0wAAAADgDVOCArAuAZqampYqVWrnzl1Ojo72DvZWlpa6HCiW6P/TpUP9/wv4cqD/G7psr9aotRqtSqP7Wx/14+LjoyKjHkREuLm5OTo6vjE9BQAAAIASogQFYB2JRBIcHOzt7X3u3LnQ0NC0tPSUlJT09PQ3byV01nc+6ege6Hqte2Bjbe3u4REQGGhhYaE78robCAAAAABvmpIVgHVpUCqVWltb161bNyv0vnnRN1eiHB8CZvEzAAAAABSHkhWAs5AAAQAAAABFriQGYAAAAAAAihwBGAAAAABgEF5FABaLxSqVSiaTvYK6AAAAAMCQ6cIXu+rm5VUEYAsLi7i4OIVCwVf7AAAAAEDx0X/Balycubn5625ICfUqArCrq+uVK1d06dfOzo55YAAAAAAoDhkZGdHR0Q8fPixbtuzrbksJ9SoCsEKhKFeuXHh4+MWLF9Vq9SuoEQAAAAAMjUQiMTc39/PzMzIyet1tKaFe0SZYcrncx8fn1dQFAAAAAMCL/tfevcZIVR0AHJ+5M7M7u7CPUHlUhUZjqSIltlSSFoOtrYqpNmlsYqqtFPs0abEmfSSkbRqSNmn8YCVpbTXpN41NW+wDbRNrAuoiC4gIFAoL4sICKxBk3QezszN3ehEhse0Cayazs57fL2SZPTl3zrkf/7knd70FGgAAgCAIYAAAAIIggAEAAAiCAAYAACAIAhgAAIAgCGAAAACCIIABAAAIggAGAAAgCAIYAACAIAhgAAAAgiCAAQAACIIABgAAIAgCGAAAgCAIYAAAAIIggAEAAAiCAAYAACAIAhgAAIAgCGAAAACCIIABAAAIggAGAAAgCAIYAACAIAhgAAAAgiCAAQAACIIABgAAIAgCGAAAgCAIYAAAAIIggAEAAAiCAAYAACAIAhgAAIAgCGAAAACCIIABAAAIQk0DuDBSXvZYx/aeo+VSuZbrVlcmm5l76dSVdy3M5zLjvRcAAAAuVE0DOKnfbT3HM/nWTBTVct3qqsTx1p7jyx7veGTJovHeCwAAABeqpgG8bf/RTHNreiLXbyLZfy4/KbmX8d4IAAAAY1DTAI7jcnaC1+/boiguT+BT3AAAAAHyEiwAAACCIIABAAAIggAGAAAgCAIYAACAIAhgAAAAgiCAAQAACIIABgAAIAgCGAAAgCBM/ADOti5b+pFLnun44WulMV/bOOUnS+fNWN+5bMvJsV8MAADARFKnAdzQNv1bN11x28x8vlLs6ur57ZruzoG4+suMDKxet7f1QLGcii5fuGBFevs9LwwUq78MAAAA468uAzjTfPvn5lx/ZOe9vzl6OGr+2IcvnT89t3FguPoFHBc3bz1weslJzZnMyaovAAAAQL2oywCOGj/UEu98/tieoXIq1b/2xZ1rk8GGKT//+tVvrFr3wOFkMHfDHdd9rXvDkvWDI29dMenimT9dNOvTF2X7ensefKrr2b741NHou6/Obe5tmzNj7pR86uDeH79QvPH6D3xiWlPjsf0/+su+bcOVM8en1/9p7oIHZjdEqQV//+hI5+oXl7/qQDQAAMB7TV0G8Ej/k/8afvCz19z//N4ndp44PFI5z/x0dvbM6InVHT8baLx58fzliwe2/+Hg68l4tvnGy0vf+eP6vZmLVnx13kM3dS//84aHii33Lpn/7dmH7t1WOPNIubwhid4vXHdf76YvOQINAADwHlWXAZwqvfLcxqWHZi25du7vb4hfennvynW9+84xvVJ6ubP7heOl5MJnOnuX3jF9TuPB10dOjb+y+XBXsZJK9286EV+yo+elwUolNbT5WOUzUxtyqcJwzW4IAACA8VafAZy0a7m7a9+Krtd+OW3GN2656uH2+M5/XNCx5PJwYTDV3pZNp0be8XXF+Oxj5EqpXElH6XS1twwAAEA9q9MAjlKpt84nV948cvjh56bdfMtFM7O9yUguOs+FjW2t74sLh4vnOzX9/6RFMQAAwHtXPQZww9TLfnVr6/qOfU/tHxpqbLltfnvqyO5Dw8N7hrKfujifOzjUdMnML74/SnWfvSJ7xZVTP9j7+oHGKfd8cmpx15btw2O9s0p/f7l9+uS2aLA/HRfK1b4lAAAAxls9BnDx2IFfdF72zY9fc/etuahS3NPV/YNne4+WUn9de2jR4mtXzTvZvf/gkztO3nH2gvLJLf3t93/5yrnNpd27dn9vzRuDY16z/O+N+zbeftWq787e/M/O+7YWqnk/AAAA1IF6DOBUpbRnR9f3d3T91/DxV3fd8+tdZ37refr0/6U3V/5u3akPHTvfMTsZf3TtmS8cfvrxNW/PT5U3/W3t5/9nTvF4z/JHe6p5FwAAANSTugxgAAAAqDYBDAAAQBAEMAAAAEEQwAAAAARBAAMAABAEAQwAAEAQBDAAAABBEMAAAAAEoaYBnImiVBynkp8TXCWOM5kJfxcAAABBqWkAz501bVvP8WzTpFR6ItdjHJcKg/NmTRvvfQAAADAGNQ3glXctXPZYx7b9R+I4ruW61RVFUVK/K+9cON4bAQAAYAxqGsD5XOaRryyq5YoAAABwmpdgAQAAEAQBDAAAQBAEMAAAAEEQwAAAAARBAAMAABAEAQwAAEAQBDAAAABBEMAAAAAEQQADAAAQBAEMAABAEAQwAAAAQRDAAAAABEEAAwAAEAQBDAAAQBAEMAAAAEEQwAAAAARBAAMAABAEAQwAAEAQBDAAAABBEMAAAAAEQQADAAAQBAEMAABAEAQwAAAAQRDAAAAABEEAAwAAEAQBDAAAQBAEMAAAAEEQwAAAAARBAAMAABAEAQwAAEAQBDAAAABBEMAAAAAEQQADAAAQBAEMAABAEAQwAAAAQThPAEdRVC6XM5lMbXYDAAAA705Sr0nDxqn0aBPOGcDpdD7f1N/f397eXv2tAQAAQPUk9Zo07EChNNqEcwVwks4NuXxf34nkc0tLi+fAAAAA1KFyuZzUb19fX0trW2YkHm3auQI4Kd6+gYHJk1sLhcKJEyfieNRvAQAAgPESRVE+n580uaVvYKihIT/atPMEcD7f3D84NDxcLJVKAhgAAIA6lATwyZFCY2Pc1NSczY7auecK4HQ6nVzZ2NCYfCiXc8lIpVKp/k4BAADg3UqKNXXqCW7UkGtIGjaJ4dFmnv8t0PmmpuRflTcIAAAAteXvAAMAABAEAQwAAEAQBDAAAABBEMAAAAAEQQADAAAQBAEMAABAEP4DjyOelXSKLd0AAAAASUVORK5CYII=)
This view file can be created with bootstrap css. I am just pasting the form below:
<section class="content">
<div class="row">
<div class="col-xs-12">
<!-- <div class="container"> -->
<div class="box">
<div class="panel panel-default">
<div class="panel-heading"><strong>Upload Excel Sheet of Students</strong>
<span class="pull-right">
<a href="#">Download CSV Format</a>
</span>
</div>
<div class="panel-body">
<h4>Select files from your computer</h4>
<form accept-charset="utf-8" method="post" enctype="multipart/form-data" id="StudentImportForm" action="/students/import">
<div style="display:none;">
<input type="hidden" value="POST" name="_method">
</div>
<div class="input form-group file">
<label for="StudentUpload">Upload</label>
<input type="file" id="StudentUpload" style="height:100%;" name="data[Student][upload]"></div>
<div class="submit box-footer">
<input type="submit" value="Submit" class="btn btn-primary"></div>
</form></div>
</div>
</div>
<!-- </div> -->
<!-- /container -->
</div>
</div>
</section>
Now your form is ready to use, now lets select the excel sheet of students in the following format:
![](http://findnerd.s3.amazonaws.com/imagedata/4412/4412.png)
Leave the 2nd row and start entering the data from the first column “First Name”, second column “Last Name”, third column “Gender”, fourth column “Date of Birth” in Y-m-d format and the fifth column email.
Note: In Excel sheet please format the cells for Date of Birth as text as shown below in the screen shot
![](http://findnerd.s3.amazonaws.com/imagedata/4413/4413.png)
Lets begin and create file index.php and write the following lines of code:
<?php
ini_set("display_errors",1);
require_once 'excel_reader.php';
require_once 'db.php';
$data = new Spreadsheet_Excel_Reader("students.xls");
echo "Total Sheets in this xls file: ".count($data->sheets)."<br /><br />";
$html="<table border='1'>";
for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file.
{
//echo "<pre>";
//print_r($data->sheets);
if(count($data->sheets[$i]['cells'])>0) // checking sheet not empty
{
echo "Sheet $i:<br /><br />Total rows in sheet $i ".count($data->sheets[$i]['cells'])."<br />";
for($j=3;$j<=count($data->sheets[$i]['cells']);$j++) // loop used to get each row of the sheet
{
$html.="<tr>";
for($k=1;$k<=count($data->sheets[$i]['cells'][$j]);$k++) // This loop is created to get data in a table format.
{
$html.="<td>";
$html.=$data->sheets[$i]['cells'][$j][$k];
$html.="</td>";
}
$data->sheets[$i]['cells'][$j][1];
$first_name = mysqli_real_escape_string($connection,$data->sheets[$i]['cells'][$j][1]);
$last_name = mysqli_real_escape_string($connection,$data->sheets[$i]['cells'][$j][2]);
$gender = mysqli_real_escape_string($connection,$data->sheets[$i]['cells'][$j][3]);
$dob = mysqli_real_escape_string($connection,$data->sheets[$i]['cells'][$j][4]);
$email = mysqli_real_escape_string($connection,$data->sheets[$i]['cells'][$j][5]);
$query = "insert into users(id,first_name,last_name,gender,dob,email) values(NULL,'".$first_name."','".$last_name."','".$gender."','".date('Y-m-d',strtotime($dob))."','".$email."')";
mysqli_query($connection,$query);
$html.="</tr>";
}
}
}
$html.="</table>";
echo $html;
echo "<br />Data Inserted in database";
?>
Next Create configuration file db.php
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'amuk');
define('DB_PASSWORD', 'yourpassword');
define('DB_DATABASE', 'databasename');
$connection = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>
Now, create file excel_reader.php. I have attached this code, you can download it, the file name is excel_reader.php. This is library for reading excel sheet file. Click on the link below to copy the code:
excel_reader.php
After clicking on submit button you will be able to upload the excel file and if all the records are inserted successfully into the database then it will be displayed on the data grid view format as shown below:
![](http://findnerd.s3.amazonaws.com/imagedata/4414/4414.png)
Hope this blog will help you to upload excel sheet into the database. You can display the data from the database and display in the html page.
Thanks for reading the blog.
0 Comment(s)