# Writing data to a excel template

**URL:** <https://forum.inductiveautomation.com/t/writing-data-to-a-excel-template/92674>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 2, 2024, 12:09pm UTC](https://forum.inductiveautomation.com/t/writing-data-to-a-excel-template/92674 "2024-07-02T12:09:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dharani\_T](https://avatars.discourse-cdn.com/v4/letter/d/bc8723/32.png) [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\
**Post date:** [July 2, 2024, 12:09pm UTC](https://forum.inductiveautomation.com/t/writing-data-to-a-excel-template/92674/1 "2024-07-02T12:09:57Z")

</div>

Hi,

I have a requirement in SPC where user would like to export the data from perspective as csv/excel and feed the results to highlighted columns (where formulas are there) in below pic.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/9/e966bae1511f4952125c15a5a21b4ec5966dd05d.png)  
So, i have uploaded this file as blob in db but i dont know how to proceed further to send the data to this excel.  
Your ideas are welcome.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 2, 2024, 12:30pm UTC](https://forum.inductiveautomation.com/t/writing-data-to-a-excel-template/92674/2 "2024-07-02T12:30:46Z")

</div>

There are numerous examples on this forum showing how to perform **custom** operations with Excel files via the Apache POI libraries that are provided with Ignition:

[https://forum.inductiveautomation.com/search?q=apache%20poi%20excel%20perspective%20order%3Alatest](https://forum.inductiveautomation.com/search?q=apache%20poi%20excel%20perspective%20order%3Alatest)

Most of these topics perform one the two following general sequences:

1. Read:

- Upload a workbook (Perspective) or read a local workbook file (Vision), then
- Extract desired information from the content of the workbook, and finally
- Save the extracted data either in a database or in Ignition tags.

1. Write:

- Collect data from a database or a historian or from Ignition tags, then
- Construct a workbook from scratch in some desired layout, and finally
- Download the finished file (Perspective) or write the finished file locally (Vision).

Your task is slightly more complicated, as it is parts of both of the above:

- Upload a workbook (Perspective) or read a local workbook file (Vision), then
- Collect data from a database or a historian or from Ignition tags, and then
- Access the "SPC" sheet of the workbook and insert the desired data, and finally
- Download the finished file (Perspective) or write the finished file locally (Vision).

You will have to study the topics I linked, and possibly the [Apache POI documentation](https://poi.apache.org/apidocs/4.1/).