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
Exporting Excel data to an already existing .xlsx file General Usage	9	4670	July 10, 2021
XLSX.jl: writing sheets from vectors New to Julia question , xlsx	1	842	May 28, 2021
Writing a dataframe to Excel XLSX Data dataframes , excel	5	3616	April 21, 2021
How to export multiple dataframe to multiple excel worksheets (in a loop)? General Usage	9	13673	August 28, 2018
[ANN] XLSX.jl reaches v0.1.0 Community package , announcement	3	1090	May 21, 2018

How to write matrix data to Excel in separate worksheets?

Related topics