vueIndex.js 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. // <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.5/xlsx.full.min.js"></script>
  2. // <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.5/jszip.js"></script>
  3. // <script type="text/javascript">
  4. function Upload() {
  5. //Reference the FileUpload element.
  6. var fileUpload = document.getElementById("fileUpload");
  7. //Validate whether File is valid Excel file.
  8. var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.xls|.xlsx)$/;
  9. if (regex.test(fileUpload.value.toLowerCase())) {
  10. if (typeof (FileReader) != "undefined") {
  11. var reader = new FileReader();
  12. //For Browsers other than IE.
  13. if (reader.readAsBinaryString) {
  14. reader.onload = function (e) {
  15. ProcessExcel(e.target.result);
  16. };
  17. reader.readAsBinaryString(fileUpload.files[0]);
  18. } else {
  19. //For IE Browser.
  20. reader.onload = function (e) {
  21. var data = "";
  22. var bytes = new Uint8Array(e.target.result);
  23. for (var i = 0; i < bytes.byteLength; i++) {
  24. data += String.fromCharCode(bytes[i]);
  25. }
  26. ProcessExcel(data);
  27. };
  28. reader.readAsArrayBuffer(fileUpload.files[0]);
  29. }
  30. } else {
  31. alert("This browser does not support HTML5.");
  32. }
  33. } else {
  34. alert("Please upload a valid Excel file.");
  35. }
  36. };
  37. // </script>