Тема: Grouping excel
Hi this questions is not about SDK but i see on wialon hosting you can generate excel grouping, I searched manyways for this but Anyway of this not works fine,
How do you do this or What libraries use.
Y hope you can help me with this.
For example i need import in a groupin excel the json object.
[
{
"dispensador": "13050267 (AZG310) ME02",
"volumen": " lt",
"total": 2748.11,
"grupos": [
{
"grupo": "ACCESO TEMPORAL",
"cantidad": 2,
"total": 1005.87,
"dias": [
{
"total": 1005.87,
"fecha": "2018-03-21",
"despachos": [
{
"unidad": "13040008 (AZG208)",
"id": 16223188,
"inicio": "2018-03-21 09:01:16",
"fin": "2018-03-21 09:16:01",
"dispensado": "547.90"
},
{
"unidad": "13040009 (AZG207)",
"id": 16223200,
"inicio": "2018-03-21 09:37:36",
"fin": "2018-03-21 09:44:29",
"dispensado": "457.97"
}
]
}
]
},
{
"grupo": "ALZADORAS",
"cantidad": 1,
"total": 170.47,
"dias": [
{
"total": 170.47,
"fecha": "2018-03-21",
"despachos": [
{
"unidad": "13030012 (AZG094)",
"id": 16223076,
"inicio": "2018-03-21 11:49:14",
"fin": "2018-03-21 11:53:54",
"dispensado": "170.47"
}
]
}
]
}
]
},
{
"dispensador": "13050268 (AZG090) ME01",
"volumen": " lt",
"total": 7053.86,
"grupos": [
{
"grupo": "ALZADORAS",
"cantidad": 1,
"total": 112.24,
"dias": [
{
"total": 112.24,
"fecha": "2018-03-21",
"despachos": [
{
"unidad": "13030013 (AZG092)",
"id": 16223083,
"inicio": "2018-03-21 11:51:07",
"fin": "2018-03-21 11:54:47",
"dispensado": "112.24"
}
]
}
]
},
{
"grupo": "Atrack (Ares Sun)",
"cantidad": 5,
"total": 712.8,
"dias": [
{
"total": 712.8,
"fecha": "2018-03-21",
"despachos": [
{
"unidad": "13050268 (AZG090) ME01",
"id": 13301377,
"inicio": "2018-03-21 07:02:37",
"fin": "2018-03-21 07:08:05",
"dispensado": "308.46"
},
{
"unidad": "13050268 (AZG090) ME01",
"id": 13301377,
"inicio": "2018-03-21 07:08:14",
"fin": "2018-03-21 07:12:26",
"dispensado": "124.12"
},
{
"unidad": "13050268 (AZG090) ME01",
"id": 13301377,
"inicio": "2018-03-21 08:35:50",
"fin": "2018-03-21 08:40:34",
"dispensado": "123.29"
},
{
"unidad": "13050268 (AZG090) ME01",
"id": 13301377,
"inicio": "2018-03-21 09:29:49",
"fin": "2018-03-21 09:32:26",
"dispensado": "13.61"
},
{
"unidad": "13050268 (AZG090) ME01",
"id": 13301377,
"inicio": "2018-03-21 11:43:04",
"fin": "2018-03-21 11:46:49",
"dispensado": "143.32"
}
]
}
]
}
]
}
]