# Client side excel sheet data

**URL:** <https://discourse.nodered.org/t/client-side-excel-sheet-data/45531>\
**Category:** Industrial\
**Created:** [12 May 2021 08:18 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531 "2021-05-12T08:18:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Duncan](https://avatars.discourse-cdn.com/v4/letter/d/ecc23a/32.png) [@Duncan](https://discourse.nodered.org/u/Duncan)\
**Post date:** [12 May 2021 08:18 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531/1 "2021-05-12T08:18:00Z")

</div>

Good morning everyone,  
I was wondering if you could point me in the right direction. I have setup an energy monitoring system to log gas, electrical usage and a calculated C02 values to an InfluxDB database and Grafana. I have now a request from our environmental/safety manager to automatically fill and an excel sheet with data from the InfluxDB. The dataflow looks like this; PLC (OPC-UA) -\> Node-red (OPC-UA node) - \> influxDB - \> Grafana. If I have a look at the Excel, CSV nodes, they write a file to the server. I need to have the data on the client PC. Any ideas?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [12 May 2021 08:36 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531/2 "2021-05-12T08:36:26Z")

</div>

You can write it to the server and then download it to the PC. There have been a number of posts here on how to download files.

---

<div class="post-metadata">

**Author:** ![Duncan](https://avatars.discourse-cdn.com/v4/letter/d/ecc23a/32.png) [@Duncan](https://discourse.nodered.org/u/Duncan)\
**Post date:** [12 May 2021 09:26 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531/3 "2021-05-12T09:26:14Z")

</div>

Thanks Colin, I will go this route.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [12 May 2021 20:46 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531/4 "2021-05-12T20:46:27Z")

</div>

You have a choice I think. You could split the flow before the output to InfluxDB and have a separate branch that collects and outputs to CSV. Alternatively, you could periodically query InfluxDB and write the output to CSV.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [11 July 2021 20:46 UTC](https://discourse.nodered.org/t/client-side-excel-sheet-data/45531/5 "2021-07-11T20:46:45Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.