Question

create a json file from an excel file

Forum|Forum|12 years ago
November 8, 2013
2 replies
27 views

mantahia

Hello,

l'm attempting to create a json file using a json existing file structure, with values coming from an excel file.

(I didn't find example with json file not in input).

My problem is that l want to fill json file only with key:value not null (as you can do in php..?) so that the key is not written in the json file.

sorry for my bad english, this an example :

if l managed to get from my excel file :

title_fr : description in fr --> title templater "fr" : getattribute("title_fr"),

title_en : null --> "en" : getattribut("title_en")

In my title objet in the json file, l want :

title

{

"fr" : "description in fr"

}

and not

title

{

"fr" : "description in fr",

"en" : ""

}

in order to have a clean json file especially when l expect to have a lot of null values depending of the case.

Hope l was enough clear for you to help me!!

thanks,

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.