Discussion:
[influxdb] workflow to get data into Excel
Brannon King
2016-05-06 19:12:26 UTC
Permalink
What workflow do you use to get data into MS Excel? I've got custom code to
generate a spreadsheet for me, but I only allow the user to input
start/stop times. I wish there was something more dynamic like an OData
endpoint or an OLEDB driver. Has anyone looked into either of those options
for InfluxDB?
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/80eff934-7173-4fe5-a3bd-171afffe25fd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Brannon King
2016-05-11 23:16:22 UTC
Permalink
Thanks for the reply. I am familiar with the CSV output. I also have a
custom tool to pull a bunch of data into an XLSX. However, I wanted a way
for a user to explore the data using some kind of table browser. They
should be able to see what measurements are available on the server, what
the time ranges are, and pick some window of time on a certain measure or
two. That way I don't have to export large chunks of the data, just the
stuff that the report writer wanted. Explorability is key.
The CLI <https://docs.influxdata.com/influxdb/v0.12/tools/shell/> has a
CSV output option (see -format) and can be run in a non-interactive mode
where output can be redirected to a file.
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/f9665b90-f804-4a71-aacf-c193164a61e2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
i***@gmail.com
2017-10-21 16:02:01 UTC
Permalink
This could be also a solution for me.
I have measurements per minute and want to show in excel table the mean value of each day. So adding every next day one row to the table.
Would that be possible?
--
Remember to include the version number!
---
You received this message because you are subscribed to the Google Groups "InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/649f68cb-ccbd-4747-9032-30de38343250%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Continue reading on narkive:
Loading...