{"id":911,"date":"2023-02-16T06:14:10","date_gmt":"2023-02-16T06:14:10","guid":{"rendered":"https:\/\/www.tools.keywordfinder.us\/?page_id=911"},"modified":"2023-02-16T06:14:10","modified_gmt":"2023-02-16T06:14:10","slug":"excel-to-html-converter","status":"publish","type":"page","link":"https:\/\/tools.billionsideas.com\/de\/excel-to-html-converter\/","title":{"rendered":"Excel To HTML Converter"},"content":{"rendered":"<div style=\"height:70px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column has-base-3-background-color has-background is-layout-flow wp-block-column-is-layout-flow\">\n\n<section><h1>Excel To HTML<\/h1><br>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.7.7\/xlsx.core.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xls\/0.7.4-a\/xls.core.min.js\"><\/script>\n  <div class=\"Header\">\n\t\t\n\t\t<\/div>\n\t\t<div class=\"Raw\">\n\t\t\n\t\t<input type=\"file\" id=\"excelfile\"> \n\t\t<br><br>\n\t\t\n\t\t<input type=\"button\" id=\"viewfile\" value=\"Export To Table\" onclick=\"ExportToTable()\" class=\"custom-btn btn\">\n\t\t\t<br><\/div>\n\t\t<div class=\"Raw\">\n\t\t\t\n\t\t\t<div class=\"designchech\">\n\t\t\t\t<div class=\"html-container\"><table id=\"exceltable\" class=\"headertable\"><\/table> \n\t\t\t\t<\/div>\t\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<div class=\"Raw\">\n\t\t\t\n\t\t\t<button id=\"demo\" class=\"custom-btn btn\">Get Code<\/button><br>\n\t\t<\/div><br><br>\n\t\t<div class=\"Raw\">\n\t\t\t\n\t\t\t<textarea class=\"html-viewer\"><\/textarea><br>\n\t\t<\/div>\n\t\n\t\t<\/section>\n\n<!-- partial -->\n  <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.5.1\/jquery.min.js\"><\/script><script src=\".\/Upload.js\"><\/script><script src=\".\/text.js\"><\/script>\n\n\n<script>\ndocument.getElementById(\"demo\").onclick = function() {myFunction()};\n\nfunction myFunction() {\n   var code = $('.html-container').html();\n\t\n\ty = '<html><body>' + code + '<\/body><\/html>';\n  $('.html-viewer').text(y).focus().select();\n}\nfunction BindTable(jsondata, tableid) {\n  \/*Function used to convert the JSON array to Html Table*\/\n\n  var columns = BindTableHeader(\n    jsondata,\n    tableid\n  ); \/*Gets all the column headings of Excel*\/\n  for (var i = 0; i < jsondata.length; i++) {\n    var row$ = $(\"<tr\/>\");\n    for (var colIndex = 0; colIndex < columns.length; colIndex++) {\n      var cellValue = jsondata[i][columns[colIndex]];\n      if (cellValue == null) cellValue = \"\";\n      row$.append($(\"<td\/>\").html(cellValue));\n    }\n    $(tableid).append(row$);\n  }\n}\nfunction BindTableHeader(jsondata, tableid) {\n  \/*Function used to get all column names from JSON and bind the html table header*\/\n\n  var columnSet = [];\n  var headerTr$ = $(\"<tr\/>\");\n  for (var i = 0; i < jsondata.length; i++) {\n    var rowHash = jsondata[i];\n    for (var key in rowHash) {\n      if (rowHash.hasOwnProperty(key)) {\n        if ($.inArray(key, columnSet) == -1) {\n          \/*Adding each unique column names to a variable array*\/\n\n          columnSet.push(key);\n          headerTr$.append($(\"<th\/>\").html(key));\n        }\n      }\n    }\n  }\n  $(tableid).append(headerTr$);\n  return columnSet;\n}\n\nfunction ExportToTable() {\n  var regex = \/^([a-zA-Z0-9\\s_\\\\.\\-:])+(.xlsx|.xls)$\/;\n  \/*Checks whether the file is a valid excel file*\/\n\n  if (regex.test($(\"#excelfile\").val().toLowerCase())) {\n    var xlsxflag = false; \/*Flag for checking whether excel is .xls format or .xlsx format*\/\n    if ($(\"#excelfile\").val().toLowerCase().indexOf(\".xlsx\") > 0) {\n      xlsxflag = true;\n    }\n    \/*Checks whether the browser supports HTML5*\/\n\n    if (typeof FileReader != \"undefined\") {\n      var reader = new FileReader();\n      reader.onload = function (e) {\n        var data = e.target.result;\n        \/*Converts the excel data in to object*\/\n\n        if (xlsxflag) {\n          var workbook = XLSX.read(data, { type: \"binary\" });\n        } else {\n          var workbook = XLS.read(data, { type: \"binary\" });\n        }\n        \/*Gets all the sheetnames of excel in to a variable*\/\n\n        var sheet_name_list = workbook.SheetNames;\n\n        var cnt = 0; \/*This is used for restricting the script to consider only first sheet of excel*\/\n        sheet_name_list.forEach(function (y) {\n          \/*Iterate through all sheets*\/\n          \/*Convert the cell value to Json*\/\n\n          if (xlsxflag) {\n            var exceljson = XLSX.utils.sheet_to_json(workbook.Sheets[y]);\n          } else {\n            var exceljson = XLS.utils.sheet_to_row_object_array(\n              workbook.Sheets[y]\n            );\n          }\n          if (exceljson.length > 0 && cnt == 0) {\n            BindTable(exceljson, \"#exceltable\");\n            cnt++;\n          }\n        });\n        $(\"#exceltable\").show();\t\t \n  \t\t\n\n      };\n\t\t\n\n      if (xlsxflag) {\n        \/*If excel file is .xlsx extension than creates a Array Buffer from excel*\/\n\n        reader.readAsArrayBuffer($(\"#excelfile\")[0].files[0]);\n      } else {\n        reader.readAsBinaryString($(\"#excelfile\")[0].files[0]);\n      }\n    } else {\n      alert(\"Sorry! Your browser does not support HTML5!\");\n    }\n  } else {\n    alert(\"Please upload a valid Excel file!\");\n  }\n}\n<\/script>\n\n<style>\n\nbody{text-align:center}\n\n\/* Button Styles *\/\nbutton, .button, #button, btn, .btn, #btn, downloadlink,  #download-button, #button-copy, button-copy, copy-button, #copy-button, #copy, copy, #download-html-button{\n  display: inline-block;\n  padding: 12px 24px;\n  font-size: 16px;\n  font-weight: 500;\n  color: #ffffff;\n  text-transform: uppercase;\n  text-decoration: none;\n  text-align: center;\n  border-radius: 30px;\n  background-image: linear-gradient(to right, #0088FF, #0088FF);\n  border: 3px solid #fff;\n  box-shadow: 0 3px 10px rgba(0, 0, 0, 0.2);\n  transition: all 0.3s ease;\n  margin:0 auto;\n  margin-top:11px;\n  margin-bottom:11px;\n  text-shadow: 2px 2px 4px #333;\n}\n\n\/* Button Hover State *\/\nbutton:hover {\n  background-image: linear-gradient(to right, #FF1493, #FF1493);\n  border: 3px solid #ffffff;\n  box-shadow: 0 5px 15px rgba(0, 0, 0, 0.3);\n}\n\n -input{\n  width: 25%;\n  height: 100%;\n  padding: 5px;\n  font-size: 16px;\n  font-family: Arial, sans-serif;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;\n  border-radius: 5px;\n  box-shadow: 2px 2px 5px #ccc;\n  transition: all 0.2s ease-in-out;\n  margin-top:10px;margin-bottom:10px;\n  margin:0 auto;\n}\n\ninput[type=file]::file-selector-button {\n  display: inline-block;\n  padding: 1.0rem 1rem;\n  font-size: 1.125rem;\n  font-weight: bold;\n  color: #fff;\n  text-align: center;\n  text-transform: uppercase;\n  background-color: #0088FF;\n  border-radius: 0rem;\n  cursor: pointer;\n  transition: background-color 0.2s ease-in-out;\n  border: 0px solid #fff;\n  width:100%;\n  box-shadow: 0 3px 10px rgba(0, 0, 0, 0.2);\n}\n\ninput[type=file]::file-selector-button:hover {\n  background-color: #5b52d6;\n}\n\ninput[type=file]::file-selector-button:active {\n  background-color: #4a41ad;\n}\n\ninput[type=file]::file-selector-button:focus {\n  outline: none;\n  box-shadow: 0 0 0 2px #fff, 0 0 0 4px #6c63ff;\n}\n\ninput[type=file]::file-selector-button::before {\n  content: \"Select File\";\n}\n\ninput[type=file]::file-selector-button::before,\ninput[type=file]::file-selector-button::before {\n  content: \"\\2193 Browse Files\";\n}\n\n\ninput[type=\"file\"] {\n  display: yes;\n}\ninput[type=\"text\"], input[type=\"url\"] {\n  width: 80%;\n  height: 50px;\n  padding: 5px;\n  font-size: 16px;\n  font-family: Arial, sans-serif;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;\n  border-radius: 5px;\n  box-shadow: 2px 2px 5px #ccc;\n  transition: all 0.2s ease-in-out;\n  margin-top:10px;margin-bottom:10px;\n  margin:0 auto;\n}\ninput[type=\"number\"], select {\n  width: 30%;\n  height: 50px;\n  padding: 5px;\n  font-size: 16px;\n  font-family: Arial, sans-serif;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;\n  border-radius: 5px;\n  box-shadow: 2px 2px 5px #ccc;\n  transition: all 0.2s ease-in-out;\n  margin-top:10px;margin-bottom:10px;\n  margin:0 auto;\n}\n\ntextarea {\n  width: 100%;\n  height: 170px;\n  padding: 10px;\n  font-size: 16px;\n  font-family: Arial, sans-serif;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;\n  border-radius: 5px;\n  box-shadow: 2px 2px 5px #ccc, -2px -2px 5px #ccc;  \n  transition: all 0.2s ease-in-out;\n  margin-top:10px;margin-bottom:10px;\n  margin:0 auto;\n}\n\ntextarea:hover {\n  border-color: #06c;\n  box-shadow: 2px 2px 10px #06c;\n}\n\ntextarea:focus {\n  outline: none;\n  border-color: #06c;\n  box-shadow: 2px 2px 10px #06c;\n}\n\ncanvas, #image-container, .img, #img, image, .image, #image, #convertedImage, #preview-image {\n  border: 5px solid;\n  border-image: linear-gradient(to bottom, #007bff, #00f260);\n  border-image-slice: 1;\n  box-shadow: 0px 0px 20px rgba(0, 0, 0, 0.3);\n  margin-top:10px;margin-bottom:10px;\n  width:90%;\n  margin:0 auto;padding:15px;\n\n}\n\n#image-container img {\n  max-width: 100%;\n  }\n\ncode, pre, .result, output, #output, .output {\n  font-family: Monaco, Consolas, \"Andale Mono\", \"DejaVu Sans Mono\", monospace;\n  font-size: 0.9em;\n  color: #333;\n  background-color: #f9f9f9;\n  padding: 0.2em 0.4em;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;\n  border-radius: 5px;\n  box-shadow: 2px 2px 5px #ccc, -2px -2px 5px #ccc;  \n  transition: all 0.2s ease-in-out;\n  white-space: pre-wrap;\n  margin-top:10px;margin-bottom:10px;\n  margin:0 auto;\n  width:100%;\n  padding:15px;\n\n}\n\n\ninput[type=\"range\"] {\n  -webkit-appearance: none;\n  width: 80%;\n  background: transparent;\n  height: 10px;\n  border-radius: 5px;\n  outline: none;\n  padding: 0;\n  margin: 0;\n  box-shadow: inset 0 0 5px #333;\n  transition: box-shadow 0.2s;\n  margin-top:10px;\n\n}\n\ninput[type=\"range\"]:focus {\n  box-shadow: inset 0 0 5px #888;\n}\n\ninput[type=\"range\"]::-webkit-slider-thumb {\n  -webkit-appearance: none;\n  height: 20px;\n  width: 20px;\n  border-radius: 50%;\n  background: #4CAF50;\n  cursor: pointer;\n  transition: background 0.2s;\n  margin-top:-5px;\n}\n\ninput[type=\"range\"]::-webkit-slider-thumb:hover {\n  background: #3e8e41;\n}\n\ninput[type=\"range\"]::-webkit-slider-runnable-track {\n  height: 10px;\n  background: #ddd;\n  border-radius: 5px;\n  border: none;\n}\ninput[type=\"checkbox\"] {\n  appearance: none;\n  width: 45px;\n  height: 25px;\n  background: transparent;\n  border: 2px solid;\n  border-image: linear-gradient(to right, #06c, #f90) 1;  border-radius: 5px;\n  margin: 10px;\n  outline: none;\n  cursor: pointer;\n  position: relative;\n}\n\ninput[type=\"checkbox\"]:before {\n  content: \"\";\n  width: 15px;\n  height: 15px;\n  background: #D209A4;\n  border-radius: 100px;\n  position: absolute;\n  left: 2px;\n  \n  top: 3px;\n  transition: all 0.2s;\n}\n\ninput[type=\"checkbox\"]:checked:before {\n  transform: translateX(20px);\n}\n\ninput[type=\"checkbox\"]:focus {\n  border: 2px solid #888;\n}\ninput[type=\"radio\"] {\n  appearance: none;\n  width: 20px;\n  height: 20px;\n  border-radius: 50%;\n  border: 2px solid #333;\n  margin-right: 10px;\n  outline: none;\n  position: relative;\n  cursor: pointer;\n}\n\ninput[type=\"radio\"]:after {\n  content: \"\";\n  width: 10px;\n  height: 10px;\n  border-radius: 50%;\n  background: #333;\n  position: absolute;\n  top: 5px;\n  left: 5px;\n  opacity: 0;\n  transition: all 0.2s;\n}\n\ninput[type=\"radio\"]:checked:after {\n  opacity: 1;\n}\n\ninput[type=\"radio\"]:focus {\n  border-color: #888;\n}\n\n\ninput[type=\"radio\"] {\n  display: inline-block;\n  margin-right: 10px;\n  vertical-align: middle;\n}\n\nlabel {\n  display: block; \/* makes each label appear on a new line *\/\n  font-size: 16px;\n  font-weight: bold;\n  margin-bottom: 5px; \/* adds a small gap below each label *\/\n  color:#55555e;\n  margin-top:11px;margin-bottom:11px;\n}\n\ninput[type=\"color\"]{width:17.2%;}\n.form-control {\n    display: block;\n    margin:0 auto;\n    width: 70%;\n    padding: 0.375rem 0.75rem;\n    font-size: 1rem;\n    font-weight: 400;\n    line-height: 1.5;\n    color: #212529;\n    background-color: #fff;\n    background-clip: padding-box;\n    border: 1px solid #ced4da;\n    -webkit-appearance: none;\n    -moz-appearance: none;\n    appearance: none;\n    border-radius: 0.25rem;\n    transition: border-color .15s ease-in-out,box-shadow .15s ease-in-out;\n}\nsection{\n        margin: 0px auto;\n        width: 100%;\n        max-width: 970px;\n        background-color: #fff;\n        border: 1px solid #ddd;\n        padding: 20px;\n      }\n<\/style>\n\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Excel To HTML Get Code<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","footnotes":""},"class_list":["post-911","page","type-page","status-publish"],"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"Billions Ideas","author_link":"https:\/\/tools.billionsideas.com\/de\/author\/loginbillionsideas-com\/"},"comment_info":0,"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/pages\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/comments?post=911"}],"version-history":[{"count":0,"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/pages\/911\/revisions"}],"wp:attachment":[{"href":"https:\/\/tools.billionsideas.com\/de\/wp-json\/wp\/v2\/media?parent=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}