Excel 转键值对 JSON
把 xlsx 里指定的两列转成一维键值对 JSON:可选键列/值列序号、可选跳过表头行,空键行会被跳过并计数。解析在 Rust 编译的 WebAssembly 里完成。
浏览器本地运行所有计算都在你的浏览器里完成,数据不会离开本机。
xlsx 的 base64
键值对 JSON
一维 JSON 对象文本;数字值保持 number 类型。
正在加载解析模块…
粘贴 xlsx 的 base64 后开始转换
键值对: 0 · 跳过行: 0
这个工具能做什么
- 把两列的配置表转成 JSON 常量。
- 从导出的参数表生成一份键值映射。
- 核对哪些行的键是空的(看跳过行计数)。
示例
输入
UEsDBBQAAAAIAAAAIQCWWBSuHgEAALACAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sjdJLasMwEAbgvU5hZt8ozqOUIiu0hJ6gPcDUnsTCeiEpdnL7UqeNK0OgWgn++T8tRmJ3NrroKUTlbAXlYgkF2do1yh4r+Hh/e3iCIia0DWpnqYILRdhJJgYXutgSpeJstI0VtCn5Z85j3ZLBuHCe7NnogwsGU1y4cOTRB8JmLBnNV8vlIzeoLLDi54zSc/iP5Q4HVdPe1SdDNl2xQBqTcja2ykeQN5aJ8c09JpRMBDcUoYISJBP19+2lhCJVEFMAKXrZ0UXwXgpey2v+muc96hP9TjDBgxsmdTWpq6xl0dCMzQcCGQzdPXc9ueushtq3OIPXY1LeszaTtcmsT0pzKh9Ig7uHbid0m3VmYB7GTnlPzRxlgv/dGL/9Ncm+AFBLAwQUAAAACAAAACEAfGJbUKoBAADdBQAAEwAAAFtDb250ZW50X1R5cGVzXS54bWy1lM1u2zAQhO95CoHXQKScAkURWMkhTU/9CZAU6HVNri3C5JLgMrb89oWo2HGB1HZQdw/SQZydb4cip7e9d9UKE9tArZjIRlRIOhhLi1b8fPpSfxIVZyADLhC2YoMsbm8upk+biFz13hG3oss5XivFukMPLENE6r2bh+QhswxpoSLoJSxQXTXNR6UDZaRc56GHGJtc92x2jdbrtVx/KMKrppmoX9++Ppbe4qIaa6uxxzW1pWEAjeKmqKefcQ7PLlf3fUYa5+69E9XdiDVM1gqI0VkN2QZSw1f1d/HM0gHxioz0XGOv0UnuELOcWYK0kR50CvcEM4dGerB0yCSh4yMuf8Zev0QuE7qyhjsb+XJ/lh8rTMkarB4g5e/gsRWqd2od0nIWwlIOa7eBv9R7AMJ8bjWaoJ89UpYcE4IpCfhtEsPU+0ivdQiuaFmV1+QtyjOz7jxPSS936HF8jmz/wlHanOLKeeOQ/++OFYuTYDpIaB5zsrQYmc753+z1Pgpjgn5IIbLSIeH7SbZHaFDXMYWIKdsTMtjZQoxn3hMcrgSD5g2cqSqX8utJ+g1QSwMEFAAAAAgAAAAhAMyQ6hjnAAAAWAIAAAsAAABfcmVscy8ucmVsc63Sz0oDMRDH8XufIsy9m20FEWnaSxF6E1kfYExm/7BJJiSjpm8viKgVLYLO+ceXz2E2uxq8eqJcJo4GVk0LiqJlN8XBwH13s7wCVQSjQ8+RDBypwG672NyRR5k4lnFKRdXgYzEwiqRrrYsdKWBpOFGswfecA0ppOA86oZ1xIL1u20udPzfgS1QdnIF8cGtQ3THR3+I6kKBDQW050zJlTpRlogKqwzyQGHBsbzOn8rpoavCgfxBd/F7EfT9Z2rN9DBTlOxhVoejInTdhSmdJq/8knS4+NNXrZ87zA/P8jtEnf7BdqLd7AVBLAwQUAAAACAAAACEAY3OPKC0BAADYAgAAEAAAAGRvY1Byb3BzL2FwcC54bWydUl1LwzAUfd+vCHnfso0hMtIOQUR8cbCpzzG9XYNpEnKvpfPXS9utW6eimMdzk/N1I1d1aVkFEY13CZ9NppyB0z4zbpfwp+3d+JozJOUyZb2DhO8B+SodyXX0ASIZQFaX1mHCC6KwFAJ1AaXCiQ/g6tLmPpaKcOLjTvg8NxpuvX4vwZGYT6dXAmoCl0E2Dj0hH7Gz07IvK/qvQOZ14xWft/sAyNOWXN6EYI1WZLxLNwUAPWykOAe7a/egmibWykTsoBauaFmBJh8Zmg9I+JyzV4XQKCS8UtEoRwelwZtuMhwchzYgxfTFxzds/KAUPTgkEj8x/SphFumsfW4Wf+Hs0DbnoQ7xtQ+5NWQBH/O1inTELvuZnffTZjruoc/YL2GY+hsPF4JSnL7iyfsnUEsDBBQAAAAIAAAAIQA8yE301gAAAIgBAAARAAAAZG9jUHJvcHMvY29yZS54bWx9kEtLAzEUhff9FSH7yc1UEBk67c6VgqCC25Bcp8G8yL06038vHWk2LZ7teXxwdoclBvGDlXxOo+yVlgKTzc6naZTvb4/dgxTEJjkTcsJRnpDkYb/Z2TLYXPGl5oKVPZJYYkg02DLKI3MZAMgeMRpSuWBaYvjMNRomlesExdgvMyFstb6HiGycYQPnwa60RbkR1/qjONso5buGddNZwIARExP0qgfZsow10s3C6sC/oOj5VPBm+2I21EK+Bed5VvPdGt1q3cPH89Prekjn0/lQixL2DfwLUEsDBBQAAAAIAAAAIQAkoEte4gEAAOAFAAANAAAAeGwvc3R5bGVzLnhtbLVUy27bMBC85ysI3mNZQlq0gZQcUhjooUGAuEWulLSyCSy5ArkypH59oZf1sAO0aOvTcHc4sw9T8WNtUJzAeU02keFmKwXYjHJtD4n8vt/dfpLCs7K5QrKQyAa8fHy4iT03CK9HABa1QesTeWQu74PAZ0cwym+oBFsbLMgZxX5D7hD40oHKfXvJYBBttx8Do7SVN2L269TuT/w7glQUOoMvlFUGLPeKOWUvjkr/Y9+U4OVDJx4XZNmLjCrLiQyH6DkzHbuQ/ylOChMZRjJYpTJCcoKPYKDVWaetMtDffVKoU6cvGIUyGpuecynf9TooGG3JzRlxMNXaYz92pxHP3UWL7jTiyqNUzODsTiOKAbejSqQlCyu/xe0/Ejs41YTRh/f0ejzWn5LLwV3fT59b2SIUvJ6d04fjRZCpXIdSYiazjuZaHcgqXNQ79x5PY80ZIL62j+CtuF54XQhbmZ3hr3kit1K0CxuhRhxgL9ofBu84mGvP7GZO0d85iboYgCpLbJ4rk4LbdS9r9bdeiod3/1M9iv6dej/Et8X8upFeX9Y5LdonnMjnVg9nXmmlkbV9b1GjTV5PO5p4rFKEpftWihwKVSHvz8lETvgb5Loyn8+sF30iHlgT7ll3rVEcTJ/kqbFfUEsDBBQAAAAIAAAAIQBBeUFiiAAAAKcAAAAUAAAAeGwvc2hhcmVkU3RyaW5ncy54bWw1xzEOwjAMAMCdV1jeaQIDQqhpByReAA+IWtNGSuwSu6j8ngVuu7bfSoY3VU3CAQ+NRyAeZEw8BXzcb/szglrkMWZhCvghxb7bwU+rarCVzBpwNlsuzukwU4nayEK8lfyUWqJpI3VyulSKo85EVrI7en9yJSZGGGRlC+gRVk6vla7/d61Tte4LUEsDBBQAAAAIAAAAIQAWRkQ71gAAAE8BAAAPAAAAeGwvd29ya2Jvb2sueG1sjY7BTsMwEETv+YrV3omTghBUcXpBSBUXDsDdxJvGqr0beQ2Ev0c0pWdOo9XsvJlut6QIn5Q1CFts6waBeBAf+GDx9eXx6g5Bi2PvojBZ/CbFXV91X5KP7yJHWFJktTiVMm+N0WGi5LSWmXhJcZScXNFa8sHonMl5nYhKimbTNLcmucC4Erb5PwwZxzDQgwwfibiskEzRlSCsU5gV+woA4DLvOYN3hdr75sbi6KISmvPLaYn2qwK7RBaf3hBO995bbBHyNniLee+vLzFzzlWd+StZnV/3B1BLAwQUAAAACAAAACEAusLlXH0AAACRAAAAEAAAAHhsL2NhbGNDaGFpbi54bWw9zEEOwiAQAMC7ryB7F6oHYwy0BxNfoA/Y0LWQsAthiam/9+Y8YPyyczEf6pqrBDjZCQxJrGuWLcDr+ThewehAWbFUoQBfUljmg49Y4j1hFrNzEQ2Qxmg35zQmYlRbG8nO5V0741Bb++a0dcJVE9Hg4s7TdHGMWWD27r/NP1BLAwQUAAAACAAAACEAgug+Z/AAAADOAgAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzrZLPSsRADMbvPsWQu512FRHZcS8i7FXrAwxt2hl2/jGJ2r69sOtuq1Tw0FxCvsOXH1+y3Q3eiQ/MZGNQUBUlCAxNbG3oFbzVz9f3IIh1aLWLARWMSLB7vNq+oNNsYyBjE4nBu0AKDHN6kJIag15TEROGwbsuZq+Ziph7mXRz0D3KTVneyTz3gF+mYt8qyPu2AlGPCf9jHrvONvgUm3ePgRd2SDboEUStc4+s4DiexKoYvAP5B8RmTQji0SFNFKf5vF981yLHzZocnzEfyCDyhHKRSB7bOZVFmNtVQzE6Y/vK2YZ+ns1cvpxI/vi+KbMvUEsDBBQAAAAIAAAAIQCttKvn0wYAAGo2AAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1bT2/bNhS/91MQvLf+nyZB1CJ2knZr0gaJ26HHZ4mW2FCkQNJJfBva44ABw7phlwG77TBsK9ACu3SfpluHrQP6FQZativJksy0mZs2ySGAKb7fe3z/+WSvXT8OGTokUlHBHVy7UsWIcFd4lPsOvtvduryMkdLAPWCCEwcPicLXr11ag1UdkJCg45BxtQoODrSOVisV5QYkBHVFRIQfh6wvZAhaXRHSr3gSjij3Q1apV6tLlRAox4hDSBx8p9+nLkFdA4mvXUIIoQmHTUZCwrWKV8dPXCb3DSOSoh9TJvZ5B7X02nhdDVWHSXQIzMFHlHviqEuONUYMlO4w6eDq6A9XMoiVHMg1WGXalk2CxdboL4/FDNzoJPV8FtLvTXnUtporVzfypa7nSG0Bubm52dms5Us5CwmuS3iRMpKwza3lWjtX0lyIKbSFxJ1qq9osgS6SujEfeqXdbrdWiqEbBdDN+dDL1aXmer0YulkA3bLQdXu901kqhm4VQC/Nh966urLULIHOQKzBasAoP5gPbKIvPzhyANZgtS/YTTvk5Wq1upwb2bMYZnWaalIJqC+4tspAITwQcktwnSsZA0050sOI9MElDu5A2JMUstKNdxNIbC3Y46r5e4zwSLmSRtrBn0bAcYLm9fOfXz9/il4/f/Li4bMXD3978ejRi4e/2iDdBO4nkV79+NW/33+O/nn6w6vH31gCqCTAn7988cfvX1tS6iTly2+f/PXsycvvvvz7p8c29OsSekn6Lg2JQrfJEdoTIXArEUhPviNENwCagoBAhGBDuamDFOXtITArwjZJ2+yepNyzorwxeJA6734gB5raUN4KwhTljhCsLaSdjm4Z8ZI6GnDfUl45SBLuARxaidvJeOXmIApIWBikadqApI66y4Br8AknGpln4oAQG5z7lKbsu0NdKZToa3SfojZQO8V3aU/no9ykITAYWp2pG0DKAjv3UFswKwE2yGGaFLgPzIopYSnr3YCBhtDu1BCyJOk26MDqoPtD6aYMr7QE7hMm0KZHlLICuSOHqSPfAkYtPXaHDcM0qdT0wIp0G4RIkm6Ig04AYWR3bsqDJPEn6kAIBmhXaDu5RTqnmM+CUeD2nnqPEv2OyfQu9YN8ZzdPBtIqZxCRznFD1gcyw960CQV13nQAlJ+oA2C0J4uUdNEBLKoDWJfULjNl67414Tmt9hsw4LuEBxfFvkhjF8X+otif52JvnUEXXeJnC3k8NpiMAtITgtBuQNCnjO3rISPbKr9DUIJRb4syNvt0smPEZzrhiIIOyz97pRRtDVZ9CaOHSAr9GdXBfgARcXAtI3aSQuXKndqBIqEcXC0AmXeQcqoxpaZcx0StvMFtET/QO8KL6Rq5E99cFU6kLDl2xZzbSi0NI/BiVNO4+mGpphbzXYhuaq231E1rQbqJnxUGm7lKUI7AvLapLdVjzSHlAiOeCeCCdDAJ+I81G4xdyNKuAXjkbegS/lBrfPyx0lqwTj+MGKueLMZGrUNh7TeseGlbwDg6cvBKq97CyIXIwX0GGiM3jDwHK9OUAfO5g11dZN/5vcXb+0za8is2yTUbSNV5RBYGn9PxjNlGUukNUEHMeLS/yJaMlxij3moah3gf1qichfM3lmvn7fzxWmEMk36fuLo0jhNbCgWM98wrrWKgidwPvCPUYwO5B56Dm3GK8qjSDq5PPkgHG08dfUqXdpsCkn1NO7fqjAmBRQGME/qybT6PmZXngOm5i32gRIFvHhfYYLE2apwZG1nl7AsbXdgo7Xou4aThlQaBCyGRgEzadbCQOhC+hCig7pYUXM93byk0YqBNKCBmvrZmYoQcFrRgSV+NOZcKx6gf6D3qI0l9B+tAErKrxxH5LrLVxv3iHAkn7EvqWZmGjQWiOervkUPCuqZgL5kgxyiYtC5lVTQXtTR5Zh7m1ceebwrzxfjr9O5mzbN+x8rcW5uLu7Y2TzLiSVxeVj4sjf7/k4CEcuKe8uTKqbdaZ+VKH4EOkPnnYJdKl2Vn9Jnt5s7eFXvE1Wg6CkHawZdNT2uS/XSx5+BavFiSVw3j8zmaK1XNuZxGJ+LKaoqYF1eLUs7C4qqVE1at044q86SoFxkN6iYv8+Jls5Tz4wRzv+s9IK7eIH0YsMxvFlS0QfozHZCKdmX2XSOs9oQ3zFtnKu6lZp+owssr43ukj6h3XJoeMl47/hZ+8RhkL3uWhBmn/BqnxW+MWnI5n/KsnxbPKW7+OQV/w3P0ZtiaLys5Z4w665wZ88YdecqfRpZ+7x5WX7CHVd+Dh9XOvIfp41PxsIQ/jeZsObnNaOdYS+hMfiWxrXTl2qVpgnwD+B9QSwECLgMUAAAACAAAACEAllgUrh4BAACwAgAAGAAAAAAAAAAAAAAApIEAAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi4DFAAAAAgAAAAhAHxiW1CqAQAA3QUAABMAAAAAAAAAAAAAAKSBVAEAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLgMUAAAACAAAACEAzJDqGOcAAABYAgAACwAAAAAAAAAAAAAApIEvAwAAX3JlbHMvLnJlbHNQSwECLgMUAAAACAAAACEAY3OPKC0BAADYAgAAEAAAAAAAAAAAAAAApIE/BAAAZG9jUHJvcHMvYXBwLnhtbFBLAQIuAxQAAAAIAAAAIQA8yE301gAAAIgBAAARAAAAAAAAAAAAAACkgZoFAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIuAxQAAAAIAAAAIQAkoEte4gEAAOAFAAANAAAAAAAAAAAAAACkgZ8GAAB4bC9zdHlsZXMueG1sUEsBAi4DFAAAAAgAAAAhAEF5QWKIAAAApwAAABQAAAAAAAAAAAAAAKSBrAgAAHhsL3NoYXJlZFN0cmluZ3MueG1sUEsBAi4DFAAAAAgAAAAhABZGRDvWAAAATwEAAA8AAAAAAAAAAAAAAKSBZgkAAHhsL3dvcmtib29rLnhtbFBLAQIuAxQAAAAIAAAAIQC6wuVcfQAAAJEAAAAQAAAAAAAAAAAAAACkgWkKAAB4bC9jYWxjQ2hhaW4ueG1sUEsBAi4DFAAAAAgAAAAhAILoPmfwAAAAzgIAABoAAAAAAAAAAAAAAKSBFAsAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi4DFAAAAAgAAAAhAK20q+fTBgAAajYAABMAAAAAAAAAAAAAAKSBPAwAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwUGAAAAAAsACwC+AgAAQBMAAAAA
输出
{"alpha":1.0,"beta":"two","name":"remark"}输出是一维 JSON 对象文本;键固定为字符串,值保留 xlsx 里的原生类型(数字仍是 number)。
常见问题
重复的键怎么处理?
后面的行覆盖前面的行,键值对数量是去重后的最终键数。
空键的行呢?
整行跳过并计入「跳过行」;表头行不算跳过。
键列是 1 起始还是 0 起始?
1 起始,和 Excel 的列号一致;小于 1 的值会被夹到 1。
关键词:excel转键值对excel2kv两列转json键值对wasm