一，列只读
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVMAAACrCAIAAABUn+jjAAAOYElEQVR4nO2dvXHrOhCFXcutQVW4DRag0FVorPjmypUocgtvxjMKVYGj2wJfIP4A2AV/lhT3wDxfZEMieHSIQwC0vX6rCSH7481bACHEASafkD3C5BOyR5h8QvYIk0/IHmHyCdkjTD4he4TJJ2SPMPmE7BEmn5A9wuQTskeYfEL2yArJ/48Q4oF/8v8VCKZsTFXu0BYJk28EUzamKndoi4TJN4IpG1OVO7RFwuQbwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtEibfCKbseaq+z+9/3s/fL9Dxip4X9Il5sVZgmSe/IPnX45+Q43Vxj6NMkC0uy/X4am15VZpFr0v+K1g3+d/n98iQcnwI2XXyr8ck69/n9w0u4yTZ3+f3Xlr0zYvQVeUs2nvy+96+z+/bTBgrs+PkD330+Lbevut5xPm4cHUwUXYX9yT3gbZk/C0SrKnKWxT1HPWuK0le6JplY3hO9ZBUhvKZtbNop0zeoBk1mvz4OiXt7+fv5ovj8b07Z6egeXdqZiQg8xHzl3UTT0pO/uR5tL+pP/1ZfH+fLPt6/PN+vkY6xfVS1NgEZ4Z45uCk58xmJJgPr8dId76x/4TqISHhWa/H41U0tV8HruXfoBs1ac4XZ4m+/T6//wlPL6TEZ78e04ynl3vosm7kyS6Sn72pW5ku+2l+cMowDP+yuxOT4PnJ10Z5tgf13qA1RskfvEKJGbqq2IeJ03XAhH1+K3JwzleiPKoqd7kHLutWnvzi5CeX1yf54ozJw7ZwHbZU8HrJ15TE2vsjZWPYlXpIzpsBVUOjfCRL46v9aOpeK/n9vU+53GObsA08KTn50++cfnO+lnxVwAqCLft8fbCq09dYr8MDTm30nPO1i7JW8vu1TuZyc85/1bN9uZFDSb5o+L5excWzCV70bD8zjHol/67HaKJvbxOyMbyJKIek4tbb0y6e8+PtSb+jn5f8wLNpl9vFk8KT337SP3JNGa4zj0eYOb9tk4oXC5768/xnfwOrfVVJ3Escj7gxGZHikJwXyq4nSpO2GdHfMGZLus8PpAWKj+dZc77enzjb2D5/K09+QfIdwJSNqcqdLWxZaUbZDCbfCKZsTFXuMPkSJt8IpmxMVe7QFgmTbwRTNqYqd2iLhMk3gikbU5U7tEXC5BvBlI2pyh3aImHyjWDKxlTlDm2RQCSfELI9/slf3sn2YMrGVOUObZEw+UYwZWOqcoe2SJh8I5iyMVW5Q1skTL4RTNmYqtyhLRIm3wimbExV7tAWCZNvBFM2pip3aIukqOT/fH1+fH79LD/nCmAOplTV43R4O5we4n259gEMh8BAWyR4yf/5+vz4+Pi43KOW4FsMpHGP0+Gtp7qpr0SDZEJ72I1BFYd4Xde0RQMz+ZfLJch+Gcl/nA59TMPxcKv6AE/4Ojz0cTrMCz+HuAptkYAm/x4u7Lvkp40t3Q5Aawzb4tbPr69L98LcW8uIcY/ToYnsrQpHxmh7/4bk/SZVj9Ph7VBVYgkRjNd4qZJIClrFHamg8U5bJKjJD2d6Jfn3SxT35/vURtF331UQ9/tlbvZHjOtyncwJ3bdD7WHU4xvEXFXxWOxXFpmZKlhjxCuS6hYcEr5UBrRFgpv8Po568mVSJ8RXXT7Ibw2yQ8JFei7J2YTfqnDemLmYHFnWdoNzaLlb3WrthtMcUtj4fkJbJMjJb/OoxvV+kYt9vTFZ7786+cnefO6cX6cLzVkjamSI62dPzlfd1Ah07yplORtAWyTQyW8SebnoE3XwlnxjuAV4/ZwfT9ht05x9vuxwxSd8yuSWkaFPbm/N8ras2Y22aIAnv5vGxWo/mujzjXGk433+2snPrPhmPtsPmP/ceHCIB6uRzNJj2oa2tB0tbdGAT374LC7IZ7Cuj5/TyWf14RYgt3xYIfm36i1BWzdO+Xl+39PscaQ+ylL2DelPHVsVVdXPXMlvFci0lLO+pS0SvOQXAqZsTFXu0BYJk28EUzamKndoi4TJN4IpG1OVO7RFwuQbwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZIIJJPCNke/+Qv72R7MGVjqnKHtkiYfCOYsjFVuUNbJEy+EUzZmKrcoS0SJt8IpmxMVe7QFgmTbwRTNqYqd2iLhMk3gikbU5U7tEVSVPJZdXuMVNWKpSZLhrZI8JLPqtt1bf5LXQ5xFdoiwUz+nqtuG2pt51VxiNd1TVs0QJO/36rbswtwDaoaLS89UA5wcE1SFrRFgpr83Vbdrm/V2+HQ7xuWV+MaLC+dH+Ki2Ew5haYEtEWCm/ydVt3OVoAzqRotNTl4AwpuOo/T4RfNb7QFO/m7rLqduyPYVI2efWiIp5Q6u9EWDejk77LqdhL1VZNvn9zKhrZIwJO/x6rb4d1j7sPmwSGulZeORd+q/slCeurH7VbsiKctEvjk77DqdtjXzAlGfZSlLEwz5aWrU+4h9u96jk1bEJNfCJiyMVW5Q1skTL4RTNmYqtyhLRIm3wimbExV7tAWCZNvBFM2pip3aIuEyTeCKRtTlTu0RcLkG8GUjanKHdoigUg+IWR7/JO/vJPtwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtEibfCKZsTFXu0BZJUclfver2gg4xB9MiVbm/Ti+f1JYVK3AW6xVs8sO/uM0U0lnOqslftep29/KyOnyzYPKZ/Mm8Jvn3S1IM9+fr8/PrBzv561Xd7ro4HOaOKiZfhcmXACY/H8dcqeyo/fIlivo0vcma3ErFnoHi3FF1zxHjFlTdrptXq9v8UZWoSnoNT6msN/TkawuTsN/c10ioyR+quj1QfiPxI/TKsEjzAy/5A/9XI1cqO2mPau/dL30lX1GTO0h+dBOIyvXpBX1HjLNX3W6Orm6W+USoCsPeF/LXS0dr2jILkz7izyD0XyMGf37V7Vq+vbtfB35Ut1wBL3yKS75WQkusErqUB51pNblzhTrb7cXA+mPIuCVVt8NKziskP74F9f/LQysdPakEbdLF43Q4nE7NLWXJ/wh5KSOrfVmBM6H74LIAZ3NIYbGvf2vy207aAD+RNbnjAv4Jban/mclfXnU7mo0X7/ObURv2mykdPaP4dJuBptdn5HHr0o4kf3SbIxyKuyqyHh9e8kf3+VOS3/13PrUj5cC7/ta5yV9edTsZb+LnBMNoqh6nw1tVhWfLRHTOnP+c4E/t7ST6Bo/5c37m6uhzfnNnLWvSB0z+5Gf7Q8mXnYzU5E77+Lnf5672V6q63bPKnN/0Ln7MKEtHz9jn1+0tKqpUixr8+VW3Y4Om7fML2+hDJr+u0+W39ih+JPli16DU5M4+229POSP5a1bdDl5fI/nafKQ8u57+bF9RBz3s1Sd8ypoqU3X7UFXxzy9yG4CSHu7DJn8p8RZ/fQr6Hb4H7jJ8IzAvli+/NfmZfft6YA4mTRXug7fNwLxYvvzW5L8cTNmYqtyhLRIm3wimbExV7tAWCZNvBFM2pip3aIuEyTeCKRtTlTu0RQKRfELI9vgnf3kn24MpG1OVO7RFwuQbwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtkvKTv3pZzmlgDqbZqlasRQkM5sXyBS75smjWQJGe9mWI5M+vuv0k/YuafD8WVSOMJvxX3AKYfAlc8kX0R4IPk/zZVbeDPwFPquJla3nNVzUGk79X8JKfRD8KvlIXu0t+cocI/kxXO2p92TFTq2uPRWtmkadU1Wh57OfZT1W6xmhU6bWnxyqKwKFerLiUSlCSpHGjrbshPn9yTQr9K2jA5EfRD/MctvdfR7X0worcTcr1o14gO2K06nadb1H7MaoaK48dttZaRTohT6/YjY2+NZOVThM35CHK3Ry24PAIiMlPYq1WzopL4vch70tsp/eFOulvfdkdU6puR2/OhDsp42tSNVIee7QKbSovU7EbG2GLXIjpt7kIrW55Ibc+Bcjkd9EPgzqlCF870/e3gNxRL5Fd1/Xkqtt1vkXtx6xquDy2Jfkp+CNf2wRNTH6mZJ9Sy7wwMJPfRF/s8Ufm/Db6wbJ/4zl/RtXtsEWMHqUfs6rB8thL5/wysM75A9dO1jIvDNDk1/fLx8fnZxzTsX1+255W295qnz+z6naDTP6CMraamYPlscdnv1SNXrEbG3UTFFfTzf1/AbX2dtdFAeudHKjJbyKcxHTo2X6tfps7an3ZhqrbytPlwX4MqtrT58pjT1j39uqVZ/tlPN7PLIXaD9AV1dbvwuJtT8rd4td1DZx8dDBlY6pyZ+oPYuZQ8Ba/rmsm3wymbExV7mS2ZkueURb5vCOEyTeCKRtTlTu0RcLkG8GUjanKHdoiYfKNYMrGVOUObZEw+UYwZWOqcoe2SCCSTwjZHv/kL+9kezBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtEibfCKZsTFXu0BYJk28EUzamKndoi4TJN4IpG1OVO7RFwuQbwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtEibfCKZsTFXu0BYJk28EUzamKndoi4TJN4IpG1OVO7RFwuQbwZSNqcod2iJh8o1gysZU5Q5tkTD5RjBlY6pyh7ZImHwjmLIxVblDWyRMvhFM2Ziq3KEtEibfCKZsTFXu0BYJk28EUzamKndoi4TJN4IpG1OVO7RFApF8Qsj2OCefEFIcTD4he4TJJ2SPMPmE7BEmn5A9wuQTskeYfEL2CJNPyB5h8gnZI0w+IXuEySdkjzD5hOwRJp+QPcLkE7JHVkj+X1I+y4cBKQsmn/z9y+Tvj/8BBzB1rDzb8rsAAAAASUVORK5CYII=" alt="" />
js代码：
var container1 = document.getElementById('example1'),
hot1;
hot1 = new Handsontable(container1, {
data: getCarData(),
minSpareRows: 1,
colHeaders: ['Car', 'Year', 'Chassis color', 'Bumper color'],
columns: [
{
data: 'car',
readOnly: true
},
{
data: 'year'
},
{
data: 'chassis'
},
{
data: 'bumper'
}
]
});
二，单元格 只读 (当前的单元格为'Nissan'时只读readOnly)aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVYAAAC2CAIAAAAN/jLiAAAPfUlEQVR4nO2dPXLruhKEvZazBq3C4dsCF6DQq1DZdfegXIkib+FWucqhVuDopC/EDSSRAGbAvwE5TbO/cnAMS1CrCTRAyJ7zEgghO+bFWwAhxBNGACG7hhFAyK5hBBCyaxgBhOwaRgAhu4YRQMiuYQQQsmumRcC/hBAPFpr/YUYE/N0gmLIxVblDWySMACuYsjFVuUNbJIwAK5iyMVW5Q1skjAArmLIxVblDWySMACuYsjFVuUNbJIwAK5iyMVW5Q1skjAArmLIxVblDWySMACuYsjFVuUNbJIwAK5iyp6n6+nj98/rxtYCOJXo29Il5sSpg82Sh+R88IuBy/BNzvJh7HGSEbHF9LseltZVVaRYtFwFLUDcCvj5eE0O240MMI+Dv38fYjifW18frCtdzlOyvj9dOWvLNQuiqShbtPQK63r4+XtdZOSrDCOj3IA3656Puz/g4GvcLI2W38z4LgEhbNhBNgjVVZYuSnpPedSXZD9pm2Ri/pvqUXIbynrVX0V4ye4Bm1GAEpNcpa3/9+Hr843h8bV+zVfB4dG5mIqDwFsuXdRVPFpr/YdUIGL2ydjF/N8qc+KNlX45/Xj8uiU5x4RQ18wQXxnrhyVnPhfuUaIW8HBPd5cbuHapPiYlf9XI8XkTT89+Ra+UH6EaN2gWIV0m+/fp4/RO/vJCSvvrlmE/2/HL3XdaVPFlo/gfMCCjG/FzGy75fhegl41nxt3jjMkvw9AjQhnuxBzUktMYkAnqvUGaGrir1YeQCHjHiLOApsncXoMzpQVWly91zWdfyZKH5H5AiILvOPhEgXjE7mYu3aFbB9SJAU5Jq754pG+Ou1KeUvOlR1TfcBybV8I1AspjXioAuBJXLPXR/toInC83/AHMWkGap3y5AiwBVQAXBc84C9FGrLmhDvfaPPLXRcxegXZRaEdDtfgqXm7uAlqU+EZA3eygRIBq+LhdxFecJNn0iUBhPnZK/l2Oy9D/zQjbGaaI8JRdX777XvAtI71y6u/5pERB5Nu5yu3iy0PwP/r8X0L7leAt6PMLsAp5tUrFZ8NjfC7j313MjoCpJe0nnSdqYDU3xlJIXyg1RMq20+xT9AUO25GcBkbRI8fFj0i5A70+82tBZwFqeLDT/A3870BFMVe6sYUulpWU1GAFWMGVjqnKHESBhBFjBlI2pyh3aImEEWMGUjanKHdoiYQRYwZSNqcod2iJhBFjBlI2pyh3aImEEWMGUjanKHdoiwYoAQsj6LDT/w4wIWEjHomDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkWwzAn4+39/eP38mC1oCzFGVq7qdDi+H0008rtTew4ynwEBbJMAR8PP5/vb29nb+TlqibzGQDt5Oh5eO5qr+JBktI9rjbmao4lgPIdAWDfAIOJ/PUQhsIwJup0M3X+OBcW26mTzi3/FTb6fDtBTgWFehLRL0CPiO9/xtBOSNT9qbA60xbktb3z8/z+0PpmbMgIO30+Exd69NPEQG27sHZI+fpep2OrwcmkZsKqKBm25eMklRq4imDQ182iKBj4B47Vci4PuczPv749RG0XfXVTTvv89TQ2DAwXaCZ6tE+21fezzn06SYqiodlN1eo7B2RbuOdI/SXKOnxD/aBrRFsoEI6OalHgFyyo6Yx+qGQn47Q3ZMvH8vTeniVL828UoycZ85sONtR2nfTri5Bi15Hk/Z2EC/Q1skm4iA58RU5+33Wd4H6I3ZrcDSEZDdv0/dBYR8DzppaA2Mdf3Vs9drrupcaB+1lZ1uBG2RbCMCHlPzfNaX7ugh5cb47mD5XUC6hD+bppwFyA4rHgcqy11Bhr7cvTx2vtta72iLxlYioF3YxY1AsvSXG9O5nZ4F1I6AwmZw4icCEdNPm3vHerQ/KWxGxt30bu2ul7ZobCcC4oO7aKJGW/70UE+e8Md3B6UNRYUIuDYvGdqWcszvBXQ9TR5Q6rmXckuRf2j5VNE03VqW/XaCnDbb2frSFglwBGwETNmYqtyhLRJGgBVM2Ziq3KEtEkaAFUzZmKrcoS0SRoAVTNmYqtyhLRJGgBVM2Ziq3KEtEkaAFUzZmKrcoS0SrAgghKzPQvM/cBfgCKYqd2iLhBFgBVM2pip3aIuEEWAFUzamKndoi4QRYAVTNqYqd2iLhBFgBVM2pip3aIuEEWAFUzamKndoi2SbEcAi4kPkqirWydwytEUCHAEsIh7C7D8Y5lhXoS0S8AjYcxHxGaXDy6o41kMItEUDPQL2W0R8cq2wXlWD1bJ7Shj27lK2BW2RwEfAbouIh2vzcjh0txT2wmG91bLLY12Uw9lOTSwBbZFsIAJ2WkS8WLVulqrBOpm9SRSlz+10+EUrHm3ZSATssoh4KRrmqRp89b6xnrPV9Y62aGwjAnZZRDyb81UjYP5yt21oi2QrEbDHIuJxjEw9ou4d61q17FT0telOH/KXvl2vmx36tEWynQjYYRHxuK+JS4567qXsWQvVsptT6ej7d51+0xboCNgImLIxVblDWySMACuYsjFVuUNbJIwAK5iyMVW5Q1skjAArmLIxVblDWySMACuYsjFVuUNbJIwAK5iyMVW5Q1skWBFACFmfheZ/4C7AEUxV7tAWCSPACqZsTFXu0BYJI8AKpmxMVe7QFgkjwAqmbExV7tAWCSPACqZsTFXu0BYJI8AKpmxMVe7QFsk2I6B6dUdDh5ijyqSq9Nfy2ye3pWL50M16hR8B2d/ephUdalE1AqoWEW9/bKsdOAlGACOgEuYIuDZyDh1ON+wIqFdEvO3icJgqjxGgwgiQIEdA2dT7T05NvtQm7c0prb7XlXqKl2mtvK+yKKc9x3N0wEFDEfGn6uY6fXhlqm4lK3rebB4B2lYl7rf0byTUCOgrIt5TFyTzI/ZqxrbND+AI6BlGd/eTek7tDUI8Q+Oh3lblz8Z/fmehF4fOey7LzphfRDwSbY6AghU9bzbXVtiqdBcpdgg1AaYXEQ/y4e0oivxorqVaY/hsNwJGTKdsAnb/Q4fod7A4dHkS9jkYDZliReBypeBbW5i6QgSUrOh9s305lXVxOx0Op9MjWyz/CcqiDNwIyPKhGe0bl9VDH0/Z2PwPvz4Cnp3ckjLv0QmjmGOF4tAzIiCe/+M1x+3J+mw+C1CsGHqzY7Yq98nw6PU+93Gr6w5EwOAdUM9waB8F+taLAEfA4FnAmAi4D/ymMCaVJxaG79QIsBcRzwaePIToRVMlrRh6syN2Afcl//TMleQbPKbvAgpXR98FPCJ2W9sA5AgY/YlAXwTITq6NnAOls4AQHsWhJ0VApSLiyduu8omA5mffmx0+CwjPrIo/9sBdCHsjINq2FUbUuLOAjR0GYEdACPlmddLRWvfT5ILEPWrHYtoh8IQIqFlEPH+Do9HN1Faovjdb2g/Lm60kVXHHv3ocqOyysjud9n03TfqpR+neID1mxAY/AqzcFt6Wbui3A5e2Ah/Mi+XLr4+AxY+mMEeVpgr3lG41MC+WL78+AhYHUzamKndoi4QRYAVTNqYqd2iLhBFgBVM2pip3aIuEEWAFUzamKndoiwQrAggh67PQ/A/cBTiCqcod2iJhBFjBlI2pyh3aImEEWMGUjanKHdoiYQRYwZSNqcod2iJhBFjBlI2pyh3aImEEWMGUjanKHdoi+UURMP3P6aqAOaomqPr5fH97//xZUg0MtEWCGwHyj04HijHARED6F6hjiojfyf+Mp9zPdFU/n+9vb29v5++kJfp2H9AWCW4EiAwYKseCEgG3qUXEoz9Jzyr5FcuOTVb18/n+dj6fo9G+v7EeaIsGcAQoxWmSkg5aPY5nSSG9YPZQZY5ZDDg4WCAseWRZ1sR6VOpY/443t+1YzxuftLtgrTFuS1vfPz/P7Q/QJhNtkSBHQJIB8RTQl9Ok3ltc2W6w9JWJAQcHi4iHcovazzxVz5HdLXLKWP8+JwP8/ji1UfTddRUN8O8z2GinLQrQEZDNb7XIV1pvs5vtXY1rtTJ8vSKPfQ7GRYTzVxRzuicCsmLEM1R1Y/w5APWxLsfmiAGrrpzyWwBoiwQ7AtoMiOfPmMKBz/lV+E8zah4cFB0cWUQ8lFvUfuapim5xHyNQHaDfZ7nh1RuzPe8WxnqgLRrgEfDIAHEOMLALeGZAdEew8i5gQhHxuEUtfzwnqnrG+mMMns/6GhU9pNwYb4M3s9wF2qKBHgH3OXAQe+jes4Bne/pR2npnAROLiD+QEWBQ2TvW2xVM7HiTNa7cmA7i9KYXd6wH2qIBHwGPuaxMl9InAkH9tvQsM+oHGROLiGuF0vv6ma4q/6wrOqGKRmS0t01Pr+RRdrwNLq2cYGM90BYN/AhAB1M2pip3aIuEEWAFUzamKndoi4QRYAVTNqYqd2iLhBFgBVM2pip3aIuEEWAFUzamKndoi4QRYAVTNqYqd2iLBCsCCFmU//3zf37Jr4Xmf+AuwBFMVe64TzbMr+UMZwS4ganKnaVH/OZgBFQAUzamKncYARmMgApgysZU5Q4jIIMRUAFM2Ziq3GEEZDACKoApG1OVO4yADEZABTBlT1AF9odri8IIyGAEVABTdq6K1bJDCIwAASOgApiytQjYe7XswAgQMAIqgClbjYCdV8sOjAABI6ACmLL1CNh3tezACBAwAiqAKbsUAXuulh0YAQJGQAUwZZcjYL/VsgMjQMAIqACm7J4I2G217MAIEDACKoApuzcCdlotOzACBIyACmDKHoiAXVbLDowAASOgApiyMVW5wwjIYARUAFM2pip3GAEZjIAKYMrGVOUOI2BlGAFuYKpyhxGwMowANzBVucMIiFmhgiAjwA1MVe64F+oE+VLdWMJwFhEnWLjPPZCv+4xDjIAlRCwNpmxMVe7QlhhGQB0wZWOqcoe2xDAC6oApG1OVO7RlZRgBbmCqcoe2rAwjwA1MVe7QFsminjAC3MBU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RMAKsYMrGVOUObZEwAqxgysZU5Q5tkTACrGDKxlTlDm2RYEUAIWR9Fpr/YWoEEEJ+GYwAQnYNI4CQXcMIIGTXMAII2TWMAEJ2DSOAkF3DCCBk1/wHGpbpW4WIyTwAAAAASUVORK5CYII=" alt="" />
var container2 = document.getElementById('example2'),
hot2;
hot2 = new Handsontable(container2, {
data: getCarData(),
minSpareRows: 1,
colHeaders: ['Car', 'Year', 'Chassis color', 'Bumper color']
});
hot2.updateSettings({
cells: function (row, col, prop) {
var cellProperties = {};
if (hot2.getData()[row][prop] === 'Nissan') {
cellProperties.readOnly = true;
}
return cellProperties;
}
})