1

Grouping excel

Тема: 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"
              }
            ]
          }
        ]
      }
    ]
  }
]
2

Grouping excel

Re: Grouping excel

Hi cerpas
What programming language do you use?

3

Grouping excel

Re: Grouping excel

Hi, cerpas. Wialon backend don't use external library for excel export. We build xlsx structure directly.

4

Grouping excel

(22/03/2018 19:06:50 отредактировано cerpas)

Re: Grouping excel

shmi пишет:

Hi cerpas
What programming language do you use?

In Back End PHP, on front end Typescript(Angular)

I used many libraries for this but any do not work. i try generate this in my Front End.

5

Grouping excel

Re: Grouping excel

vagr пишет:

Hi, cerpas. Wialon backend don't use external library for excel export. We build xlsx structure directly.


Hello thank you for this information,

How do you build the xlsx files?

6

Grouping excel

Re: Grouping excel

You can rename doc.xlsx to doc.zip, unpack and see it

7

Grouping excel

Re: Grouping excel

vagr пишет:

You can rename doc.xlsx to doc.zip, unpack and see it

My apologies,I was not explain you well.. I need grouping rows in a excel file, similar to you excel report for wialon reports.