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

@adikaagas , welcome to discourse. Recommend posting a MWE as per guidelines . NB: edited code to cover one additional use case 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.writetab…

How to write matrix data to Excel in separate worksheets?

New to Julia

adikaagas July 17, 2021, 1:05am 5

Thankyou for the answer, it helps a lot to undertand about XLXS documentation

1 Like

Topic		Replies	Views
Writing dataframes or arrays from Julia to excel file New to Julia question	12	2377	March 26, 2024
XLSX package New to Julia package , xlsx	5	151	February 6, 2026
Exporting Excel data to an already existing .xlsx file General Usage	9	4707	July 10, 2021
Create excel file using data from two dataframes General Usage dataframes , xlsx , excel	5	637	February 19, 2024
XLSX.jl: writing sheets from vectors New to Julia question , xlsx	1	847	May 28, 2021

How to write matrix data to Excel in separate worksheets?

Related topics