ExcelToJSON
MyApp
Asmat Qatea
1.0
Desktop
False
640
480
False
False
False
False
WebApp
False
C:\Users\asmat\Documents\VisualNeoWeb\Libraries\img\default-icon.png
#JSONlog span {
padding:2px 5px;
background:#227447;
color:white;
border-radius:5px;
}
.select{
user-select:none;
}
.flexCenter{
display:flex;
justify-content:center;
align-items:center;
}
.flexSpacebetween{
display:flex;
align-items:center;
justify-content:space-between;
}
.flexRight{
display:flex;
justify-content:flex-end;
align-items:center;
}
.flexLeft{
display:flex;
align-items:center;
justify-content:flex-start;
}
.flexMenu{
display:flex;
flex-direction:row;
flex-wrap:wrap;
justify-content:flex-start;
align-content:flex-start;
}
.boxShadow {
box-shadow:
0 2.8px 2.2px rgba(0, 0, 0, 0.034),
0 6.7px 5.3px rgba(0, 0, 0, 0.048),
0 12.5px 10px rgba(0, 0, 0, 0.06),
0 22.3px 17.9px rgba(0, 0, 0, 0.072),
0 41.8px 33.4px rgba(0, 0, 0, 0.086),
0 100px 80px rgba(0, 0, 0, 0.12)
}
en
standalone
Offline page
#000000
[AndroidOS,iOS,WindowsPhoneOS]
normal
True
True
False
True
True
False
False
True
False
False
document.getElementById('myTextArea').addEventListener('paste', (event) => {
let paste = (event.clipboardData || window.clipboardData).getData('text');
let content = paste.trim().replace(/[\r]/g, "").split("\n");
let tableArray = [];
let headerText = content[0].split("\t");
for (i in content) {
var item = {};
if(i==0){continue}; //header part
for(j in headerText){
item[headerText[j]] = content[i].split("\t")[j];
}
tableArray.push(item);
};
console.log(tableArray);
$App.myArray = tableArray;
});
JavaScript
var beta = JSON.stringify(data, null, 4);
var a = document.createElement('a');
a.setAttribute('href', 'data:text/plain;charset=utf-8,'+encodeURIComponent(beta));
a.setAttribute('download', fileName+'.txt');
a.click()
data|STRING|data;fileName|STRING|fileName
JavaScript
pasteEventExcelToJSON
14px
68px
80%
50px
top
10%
15px
boxShadow flexCenter
0px
12px
36px
36px
top
flexCenter
<svg transform ="scale(1.5)" fill="#217346" style="width:24px;height:24px" viewBox="0 0 24 24">
<path d="M21.17 3.25Q21.5 3.25 21.76 3.5 22 3.74 22 4.08V19.92Q22 20.26 21.76 20.5 21.5 20.75 21.17 20.75H7.83Q7.5 20.75 7.24 20.5 7 20.26 7 19.92V17H2.83Q2.5 17 2.24 16.76 2 16.5 2 16.17V7.83Q2 7.5 2.24 7.24 2.5 7 2.83 7H7V4.08Q7 3.74 7.24 3.5 7.5 3.25 7.83 3.25M7 13.06L8.18 15.28H9.97L8 12.06L9.93 8.89H8.22L7.13 10.9L7.09 10.96L7.06 11.03Q6.8 10.5 6.5 9.96 6.25 9.43 5.97 8.89H4.16L6.05 12.08L4 15.28H5.78M13.88 19.5V17H8.25V19.5M13.88 15.75V12.63H12V15.75M13.88 11.38V8.25H12V11.38M13.88 7V4.5H8.25V7M20.75 19.5V17H15.13V19.5M20.75 15.75V12.63H15.13V15.75M20.75 11.38V8.25H15.13V11.38M20.75 7V4.5H15.13V7Z" />
</svg>
113px
10px
60%
36px
top
8px
8px
[myInput]
Copy from Excel & paste here...
.filterList "tag1" "menu4"
84px
13px
36px
36px
top
background-color:#F1F1F1;border-radius:8px
flexCenter
<svg style="width:24px;height:24px" viewBox="0 0 24 24"> <path fill="currentColor" d="M19,6.41L17.59,5L12,10.59L6.41,5L5,6.41L10.59,12L5,17.59L6.41,19L12,13.41L17.59,19L19,17.59L13.41,12L19,6.41Z"></path></svg>
SetVar [myInput] ""
13px
67px
80%
200px
top
10%
5px
0px
overflow-y:auto
boxShadow
<span>Output:</span> <br>
[myArray]
72px
294px
80%
50px
top
10%
5px
boxShadow flexLeft
23px
15px
80px
36px
top
7px
7px
background-color:#006ce2
select flexCenter
<svg style="width:24px;height:24px" viewBox="0 0 24 24"> <path fill="currentColor" d="M15,9H5V5H15M12,19A3,3 0 0,1 9,16A3,3 0 0,1 12,13A3,3 0 0,1 15,16A3,3 0 0,1 12,19M17,3H5C3.89,3 3,3.9 3,5V19A2,2 0 0,0 5,21H19A2,2 0 0,0 21,19V7L17,3Z"></path></svg>
Save
GetObjectHTML "fileName" [fileName]
saveFileToJSON "[myArray]" "[fileName]"
397px
7px
108px
36px
top
7px
7px
select flexCenter
FileName:
saveFileToJSON "[myArray]" "MyJSONArray"
117px
15px
108px
36px
top
7px
7px
background-color:#006ce2
select flexCenter
contentEditable="true"
myJSONFile
228px
439px
204px
34px
flexCenter
Author: Asmat Qatea
0px
0px
640px
480px
False
custom