image thumbnail

json2xls

version 1.0.0 (2.47 KB) by Jeff Mackey
Convert those ugly json files to xls!

4 Downloads

Updated 13 May 2022

View License

% 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

Cite As

Jeff Mackey (2022). json2xls (https://www.mathworks.com/matlabcentral/fileexchange/111570-json2xls), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2021b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Acknowledgements

Inspired by: Get structure field names in recursive manner

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!