json2xls

Convert those ugly json files to xls!

% Convert those ugly json files to xls!

%

% json2xls(target, outpath):

% target = full path and name of input json file

% outpath = full path and name of output xls file, omitting the suffix

% '.xls'

% Each row heading becomes a separate sheet.

% example use: json2xls('~/Documents/ugly.json', '~/notasugly')

%

% limitations:

% sheets needing more than 104 columns will require addition to the row index (rowInd) as below.

% sheets needing more the 600 rows will require substituting '600' below

% for the required count

%

% requires: jsondecode

% ----

% requires: fieldnamesr.m

% Copyright (c) 2011, Adam Tudor Jones

% All rights reserved.

% Redistribution and use in source and binary forms (of fieldnamesr.m), with or without

% modification, are permitted provided that the following conditions are

% met:

%

% * Redistributions of source code must retain the above copyright

% notice, this list of conditions and the following disclaimer.

% * Redistributions in binary form must reproduce the above copyright

% notice, this list of conditions and the following disclaimer in

% the documentation and/or other materials provided with the distribution

% * Neither the name of the University of Oxford nor the names

% of its contributors may be used to endorse or promote products derived

% from this software without specific prior written permission.

%

% THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"

% AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

% IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE

% ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE

% LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

% CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF

% SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS

% INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

% CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)

% ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE

% POSSIBILITY OF SUCH DAMAGE.

% ----

% J. Mackey, 5/2022