# How to write matrix data to Excel in separate worksheets?

**URL:** https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557
**Category:** New to Julia
**Tags:** question, excel
**Created:** [July 13, 2021, 11:16am UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557 "2021-07-13T11:16:44Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![rafael.guerra](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael.guerra/32/216610_2.png) [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)
#### Post date: [July 13, 2021, 3:47pm UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557/4 "2021-07-13T15:47:04Z")

</div>

@adikaagas, welcome to discourse. Recommend posting a [MWE as per guidelines](https://discourse.julialang.org/t/please-read-make-it-easier-to-help-you/14757).

_ **NB:** edited code to cover one additional use case_

```julia
using XLSX

data1 = [[1, 2, 3], [4, 5, 6]];
data2 = [[1, 1, 1], [2, 2, 2]];    
data3 = [[0, 1,-1], [-2,0, 2]];

# write data1 to SHEET_A and data2 to SHEET_B
XLSX.writetable("TEST123.xlsx", SHEET_A=(data1, [:col1,:col2]),
       SHEET_B=(data2, [:col1 :col2]), overwrite=true)

# write data3 into existing SHEET_A
XLSX.openxlsx("TEST123.xlsx", mode="rw") do xf
    sheet = xf[1]
    XLSX.writetable!(sheet, data3, [:col1,:col2], anchor_cell=XLSX.CellRef("B10"))
end

# write data3 to new SHEET_C
XLSX.openxlsx("TEST123.xlsx", mode="rw") do xf
    n = XLSX.sheetcount(xf)
    XLSX.addsheet!(xf, "SHEET_C")
    sheet = xf[n+1]
    XLSX.writetable!(sheet, data3, [:col1,:col2])
end

```

---

_[View the full topic](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557)._