javascript - Complex object data structure to xlsx -

-

i have javascript object contains in other objects:

{     "10": {},     "12": {         "20": {             "value": 1,             "id": 1,         },         "100": {             "value": 12,             "id": 1,         }     },     "14": {         "100": {             "value": 14,             "id": 2,         }     },     "16": {},     "18": {},     "20": {         "100": {             "value": 23,             "id": 1,         },         "150": {             "value": 56,             "id": 3,         }     },     "22": {},     "24": {},     "26": {         "50": { ...

i want export xlsx file, have issues doing so.

i have resorted @ using js-xlsx not helpful regarding it's documentation, , alasql.

creating such file simpler datastructure quite easy. have few issues when trying create own structure.

firstly trying this:

alasql('select * xlsx("test.xlsx",{headers:true}) ?',[$scope.testdata]);

fails printing [object] instead of actual values.

trying create cells myself end empty file.

function sheet_from_array_of_arrays(data, opts) {     var ws = {};     var range = {s: {c:10000000, r:10000000}, e: {c:0, r:0 }};     var row1 = 0;     (var r in data) {         if (data.hasownproperty(r)) {             var row2 = 0;             (var c in data[r]) {                 if (data[r].hasownproperty(c)) {                 var col = 0;                     (var k in data[r][c]) {                         if (data[r][c].hasownproperty(c)) {                             var rr = row1 + row2;                             var cc = col;                             if(range.s.r > rr) range.s.r = rr;                             if(range.s.c > cc) range.s.c = c;                             if(range.e.r < rr) range.e.r = rr;                             if(range.e.c < cc) range.e.c = cc;                             var cell = {v: data[r][c][k] };                             if(cell.v == null) continue;                             var cell_ref = xlsx.utils.encode_cell({c:cc,r:rr});                              if(typeof cell.v === 'number') cell.t = 'n';                             else if(typeof cell.v === 'boolean') cell.t = 'b';                             else if(cell.v instanceof date) {                                 cell.t = 'n'; cell.z = xlsx.ssf._table[14];                                 cell.v = datenum(cell.v);                             }                             else cell.t = 's';                              ws[cell_ref] = cell;                              col = col + 1;                         }                     }                     row2 = row2 + 1;                 }             }             row1 = row1 + 1;         }     }     if(range.s.c < 10000000) ws['!ref'] = xlsx.utils.encode_range(range);     return ws; }  function workbook() {     if(!(this instanceof workbook)) return new workbook();     this.sheetnames = [];     this.sheets = {}; }  var wb = new workbook(), ws = sheet_from_array_of_arrays($scope.testdata);  /* add worksheet workbook */ wb.sheetnames.push(ws_name); wb.sheets[ws_name] = ws; var wbout = xlsx.write(wb, {booktype:'xlsx', booksst:true, type: 'binary'});  function s2ab(s) {     var buf = new arraybuffer(s.length);     var view = new uint8array(buf);     (var i=0; i!=s.length; ++i) view[i] = s.charcodeat(i) & 0xff;     return buf; } saveas(new blob([s2ab(wbout)],{type:"application/octet-stream"}), "test.xlsx")

is there way me create xlsx file object presented above?

you can use search operator parsing of nested json objects:

var data = { "10": {}, "12": {     "20": {         "value": 1,         "id": 1,     },     "100": {         "value": 12,         "id": 1,     } }, "14": {     "100": {         "value": 14,         "id": 2,     } }, "16": {}, "18": {}, "20": {     "100": {         "value": 23,         "id": 1,     },     "150": {         "value": 56,         "id": 3,     } } };     var res = alasql('search of(@a) of(@c) \     return(@a a,@c c, _->[value] [value], _->id id) \     xlsx("test406.xlsx",{headers:true}) \     ?',[data]);

here:

  • search ... xlsx ? - special search operator
  • of(@v) - list of keys of object (key value stored variable
  • return(...) - result object
  • _ - current search value

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di...
Read more

css - Can I use the :after pseudo-element on an input field? -

-
i trying use :after css pseudo-element on input field, not work. if use span , works ok. <style type="text/css"> .mystyle:after {content:url(smiley.gif);} .mystyle {color:red;} </style> this works (puts smiley after "buu!" , before "some more") <span class="mystyle">buuu!</span>a more this not work - colors somevalue in red, there no smiley. <input class="mystyle" type="text" value="somevalue"> what doing wrong? should use pseudo-selector? note: cannot add span around input , because being generated third-party control. :after , :before not supported in internet explorer 7 , under, on elements. it's not meant used on replaced elements such form elements (inputs) , image elements . in other words it's impossible pure css. however if using jquery can use $(".mystyle").after("add smiley here"); api docs on .after to ...
Read more