Home > Back-end >  Json to excel
Json to excel

Time:09-20

Everyone a great god, can you tell me the json format should be converted to excel format

CodePudding user response:

A json parsing as characters flow first and then according to the new node into the new excel, you need to download the json depend on package, excel depend on the package, I wrote a demo you can into my space to see, remember to points!

CodePudding user response:

This is part of the source code, can realize batch conversion export excel

Label labelapp=new Label (0, 0, "app name");
Label labelLv=new Label (1, 0, "Android version");
Label labelSdkVer=new Label (2, 0, "SDK version");
Label labelPhone=new Label (3, 0, "channels");
Label labelChannel=new Label (4, 0, "model");
Label labelCause=new Label (5, 0, "causeBy");
Label labelCauseinfo=new Label (6, 0, "causeinfo");
Label labelId=new Label (7, 0, "Id");

Ws. AddCell (labelapp);
Ws. AddCell (labelLv);
Ws. AddCell (labelCause);
Ws. AddCell (labelPhone);
Ws. AddCell (labelId);
Ws. AddCell (labelChannel);
Ws. AddCell (labelSdkVer);
Ws. AddCell (labelCauseinfo);

CodePudding user response:

Suggest using python XLRD this library, will soon,

CodePudding user response:

Here is an online tool to do this thing: http://j2e.kpoda.com, also upload unlimited size, take away, don't mention it.
  • Related