# How to create and write data to excel file without prompting a dialog

**URL:** <https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934>\
**Category:** Ignition\
**Tags:** scripting, database, ignition80\
**Created:** [June 18, 2021, 8:36am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934 "2021-06-18T08:36:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![turgutisa](https://avatars.discourse-cdn.com/v4/letter/t/f4b2a3/32.png) [@turgutisa](https://forum.inductiveautomation.com/u/turgutisa)\
**Post date:** [June 18, 2021, 8:36am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934/1 "2021-06-18T08:36:03Z")

</div>

I want to export the dataset to excel by using system.dataset.exportExcel() function. when I tried, it asked me to select a path to export it. But I want it to export my data with overwriting and without asking me to select path. I cannot see a paramater about that inside the function. How can I do that ?

---

<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:** [June 18, 2021, 10:18am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934/2 "2021-06-18T10:18:08Z")

</div>

Use system.dataset.toExcel() instead, then system.file.writeFile(). See the example for toExcel().

[https://docs.inductiveautomation.com/display/DOC80/system.dataset.toExcel](https://docs.inductiveautomation.com/display/DOC80/system.dataset.toExcel)

---

<div class="post-metadata">

**Author:** ![jesusaltamirano600](https://avatars.discourse-cdn.com/v4/letter/j/b782af/32.png) [@jesusaltamirano600](https://forum.inductiveautomation.com/u/jesusaltamirano600)\
**Post date:** [June 24, 2023, 12:31am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934/3 "2023-06-24T00:31:37Z")

</div>

Hi guys, Im using the "system.dataset.toExcel" function to create my file but I would like to have the option of the save dialog to select the location. Do you know how to do it?

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [June 24, 2023, 1:50am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934/4 "2023-06-24T01:50:47Z")

</div>

> [@jesusaltamirano600](#):
>
> system.dataset.toExcel

Try this one (The opposite of the original post):  
[https://docs.inductiveautomation.com/display/DOC81/system.dataset.exportExcel](https://docs.inductiveautomation.com/display/DOC81/system.dataset.exportExcel)

---

<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:** [June 24, 2023, 2:14am UTC](https://forum.inductiveautomation.com/t/how-to-create-and-write-data-to-excel-file-without-prompting-a-dialog/47934/5 "2023-06-24T02:14:56Z")

</div>

Note that `.exportExcel()` is Vision only...

> [@jesusaltamirano600](#):
>
> would like to have the option of the save dialog to select the location

...because this part is Vision only. Browsers (Perspective) only provide such a dialog for downloads, and offer the source website no influence over the target folder.

This old OP isn't tagged "Vision", but must have been.