My problem is assigning employees to offices.
I would like to post the solution in an excel file, in this form:
At the moment my code looks like this:
XLSX.openxlsx("choix élèves julia.xlsx", mode="rw") do xf
!XLSX.hassheet(xf, "ATTRIBUTION") && XLSX.addsheet!(xf, "ATTRIBUTION")
sheet = xf["ATTRIBUTION"]
sheet["A1", dim=2] = collect(1:4)
for j in 1
sheet[j+1,1] = string("Sujet ",j,":") #string pour mettre plusieurs éléments dans une même case
for i in 1:e, k in 1:e
if JuMP.value.(x[i,j])==1
sheet[j+1,2] = i
sum(x[i,j] for i in 1:e)=k
end
end
end
end