Search found 2 matches
- Tuesday 11 May 2021 4:32
- Forum: Examples & Solutions
- Topic: Export data from DB to Excel [SOLVED]
- Replies: 40
- Views: 21049
Re: Export data from DB to Excel [SOLVED]
but is there a way to change the table to form like this?
One way to do this in dzVents / Lua would be
return
{
on =
{
devices =
{
'convertTrigger', -- change to timer or other trigger
}
},
logging = {
level = domoticz.LOG_DEBUG, -- change to domoticz.ERROR when OK
marker ...
- Monday 10 May 2021 19:20
- Forum: Examples & Solutions
- Topic: Export data from DB to Excel [SOLVED]
- Replies: 40
- Views: 21049
Re: Export data from DB to Excel [SOLVED]
Hai @waaren,
thanx for the code, is work like what i expected. this is the sample output from my modbus energy meter.
idx|name|stand |date
113|kwh1|73,408 |30/04/2021
113|kwh1|74,193 |01/05/2021
113|kwh1|74,978 |02/05/2021
113|kwh1|75,763 |03/05/2021
113|kwh1|76,548 |04/05/2021
113|kwh1|77,334 ...
thanx for the code, is work like what i expected. this is the sample output from my modbus energy meter.
idx|name|stand |date
113|kwh1|73,408 |30/04/2021
113|kwh1|74,193 |01/05/2021
113|kwh1|74,978 |02/05/2021
113|kwh1|75,763 |03/05/2021
113|kwh1|76,548 |04/05/2021
113|kwh1|77,334 ...