Guest User

Untitled

a guest
Nov 21st, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  1. <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.7.2/angular.min.js" ></script>
  2. <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.10.8/xlsx.full.min.js" ></script>
  3.  
  4. <script>
  5. (function () {
  6. var app = angular.module('myApp', []);
  7. app.controller('MyController', ['$scope', myController]);
  8.  
  9. var excelJsonObj = [];
  10. function myController($scope) {
  11. $scope.uploadExcel = function () {
  12. var myFile = document.getElementById('file');
  13. var input = myFile;
  14. var reader = new FileReader();
  15. reader.onload = function () {
  16.  
  17. var fileData = reader.result;
  18. var workbook = XLSX.read(fileData, { type: 'binary' });
  19.  
  20. // aca se deberia crear el archivo excel nuevo con el nombre 'c:test.xlsx'
  21. var wbOut = XLSX.write(workbook, { booktype: 'xlsx', type: 'binary' });
  22. saveAs(new Blob([s2ab(wbout)], { type: "application/octet-stream" }), 'c:test.xlsx');
  23.  
  24. };
  25. reader.readAsBinaryString(input.files[0]);
  26. };
  27. }
  28.  
  29. })();
  30.  
  31. function s2ab(s) {
  32. var buf = new ArrayBuffer(s.length); //convert s to arrayBuffer
  33. var view = new Uint8Array(buf); //create uint8array as viewer
  34. for (var i = 0; i < s.length; i++) view[i] = s.charCodeAt(i) & 0xFF; //convert to octet
  35. return buf;
  36. }
  37.  
  38. $(document).ready(function () {
  39. $("#cargaMasivaTrigger").on("click", function () {
  40. $("#file").val(null);
  41. $("#file").trigger("click");
  42. });
  43.  
  44. $("#file").on("change", function () {
  45. $("#contenedor_carga").show();
  46. $("#btnCargaMasiva").trigger("click");
  47. $.ajax({
  48. type: 'POST',
  49. url: 'FichaEST.aspx/DropSession',
  50. data: "{}",
  51. dataType: 'json',
  52. contentType: 'application/json',
  53. async: true,
  54. success: function (response) {
  55. },
  56. error: function (xhr) {
  57. console.log(xhr.responseText);
  58. },
  59. complete: function () {
  60.  
  61. }
  62. });
  63.  
  64. });
  65. });
  66.  
  67.  
  68. </script>
Add Comment
Please, Sign In to add comment