Writing dataframes or arrays from Julia to excel file

[Nathan_Boyer]

@ssrrii

Now, I will also dive into the idea of Nathan.

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

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.

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

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 …