# Writing dataframes or arrays from Julia to excel file

**URL:** <https://discourse.julialang.org/t/writing-dataframes-or-arrays-from-julia-to-excel-file/112096>\
**Category:** New to Julia\
**Tags:** question\
**Created:** [March 25, 2024, 4:11pm UTC](https://discourse.julialang.org/t/writing-dataframes-or-arrays-from-julia-to-excel-file/112096 "2024-03-25T16:11:04Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Nathan\_Boyer](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nathan_boyer/32/14825_2.png) [@Nathan\_Boyer](https://discourse.julialang.org/u/Nathan_Boyer)\
**Post date:** [March 25, 2024, 6:18pm UTC](https://discourse.julialang.org/t/writing-dataframes-or-arrays-from-julia-to-excel-file/112096/9 "2024-03-25T18:18:32Z")

</div>

> [@ssrrii](#):
>
> Now, I will also dive into the idea of Nathan.

What you wrote is correct and fine. I am just pointing out that …

```julia
XLSX.CellRef("F1") == XLSX.CellRef(1,6)

```

and you may find that alternate form more convenient if you need to do math to get your `anchor_cell` locations.

* * *

> [@ssrrii](#):
>
> I am still a bit puzzled why it was not writable.

 ![image](https://global.discourse-cdn.com/julialang/original/3X/d/7/d7d05ca12548428bc67840d1a20cf7efd4974376.png)

The Excel file needs to be open for writing when you go to `addsheet!` or `writetable!`.

* * *

Also, for posts on this forum please read through the link below, especially #2. Your code is difficult to read without formatting.

> [@Please read: make it easier to help you](https://discourse.julialang.org/t/please-read-make-it-easier-to-help-you/14757):
>
> Welcome to the Julia Discourse! We are enthusiastic about helping Julia programmers, both beginner and experienced. This public service announcement (PSA) outlines best practices when asking for help. Following these points makes it easier for us to help you and more likely you’ll get a prompt, useful answer. Keywords are highlighted to make it easier to refer to specific points. Choose a descriptive title that captures the key part of your question, eg “plots with multiple axes” instead of …

---

_[View the full topic](https://discourse.julialang.org/t/writing-dataframes-or-arrays-from-julia-to-excel-file/112096)._