# 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:** 5
**Page:** 1
### Author:  [@adikaagas](https://discourse.julialang.org/u/adikaagas)
#### Post date: [July 13, 2021, 11:16am UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557/1 "2021-07-13T11:16:44Z")
I have matrix data type that stored in atom workspace called `sheet1 = [1 2 3; 4 5 6]` and `sheet2 = [1 1 1; 2 2 2]`
how do i write this variable into excel workbook with a different worksheet?
`xlxs.addsheet!` didnt work , tq
---
### Author:  [@nilshg](https://discourse.julialang.org/u/nilshg)
#### Post date: [July 13, 2021, 2:36pm UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557/2 "2021-07-13T14:36:40Z")
Which package are you using? Your last line suggests you might be using `XLSX`, have you looked at the relevant docs, which seem to cover what you’re after?
[https://felipenoris.github.io/XLSX.jl/dev/tutorial/#Writing-Excel-Files](https://felipenoris.github.io/XLSX.jl/dev/tutorial/#Writing-Excel-Files)
---
### Author:  [@adikaagas](https://discourse.julialang.org/u/adikaagas)
#### Post date: [July 13, 2021, 3:40pm UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557/3 "2021-07-13T15:40:26Z")
Yes i’m using XLSX , but the problem is i want to export multiple matrix to a single excel file. Each matrix will be put in seperate worksheet.
I already read about the documentation, but still didnt get the answer
---
### Author:  [@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")
@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
```
---
### Author:  [@adikaagas](https://discourse.julialang.org/u/adikaagas)
#### Post date: [July 17, 2021, 1:05am UTC](https://discourse.julialang.org/t/how-to-write-matrix-data-to-excel-in-separate-worksheets/64557/5 "2021-07-17T01:05:57Z")
Thankyou for the answer, it helps a lot to undertand about XLXS documentation