how can I export multidimensional matrix from julia in excel?How can I create a two dimensional array in JavaScript?How to Flatten a Multidimensional Array?How to use searchsorted on a column of a multidimensional array in Julia?How to construct a matrix in Julia sequentially?How to append a vector to Julia matrix as a row?Assignment to multidimensional array in juliaJulia multidimensional array types?Subsampling a multidimensional array in JuliaHow to convert a multidimensional array to/from vector of vector of … vector in juliaConcatenate Multidimensional arrays in Julia

Can one guy with a duplicator initiate a nuclear apocalypse?

What did the controller say during my approach to land (audio clip)?

Should the pagination be reset when changing the order?

What do solvers like Gurobi and CPLEX do when they run into hard instances of MIP

Weapon class firing logic in JavaScript

Exam design: give maximum score per question or not?

Convert dictionaries with list of values into a dataframe

Can I separate garlic into cloves for storage?

Get the encrypted payload from an unencrypted wrapper PDF document

Quick Kurodoko Puzzle: Threes and Triples

Why are there two bearded faces wearing red hats on my stealth bomber icon?

Removing rows containing NA in every column

Is “卧草” a proper Chinese word?

Is the name of an interval between two notes unique and absolute?

How does one calculate the distribution of the Matt Colville way of rolling stats?

Floating Point XOR

How could artificial intelligence harm us?

Minimize taxes now that I earn more

Other than good shoes and a stick, what are some ways to preserve your knees on long hikes?

Did slaves have slaves?

Is Zack Morris's 'time stop' ability in "Saved By the Bell" a supernatural ability?

Is there any actual security benefit to restricting foreign IPs?

Lead Amalgam as a Material for a Sword

Debussy as term for bathroom?



how can I export multidimensional matrix from julia in excel?


How can I create a two dimensional array in JavaScript?How to Flatten a Multidimensional Array?How to use searchsorted on a column of a multidimensional array in Julia?How to construct a matrix in Julia sequentially?How to append a vector to Julia matrix as a row?Assignment to multidimensional array in juliaJulia multidimensional array types?Subsampling a multidimensional array in JuliaHow to convert a multidimensional array to/from vector of vector of … vector in juliaConcatenate Multidimensional arrays in Julia






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








-4















I have a multiple dimensional matrix in my result for example x[i,j,k,t]. how can I export it from Julia in excel?
for example I have this matrix in Julia. I coded a location inventory vehicle routing model in Julia. that is the optimum routing matrix. I want to export it in excel. please help me. 



`xx
x: 4 dimensions:
[1,:,:,:]
 [1,1,:,:]
 [1,1,1,:]
 [1,1,1,1] = 0.0
 [1,1,1,2] = 0.0
 [1,1,1,3] = 0.0
 [1,1,2,:]
 [1,1,2,1] = 0.0
 [1,1,2,2] = 0.0
 [1,1,2,3] = 0.0
 [1,1,3,:]
 [1,1,3,1] = 0.0
 [1,1,3,2] = 0.0
 [1,1,3,3] = 0.0
 [1,2,:,:]
 [1,2,1,:]
 [1,2,1,1] = -0.0
 [1,2,1,2] = 0.0
 [1,2,1,3] = 0.0
 [1,2,2,:]
 [1,2,2,1] = 0.0
 [1,2,2,2] = 0.0
 [1,2,2,3] = 0.0
 [1,2,3,:]
 [1,2,3,1] = 0.0
 [1,2,3,2] = 0.0
 [1,2,3,3] = 0.0
 [1,3,:,:]
 [1,3,1,:]
 [1,3,1,1] = -0.0
 [1,3,1,2] = 0.0
 [1,3,1,3] = 0.0
 [1,3,2,:]
 [1,3,2,1] = 0.0
 [1,3,2,2] = 0.0
 [1,3,2,3] = -0.0
 [1,3,3,:]
 [1,3,3,1] = 0.0
 [1,3,3,2] = 0.0
 [1,3,3,3] = 0.0
 [1,4,:,:]
 [1,4,1,:]
 [1,4,1,1] = -0.0
 [1,4,1,2] = -0.0
 [1,4,1,3] = -0.0
 [1,4,2,:]
 [1,4,2,1] = -0.0
 [1,4,2,2] = -0.0
 [1,4,2,3] = -0.0
 [1,4,3,:]
 [1,4,3,1] = 0.0
 [1,4,3,2] = 0.0
 [1,4,3,3] = 0.0
 [1,5,:,:]
 [1,5,1,:]
 [1,5,1,1] = -0.0
 [1,5,1,2] = -0.0
 [1,5,1,3] = -0.0
 [1,5,2,:]
 [1,5,2,1] = -0.0
 [1,5,2,2] = -0.0
 [1,5,2,3] = 0.0
 [1,5,3,:]
 [1,5,3,1] = -0.0
 [1,5,3,2] = 0.0
 [1,5,3,3] = 0.0
 [1,6,:,:]
 [1,6,1,:]
 [1,6,1,1] = -0.0
 [1,6,1,2] = -0.0
 [1,6,1,3] = -0.0
 [1,6,2,:]
 [1,6,2,1] = -0.0
 [1,6,2,2] = -0.0
 [1,6,2,3] = 1.0
 [1,6,3,:]
 [1,6,3,1] = 1.0
 [1,6,3,2] = 1.0
 [1,6,3,3] = -0.0
[2,:,:,:]
 [2,1,:,:]
 [2,1,1,:]
 [2,1,1,1] = 0.0
 [2,1,1,2] = 0.0
 [2,1,1,3] = 0.0
 [2,1,2,:]
 [2,1,2,1] = 0.0
 [2,1,2,2] = 0.0
 [2,1,2,3] = 1.0
 [2,1,3,:]
 [2,1,3,1] = 1.0
 [2,1,3,2] = 1.0
 [2,1,3,3] = 0.0
 [2,2,:,:]
 [2,2,1,:]
 [2,2,1,1] = 0.0
 [2,2,1,2] = 0.0
 [2,2,1,3] = 0.0
 [2,2,2,:]
 [2,2,2,1] = 0.0
 [2,2,2,2] = 0.0
 [2,2,2,3] = 0.0
 [2,2,3,:]
 [2,2,3,1] = 0.0
 [2,2,3,2] = 0.0
 [2,2,3,3] = 0.0
 [2,3,:,:]
 [2,3,1,:]
 [2,3,1,1] = 0.0
 [2,3,1,2] = 0.0
 [2,3,1,3] = -0.0
 [2,3,2,:]
 [2,3,2,1] = 0.0
 [2,3,2,2] = 0.0
 [2,3,2,3] = 0.0
 [2,3,3,:]
 [2,3,3,1] = 0.0
 [2,3,3,2] = 0.0
 [2,3,3,3] = 0.0
 [2,4,:,:]
 [2,4,1,:]
 [2,4,1,1] = -0.0
 [2,4,1,2] = -0.0
 [2,4,1,3] = -0.0
 [2,4,2,:]
 [2,4,2,1] = -0.0
 [2,4,2,2] = -0.0
 [2,4,2,3] = -0.0
 [2,4,3,:]
 [2,4,3,1] = 0.0
 [2,4,3,2] = -0.0
 [2,4,3,3] = -0.0
 [2,5,:,:]
 [2,5,1,:]
 [2,5,1,1] = 0.0
 [2,5,1,2] = -0.0
 [2,5,1,3] = -0.0
 [2,5,2,:]
 [2,5,2,1] = 0.0
 [2,5,2,2] = -0.0
 [2,5,2,3] = -0.0
 [2,5,3,:]
 [2,5,3,1] = 0.0
 [2,5,3,2] = -0.0
 [2,5,3,3] = -0.0
 [2,6,:,:]
 [2,6,1,:]
 [2,6,1,1] = -0.0
 [2,6,1,2] = -0.0
 [2,6,1,3] = -0.0
 [2,6,2,:]
 [2,6,2,1] = -0.0
 [2,6,2,2] = -0.0
 [2,6,2,3] = -0.0
 [2,6,3,:]
 [2,6,3,1] = -0.0
 [2,6,3,2] = -0.0
 [2,6,3,3] = -0.0
[3,:,:,:]
 [3,1,:,:]
 [3,1,1,:]
 [3,1,1,1] = 0.0
 [3,1,1,2] = 0.0
 [3,1,1,3] = 0.0
 [3,1,2,:]
 [3,1,2,1] = -0.0
 [3,1,2,2] = 0.0
 [3,1,2,3] = 0.0
 [3,1,3,:]
 [3,1,3,1] = -0.0
 [3,1,3,2] = -0.0
 [3,1,3,3] = 0.0
 [3,2,:,:]
 [3,2,1,:]
 [3,2,1,1] = 0.0
 [3,2,1,2] = -0.0
 [3,2,1,3] = 0.0
 [3,2,2,:]
 [3,2,2,1] = 0.0
 [3,2,2,2] = -0.0
 [3,2,2,3] = 1.0
 [3,2,3,:]
 [3,2,3,1] = 1.0
 [3,2,3,2] = 0.9999999999999996
 [3,2,3,3] = 0.0
 [3,3,:,:]
 [3,3,1,:]
 [3,3,1,1] = 0.0
 [3,3,1,2] = 0.0
 [3,3,1,3] = 0.0
 [3,3,2,:]
 [3,3,2,1] = 0.0
 [3,3,2,2] = 0.0
 [3,3,2,3] = 0.0
 [3,3,3,:]
 [3,3,3,1] = 0.0
 [3,3,3,2] = 0.0
 [3,3,3,3] = 0.0
 [3,4,:,:]
 [3,4,1,:]
 [3,4,1,1] = 0.0
 [3,4,1,2] = -0.0
 [3,4,1,3] = -0.0
 [3,4,2,:]
 [3,4,2,1] = -0.0
 [3,4,2,2] = -0.0
 [3,4,2,3] = 0.0
 [3,4,3,:]
 [3,4,3,1] = 0.0
 [3,4,3,2] = -0.0
 [3,4,3,3] = -0.0
 [3,5,:,:]
 [3,5,1,:]
 [3,5,1,1] = 0.0
 [3,5,1,2] = -0.0
 [3,5,1,3] = 0.0
 [3,5,2,:]
 [3,5,2,1] = 0.0
 [3,5,2,2] = -0.0
 [3,5,2,3] = -0.0
 [3,5,3,:]
 [3,5,3,1] = -0.0
 [3,5,3,2] = -0.0
 [3,5,3,3] = -0.0
 [3,6,:,:]
 [3,6,1,:]
 [3,6,1,1] = -0.0
 [3,6,1,2] = -0.0
 [3,6,1,3] = -0.0
 [3,6,2,:]
 [3,6,2,1] = -0.0
 [3,6,2,2] = -0.0
 [3,6,2,3] = -0.0
 [3,6,3,:]
 [3,6,3,1] = -0.0
 [3,6,3,2] = -0.0
 [3,6,3,3] = -0.0
[4,:,:,:]
 [4,1,:,:]
 [4,1,1,:]
 [4,1,1,1] = -0.0
 [4,1,1,2] = 0.0
 [4,1,1,3] = 0.0
 [4,1,2,:]
 [4,1,2,1] = -0.0
 [4,1,2,2] = 0.0
 [4,1,2,3] = -0.0
 [4,1,3,:]
 [4,1,3,1] = -0.0
 [4,1,3,2] = -0.0
 [4,1,3,3] = -0.0
 [4,2,:,:]
 [4,2,1,:]
 [4,2,1,1] = -0.0
 [4,2,1,2] = -0.0
 [4,2,1,3] = -0.0
 [4,2,2,:]
 [4,2,2,1] = -0.0
 [4,2,2,2] = -0.0
 [4,2,2,3] = 0.0
 [4,2,3,:]
 [4,2,3,1] = -0.0
 [4,2,3,2] = 0.0
 [4,2,3,3] = -0.0
 [4,3,:,:]
 [4,3,1,:]
 [4,3,1,1] = 0.0
 [4,3,1,2] = 0.0
 [4,3,1,3] = -0.0
 [4,3,2,:]
 [4,3,2,1] = 0.0
 [4,3,2,2] = 0.0
 [4,3,2,3] = 1.0
 [4,3,3,:]
 [4,3,3,1] = 1.0
 [4,3,3,2] = 0.9999999999999996
 [4,3,3,3] = 0.0
 [4,4,:,:]
 [4,4,1,:]
 [4,4,1,1] = 0.0
 [4,4,1,2] = 0.0
 [4,4,1,3] = 0.0
 [4,4,2,:]
 [4,4,2,1] = 0.0
 [4,4,2,2] = 0.0
 [4,4,2,3] = 0.0
 [4,4,3,:]
 [4,4,3,1] = 0.0
 [4,4,3,2] = 0.0
 [4,4,3,3] = 0.0
 [4,5,:,:]
 [4,5,1,:]
 [4,5,1,1] = -0.0
 [4,5,1,2] = -0.0
 [4,5,1,3] = 0.0
 [4,5,2,:]
 [4,5,2,1] = 0.0
 [4,5,2,2] = 0.0
 [4,5,2,3] = -0.0
 [4,5,3,:]
 [4,5,3,1] = -0.0
 [4,5,3,2] = -0.0
 [4,5,3,3] = 0.0
 [4,6,:,:]
 [4,6,1,:]
 [4,6,1,1] = -0.0
 [4,6,1,2] = -0.0
 [4,6,1,3] = -0.0
 [4,6,2,:]
 [4,6,2,1] = -0.0
 [4,6,2,2] = -0.0
 [4,6,2,3] = -0.0
 [4,6,3,:]
 [4,6,3,1] = -0.0
 [4,6,3,2] = -0.0
 [4,6,3,3] = -0.0
[5,:,:,:]
 [5,1,:,:]
 [5,1,1,:]
 [5,1,1,1] = -0.0
 [5,1,1,2] = 0.0
 [5,1,1,3] = 0.0
 [5,1,2,:]
 [5,1,2,1] = -0.0
 [5,1,2,2] = 0.0
 [5,1,2,3] = -0.0
 [5,1,3,:]
 [5,1,3,1] = 0.0
 [5,1,3,2] = 0.0
 [5,1,3,3] = -0.0
 [5,2,:,:]
 [5,2,1,:]
 [5,2,1,1] = 0.0
 [5,2,1,2] = -0.0
 [5,2,1,3] = -0.0
 [5,2,2,:]
 [5,2,2,1] = -0.0
 [5,2,2,2] = -0.0
 [5,2,2,3] = 0.0
 [5,2,3,:]
 [5,2,3,1] = 0.0
 [5,2,3,2] = 0.0
 [5,2,3,3] = -0.0
 [5,3,:,:]
 [5,3,1,:]
 [5,3,1,1] = 0.0
 [5,3,1,2] = -0.0
 [5,3,1,3] = 0.0
 [5,3,2,:]
 [5,3,2,1] = 0.0
 [5,3,2,2] = -0.0
 [5,3,2,3] = 0.0
 [5,3,3,:]
 [5,3,3,1] = 0.0
 [5,3,3,2] = -0.0
 [5,3,3,3] = -0.0
 [5,4,:,:]
 [5,4,1,:]
 [5,4,1,1] = 0.0
 [5,4,1,2] = 0.0
 [5,4,1,3] = 0.0
 [5,4,2,:]
 [5,4,2,1] = 0.0
 [5,4,2,2] = -0.0
 [5,4,2,3] = 1.0
 [5,4,3,:]
 [5,4,3,1] = 1.0
 [5,4,3,2] = 0.9999999999999996
 [5,4,3,3] = 0.0
 [5,5,:,:]
 [5,5,1,:]
 [5,5,1,1] = 0.0
 [5,5,1,2] = 0.0
 [5,5,1,3] = 0.0
 [5,5,2,:]
 [5,5,2,1] = 0.0
 [5,5,2,2] = 0.0
 [5,5,2,3] = 0.0
 [5,5,3,:]
 [5,5,3,1] = 0.0
 [5,5,3,2] = 0.0
 [5,5,3,3] = 0.0
 [5,6,:,:]
 [5,6,1,:]
 [5,6,1,1] = -0.0
 [5,6,1,2] = -0.0
 [5,6,1,3] = 0.0
 [5,6,2,:]
 [5,6,2,1] = 0.0
 [5,6,2,2] = 0.0
 [5,6,2,3] = -0.0
 [5,6,3,:]
 [5,6,3,1] = 0.0
 [5,6,3,2] = -0.0
 [5,6,3,3] = -0.0
[6,:,:,:]
 [6,1,:,:]
 [6,1,1,:]
 [6,1,1,1] = -0.0
 [6,1,1,2] = 0.0
 [6,1,1,3] = -0.0
 [6,1,2,:]
 [6,1,2,1] = -0.0
 [6,1,2,2] = -0.0
 [6,1,2,3] = -0.0
 [6,1,3,:]
 [6,1,3,1] = -0.0
 [6,1,3,2] = -0.0
 [6,1,3,3] = -0.0
 [6,2,:,:]
 [6,2,1,:]
 [6,2,1,1] = -0.0
 [6,2,1,2] = -0.0
 [6,2,1,3] = -0.0
 [6,2,2,:]
 [6,2,2,1] = -0.0
 [6,2,2,2] = -0.0
 [6,2,2,3] = 0.0
 [6,2,3,:]
 [6,2,3,1] = -0.0
 [6,2,3,2] = -0.0
 [6,2,3,3] = -0.0
 [6,3,:,:]
 [6,3,1,:]
 [6,3,1,1] = -0.0
 [6,3,1,2] = -0.0
 [6,3,1,3] = -0.0
 [6,3,2,:]
 [6,3,2,1] = -0.0
 [6,3,2,2] = -0.0
 [6,3,2,3] = -0.0
 [6,3,3,:]
 [6,3,3,1] = -0.0
 [6,3,3,2] = -0.0
 [6,3,3,3] = -0.0
 [6,4,:,:]
 [6,4,1,:]
 [6,4,1,1] = -0.0
 [6,4,1,2] = -0.0
 [6,4,1,3] = -0.0
 [6,4,2,:]
 [6,4,2,1] = -0.0
 [6,4,2,2] = -0.0
 [6,4,2,3] = -0.0
 [6,4,3,:]
 [6,4,3,1] = -0.0
 [6,4,3,2] = 0.0
 [6,4,3,3] = -0.0
 [6,5,:,:]
 [6,5,1,:]
 [6,5,1,1] = 0.0
 [6,5,1,2] = 0.0
 [6,5,1,3] = -0.0
 [6,5,2,:]
 [6,5,2,1] = -0.0
 [6,5,2,2] = -0.0
 [6,5,2,3] = 1.0
 [6,5,3,:]
 [6,5,3,1] = 1.0
 [6,5,3,2] = 0.9999999999999996
 [6,5,3,3] = 0.0
 [6,6,:,:]
 [6,6,1,:]
 [6,6,1,1] = 0.0
 [6,6,1,2] = 0.0
 [6,6,1,3] = 0.0
 [6,6,2,:]
 [6,6,2,1] = 0.0
 [6,6,2,2] = 0.0
 [6,6,2,3] = 0.0
 [6,6,3,:]
 [6,6,3,1] = 0.0
 [6,6,3,2] = 0.0
 [6,6,3,3] = 0


.0`






multidimensional-array julia







share|improve this question





















  • 1





    Can you please specify how you want the data to look like in Excel?

    – Bogumił Kamiński
    Mar 27 at 18:34











  • xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

    – Soma
    Mar 28 at 13:40






  • 5





    Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

    – E_net4
    Mar 28 at 14:19

















-4















I have a multiple dimensional matrix in my result for example x[i,j,k,t]. how can I export it from Julia in excel?
for example I have this matrix in Julia. I coded a location inventory vehicle routing model in Julia. that is the optimum routing matrix. I want to export it in excel. please help me. 



`xx
x: 4 dimensions:
[1,:,:,:]
 [1,1,:,:]
 [1,1,1,:]
 [1,1,1,1] = 0.0
 [1,1,1,2] = 0.0
 [1,1,1,3] = 0.0
 [1,1,2,:]
 [1,1,2,1] = 0.0
 [1,1,2,2] = 0.0
 [1,1,2,3] = 0.0
 [1,1,3,:]
 [1,1,3,1] = 0.0
 [1,1,3,2] = 0.0
 [1,1,3,3] = 0.0
 [1,2,:,:]
 [1,2,1,:]
 [1,2,1,1] = -0.0
 [1,2,1,2] = 0.0
 [1,2,1,3] = 0.0
 [1,2,2,:]
 [1,2,2,1] = 0.0
 [1,2,2,2] = 0.0
 [1,2,2,3] = 0.0
 [1,2,3,:]
 [1,2,3,1] = 0.0
 [1,2,3,2] = 0.0
 [1,2,3,3] = 0.0
 [1,3,:,:]
 [1,3,1,:]
 [1,3,1,1] = -0.0
 [1,3,1,2] = 0.0
 [1,3,1,3] = 0.0
 [1,3,2,:]
 [1,3,2,1] = 0.0
 [1,3,2,2] = 0.0
 [1,3,2,3] = -0.0
 [1,3,3,:]
 [1,3,3,1] = 0.0
 [1,3,3,2] = 0.0
 [1,3,3,3] = 0.0
 [1,4,:,:]
 [1,4,1,:]
 [1,4,1,1] = -0.0
 [1,4,1,2] = -0.0
 [1,4,1,3] = -0.0
 [1,4,2,:]
 [1,4,2,1] = -0.0
 [1,4,2,2] = -0.0
 [1,4,2,3] = -0.0
 [1,4,3,:]
 [1,4,3,1] = 0.0
 [1,4,3,2] = 0.0
 [1,4,3,3] = 0.0
 [1,5,:,:]
 [1,5,1,:]
 [1,5,1,1] = -0.0
 [1,5,1,2] = -0.0
 [1,5,1,3] = -0.0
 [1,5,2,:]
 [1,5,2,1] = -0.0
 [1,5,2,2] = -0.0
 [1,5,2,3] = 0.0
 [1,5,3,:]
 [1,5,3,1] = -0.0
 [1,5,3,2] = 0.0
 [1,5,3,3] = 0.0
 [1,6,:,:]
 [1,6,1,:]
 [1,6,1,1] = -0.0
 [1,6,1,2] = -0.0
 [1,6,1,3] = -0.0
 [1,6,2,:]
 [1,6,2,1] = -0.0
 [1,6,2,2] = -0.0
 [1,6,2,3] = 1.0
 [1,6,3,:]
 [1,6,3,1] = 1.0
 [1,6,3,2] = 1.0
 [1,6,3,3] = -0.0
[2,:,:,:]
 [2,1,:,:]
 [2,1,1,:]
 [2,1,1,1] = 0.0
 [2,1,1,2] = 0.0
 [2,1,1,3] = 0.0
 [2,1,2,:]
 [2,1,2,1] = 0.0
 [2,1,2,2] = 0.0
 [2,1,2,3] = 1.0
 [2,1,3,:]
 [2,1,3,1] = 1.0
 [2,1,3,2] = 1.0
 [2,1,3,3] = 0.0
 [2,2,:,:]
 [2,2,1,:]
 [2,2,1,1] = 0.0
 [2,2,1,2] = 0.0
 [2,2,1,3] = 0.0
 [2,2,2,:]
 [2,2,2,1] = 0.0
 [2,2,2,2] = 0.0
 [2,2,2,3] = 0.0
 [2,2,3,:]
 [2,2,3,1] = 0.0
 [2,2,3,2] = 0.0
 [2,2,3,3] = 0.0
 [2,3,:,:]
 [2,3,1,:]
 [2,3,1,1] = 0.0
 [2,3,1,2] = 0.0
 [2,3,1,3] = -0.0
 [2,3,2,:]
 [2,3,2,1] = 0.0
 [2,3,2,2] = 0.0
 [2,3,2,3] = 0.0
 [2,3,3,:]
 [2,3,3,1] = 0.0
 [2,3,3,2] = 0.0
 [2,3,3,3] = 0.0
 [2,4,:,:]
 [2,4,1,:]
 [2,4,1,1] = -0.0
 [2,4,1,2] = -0.0
 [2,4,1,3] = -0.0
 [2,4,2,:]
 [2,4,2,1] = -0.0
 [2,4,2,2] = -0.0
 [2,4,2,3] = -0.0
 [2,4,3,:]
 [2,4,3,1] = 0.0
 [2,4,3,2] = -0.0
 [2,4,3,3] = -0.0
 [2,5,:,:]
 [2,5,1,:]
 [2,5,1,1] = 0.0
 [2,5,1,2] = -0.0
 [2,5,1,3] = -0.0
 [2,5,2,:]
 [2,5,2,1] = 0.0
 [2,5,2,2] = -0.0
 [2,5,2,3] = -0.0
 [2,5,3,:]
 [2,5,3,1] = 0.0
 [2,5,3,2] = -0.0
 [2,5,3,3] = -0.0
 [2,6,:,:]
 [2,6,1,:]
 [2,6,1,1] = -0.0
 [2,6,1,2] = -0.0
 [2,6,1,3] = -0.0
 [2,6,2,:]
 [2,6,2,1] = -0.0
 [2,6,2,2] = -0.0
 [2,6,2,3] = -0.0
 [2,6,3,:]
 [2,6,3,1] = -0.0
 [2,6,3,2] = -0.0
 [2,6,3,3] = -0.0
[3,:,:,:]
 [3,1,:,:]
 [3,1,1,:]
 [3,1,1,1] = 0.0
 [3,1,1,2] = 0.0
 [3,1,1,3] = 0.0
 [3,1,2,:]
 [3,1,2,1] = -0.0
 [3,1,2,2] = 0.0
 [3,1,2,3] = 0.0
 [3,1,3,:]
 [3,1,3,1] = -0.0
 [3,1,3,2] = -0.0
 [3,1,3,3] = 0.0
 [3,2,:,:]
 [3,2,1,:]
 [3,2,1,1] = 0.0
 [3,2,1,2] = -0.0
 [3,2,1,3] = 0.0
 [3,2,2,:]
 [3,2,2,1] = 0.0
 [3,2,2,2] = -0.0
 [3,2,2,3] = 1.0
 [3,2,3,:]
 [3,2,3,1] = 1.0
 [3,2,3,2] = 0.9999999999999996
 [3,2,3,3] = 0.0
 [3,3,:,:]
 [3,3,1,:]
 [3,3,1,1] = 0.0
 [3,3,1,2] = 0.0
 [3,3,1,3] = 0.0
 [3,3,2,:]
 [3,3,2,1] = 0.0
 [3,3,2,2] = 0.0
 [3,3,2,3] = 0.0
 [3,3,3,:]
 [3,3,3,1] = 0.0
 [3,3,3,2] = 0.0
 [3,3,3,3] = 0.0
 [3,4,:,:]
 [3,4,1,:]
 [3,4,1,1] = 0.0
 [3,4,1,2] = -0.0
 [3,4,1,3] = -0.0
 [3,4,2,:]
 [3,4,2,1] = -0.0
 [3,4,2,2] = -0.0
 [3,4,2,3] = 0.0
 [3,4,3,:]
 [3,4,3,1] = 0.0
 [3,4,3,2] = -0.0
 [3,4,3,3] = -0.0
 [3,5,:,:]
 [3,5,1,:]
 [3,5,1,1] = 0.0
 [3,5,1,2] = -0.0
 [3,5,1,3] = 0.0
 [3,5,2,:]
 [3,5,2,1] = 0.0
 [3,5,2,2] = -0.0
 [3,5,2,3] = -0.0
 [3,5,3,:]
 [3,5,3,1] = -0.0
 [3,5,3,2] = -0.0
 [3,5,3,3] = -0.0
 [3,6,:,:]
 [3,6,1,:]
 [3,6,1,1] = -0.0
 [3,6,1,2] = -0.0
 [3,6,1,3] = -0.0
 [3,6,2,:]
 [3,6,2,1] = -0.0
 [3,6,2,2] = -0.0
 [3,6,2,3] = -0.0
 [3,6,3,:]
 [3,6,3,1] = -0.0
 [3,6,3,2] = -0.0
 [3,6,3,3] = -0.0
[4,:,:,:]
 [4,1,:,:]
 [4,1,1,:]
 [4,1,1,1] = -0.0
 [4,1,1,2] = 0.0
 [4,1,1,3] = 0.0
 [4,1,2,:]
 [4,1,2,1] = -0.0
 [4,1,2,2] = 0.0
 [4,1,2,3] = -0.0
 [4,1,3,:]
 [4,1,3,1] = -0.0
 [4,1,3,2] = -0.0
 [4,1,3,3] = -0.0
 [4,2,:,:]
 [4,2,1,:]
 [4,2,1,1] = -0.0
 [4,2,1,2] = -0.0
 [4,2,1,3] = -0.0
 [4,2,2,:]
 [4,2,2,1] = -0.0
 [4,2,2,2] = -0.0
 [4,2,2,3] = 0.0
 [4,2,3,:]
 [4,2,3,1] = -0.0
 [4,2,3,2] = 0.0
 [4,2,3,3] = -0.0
 [4,3,:,:]
 [4,3,1,:]
 [4,3,1,1] = 0.0
 [4,3,1,2] = 0.0
 [4,3,1,3] = -0.0
 [4,3,2,:]
 [4,3,2,1] = 0.0
 [4,3,2,2] = 0.0
 [4,3,2,3] = 1.0
 [4,3,3,:]
 [4,3,3,1] = 1.0
 [4,3,3,2] = 0.9999999999999996
 [4,3,3,3] = 0.0
 [4,4,:,:]
 [4,4,1,:]
 [4,4,1,1] = 0.0
 [4,4,1,2] = 0.0
 [4,4,1,3] = 0.0
 [4,4,2,:]
 [4,4,2,1] = 0.0
 [4,4,2,2] = 0.0
 [4,4,2,3] = 0.0
 [4,4,3,:]
 [4,4,3,1] = 0.0
 [4,4,3,2] = 0.0
 [4,4,3,3] = 0.0
 [4,5,:,:]
 [4,5,1,:]
 [4,5,1,1] = -0.0
 [4,5,1,2] = -0.0
 [4,5,1,3] = 0.0
 [4,5,2,:]
 [4,5,2,1] = 0.0
 [4,5,2,2] = 0.0
 [4,5,2,3] = -0.0
 [4,5,3,:]
 [4,5,3,1] = -0.0
 [4,5,3,2] = -0.0
 [4,5,3,3] = 0.0
 [4,6,:,:]
 [4,6,1,:]
 [4,6,1,1] = -0.0
 [4,6,1,2] = -0.0
 [4,6,1,3] = -0.0
 [4,6,2,:]
 [4,6,2,1] = -0.0
 [4,6,2,2] = -0.0
 [4,6,2,3] = -0.0
 [4,6,3,:]
 [4,6,3,1] = -0.0
 [4,6,3,2] = -0.0
 [4,6,3,3] = -0.0
[5,:,:,:]
 [5,1,:,:]
 [5,1,1,:]
 [5,1,1,1] = -0.0
 [5,1,1,2] = 0.0
 [5,1,1,3] = 0.0
 [5,1,2,:]
 [5,1,2,1] = -0.0
 [5,1,2,2] = 0.0
 [5,1,2,3] = -0.0
 [5,1,3,:]
 [5,1,3,1] = 0.0
 [5,1,3,2] = 0.0
 [5,1,3,3] = -0.0
 [5,2,:,:]
 [5,2,1,:]
 [5,2,1,1] = 0.0
 [5,2,1,2] = -0.0
 [5,2,1,3] = -0.0
 [5,2,2,:]
 [5,2,2,1] = -0.0
 [5,2,2,2] = -0.0
 [5,2,2,3] = 0.0
 [5,2,3,:]
 [5,2,3,1] = 0.0
 [5,2,3,2] = 0.0
 [5,2,3,3] = -0.0
 [5,3,:,:]
 [5,3,1,:]
 [5,3,1,1] = 0.0
 [5,3,1,2] = -0.0
 [5,3,1,3] = 0.0
 [5,3,2,:]
 [5,3,2,1] = 0.0
 [5,3,2,2] = -0.0
 [5,3,2,3] = 0.0
 [5,3,3,:]
 [5,3,3,1] = 0.0
 [5,3,3,2] = -0.0
 [5,3,3,3] = -0.0
 [5,4,:,:]
 [5,4,1,:]
 [5,4,1,1] = 0.0
 [5,4,1,2] = 0.0
 [5,4,1,3] = 0.0
 [5,4,2,:]
 [5,4,2,1] = 0.0
 [5,4,2,2] = -0.0
 [5,4,2,3] = 1.0
 [5,4,3,:]
 [5,4,3,1] = 1.0
 [5,4,3,2] = 0.9999999999999996
 [5,4,3,3] = 0.0
 [5,5,:,:]
 [5,5,1,:]
 [5,5,1,1] = 0.0
 [5,5,1,2] = 0.0
 [5,5,1,3] = 0.0
 [5,5,2,:]
 [5,5,2,1] = 0.0
 [5,5,2,2] = 0.0
 [5,5,2,3] = 0.0
 [5,5,3,:]
 [5,5,3,1] = 0.0
 [5,5,3,2] = 0.0
 [5,5,3,3] = 0.0
 [5,6,:,:]
 [5,6,1,:]
 [5,6,1,1] = -0.0
 [5,6,1,2] = -0.0
 [5,6,1,3] = 0.0
 [5,6,2,:]
 [5,6,2,1] = 0.0
 [5,6,2,2] = 0.0
 [5,6,2,3] = -0.0
 [5,6,3,:]
 [5,6,3,1] = 0.0
 [5,6,3,2] = -0.0
 [5,6,3,3] = -0.0
[6,:,:,:]
 [6,1,:,:]
 [6,1,1,:]
 [6,1,1,1] = -0.0
 [6,1,1,2] = 0.0
 [6,1,1,3] = -0.0
 [6,1,2,:]
 [6,1,2,1] = -0.0
 [6,1,2,2] = -0.0
 [6,1,2,3] = -0.0
 [6,1,3,:]
 [6,1,3,1] = -0.0
 [6,1,3,2] = -0.0
 [6,1,3,3] = -0.0
 [6,2,:,:]
 [6,2,1,:]
 [6,2,1,1] = -0.0
 [6,2,1,2] = -0.0
 [6,2,1,3] = -0.0
 [6,2,2,:]
 [6,2,2,1] = -0.0
 [6,2,2,2] = -0.0
 [6,2,2,3] = 0.0
 [6,2,3,:]
 [6,2,3,1] = -0.0
 [6,2,3,2] = -0.0
 [6,2,3,3] = -0.0
 [6,3,:,:]
 [6,3,1,:]
 [6,3,1,1] = -0.0
 [6,3,1,2] = -0.0
 [6,3,1,3] = -0.0
 [6,3,2,:]
 [6,3,2,1] = -0.0
 [6,3,2,2] = -0.0
 [6,3,2,3] = -0.0
 [6,3,3,:]
 [6,3,3,1] = -0.0
 [6,3,3,2] = -0.0
 [6,3,3,3] = -0.0
 [6,4,:,:]
 [6,4,1,:]
 [6,4,1,1] = -0.0
 [6,4,1,2] = -0.0
 [6,4,1,3] = -0.0
 [6,4,2,:]
 [6,4,2,1] = -0.0
 [6,4,2,2] = -0.0
 [6,4,2,3] = -0.0
 [6,4,3,:]
 [6,4,3,1] = -0.0
 [6,4,3,2] = 0.0
 [6,4,3,3] = -0.0
 [6,5,:,:]
 [6,5,1,:]
 [6,5,1,1] = 0.0
 [6,5,1,2] = 0.0
 [6,5,1,3] = -0.0
 [6,5,2,:]
 [6,5,2,1] = -0.0
 [6,5,2,2] = -0.0
 [6,5,2,3] = 1.0
 [6,5,3,:]
 [6,5,3,1] = 1.0
 [6,5,3,2] = 0.9999999999999996
 [6,5,3,3] = 0.0
 [6,6,:,:]
 [6,6,1,:]
 [6,6,1,1] = 0.0
 [6,6,1,2] = 0.0
 [6,6,1,3] = 0.0
 [6,6,2,:]
 [6,6,2,1] = 0.0
 [6,6,2,2] = 0.0
 [6,6,2,3] = 0.0
 [6,6,3,:]
 [6,6,3,1] = 0.0
 [6,6,3,2] = 0.0
 [6,6,3,3] = 0


.0`






multidimensional-array julia







share|improve this question





















  • 1





    Can you please specify how you want the data to look like in Excel?

    – Bogumił Kamiński
    Mar 27 at 18:34











  • xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

    – Soma
    Mar 28 at 13:40






  • 5





    Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

    – E_net4
    Mar 28 at 14:19













-4












-4








-4








I have a multiple dimensional matrix in my result for example x[i,j,k,t]. how can I export it from Julia in excel?
for example I have this matrix in Julia. I coded a location inventory vehicle routing model in Julia. that is the optimum routing matrix. I want to export it in excel. please help me. 



`xx
x: 4 dimensions:
[1,:,:,:]
 [1,1,:,:]
 [1,1,1,:]
 [1,1,1,1] = 0.0
 [1,1,1,2] = 0.0
 [1,1,1,3] = 0.0
 [1,1,2,:]
 [1,1,2,1] = 0.0
 [1,1,2,2] = 0.0
 [1,1,2,3] = 0.0
 [1,1,3,:]
 [1,1,3,1] = 0.0
 [1,1,3,2] = 0.0
 [1,1,3,3] = 0.0
 [1,2,:,:]
 [1,2,1,:]
 [1,2,1,1] = -0.0
 [1,2,1,2] = 0.0
 [1,2,1,3] = 0.0
 [1,2,2,:]
 [1,2,2,1] = 0.0
 [1,2,2,2] = 0.0
 [1,2,2,3] = 0.0
 [1,2,3,:]
 [1,2,3,1] = 0.0
 [1,2,3,2] = 0.0
 [1,2,3,3] = 0.0
 [1,3,:,:]
 [1,3,1,:]
 [1,3,1,1] = -0.0
 [1,3,1,2] = 0.0
 [1,3,1,3] = 0.0
 [1,3,2,:]
 [1,3,2,1] = 0.0
 [1,3,2,2] = 0.0
 [1,3,2,3] = -0.0
 [1,3,3,:]
 [1,3,3,1] = 0.0
 [1,3,3,2] = 0.0
 [1,3,3,3] = 0.0
 [1,4,:,:]
 [1,4,1,:]
 [1,4,1,1] = -0.0
 [1,4,1,2] = -0.0
 [1,4,1,3] = -0.0
 [1,4,2,:]
 [1,4,2,1] = -0.0
 [1,4,2,2] = -0.0
 [1,4,2,3] = -0.0
 [1,4,3,:]
 [1,4,3,1] = 0.0
 [1,4,3,2] = 0.0
 [1,4,3,3] = 0.0
 [1,5,:,:]
 [1,5,1,:]
 [1,5,1,1] = -0.0
 [1,5,1,2] = -0.0
 [1,5,1,3] = -0.0
 [1,5,2,:]
 [1,5,2,1] = -0.0
 [1,5,2,2] = -0.0
 [1,5,2,3] = 0.0
 [1,5,3,:]
 [1,5,3,1] = -0.0
 [1,5,3,2] = 0.0
 [1,5,3,3] = 0.0
 [1,6,:,:]
 [1,6,1,:]
 [1,6,1,1] = -0.0
 [1,6,1,2] = -0.0
 [1,6,1,3] = -0.0
 [1,6,2,:]
 [1,6,2,1] = -0.0
 [1,6,2,2] = -0.0
 [1,6,2,3] = 1.0
 [1,6,3,:]
 [1,6,3,1] = 1.0
 [1,6,3,2] = 1.0
 [1,6,3,3] = -0.0
[2,:,:,:]
 [2,1,:,:]
 [2,1,1,:]
 [2,1,1,1] = 0.0
 [2,1,1,2] = 0.0
 [2,1,1,3] = 0.0
 [2,1,2,:]
 [2,1,2,1] = 0.0
 [2,1,2,2] = 0.0
 [2,1,2,3] = 1.0
 [2,1,3,:]
 [2,1,3,1] = 1.0
 [2,1,3,2] = 1.0
 [2,1,3,3] = 0.0
 [2,2,:,:]
 [2,2,1,:]
 [2,2,1,1] = 0.0
 [2,2,1,2] = 0.0
 [2,2,1,3] = 0.0
 [2,2,2,:]
 [2,2,2,1] = 0.0
 [2,2,2,2] = 0.0
 [2,2,2,3] = 0.0
 [2,2,3,:]
 [2,2,3,1] = 0.0
 [2,2,3,2] = 0.0
 [2,2,3,3] = 0.0
 [2,3,:,:]
 [2,3,1,:]
 [2,3,1,1] = 0.0
 [2,3,1,2] = 0.0
 [2,3,1,3] = -0.0
 [2,3,2,:]
 [2,3,2,1] = 0.0
 [2,3,2,2] = 0.0
 [2,3,2,3] = 0.0
 [2,3,3,:]
 [2,3,3,1] = 0.0
 [2,3,3,2] = 0.0
 [2,3,3,3] = 0.0
 [2,4,:,:]
 [2,4,1,:]
 [2,4,1,1] = -0.0
 [2,4,1,2] = -0.0
 [2,4,1,3] = -0.0
 [2,4,2,:]
 [2,4,2,1] = -0.0
 [2,4,2,2] = -0.0
 [2,4,2,3] = -0.0
 [2,4,3,:]
 [2,4,3,1] = 0.0
 [2,4,3,2] = -0.0
 [2,4,3,3] = -0.0
 [2,5,:,:]
 [2,5,1,:]
 [2,5,1,1] = 0.0
 [2,5,1,2] = -0.0
 [2,5,1,3] = -0.0
 [2,5,2,:]
 [2,5,2,1] = 0.0
 [2,5,2,2] = -0.0
 [2,5,2,3] = -0.0
 [2,5,3,:]
 [2,5,3,1] = 0.0
 [2,5,3,2] = -0.0
 [2,5,3,3] = -0.0
 [2,6,:,:]
 [2,6,1,:]
 [2,6,1,1] = -0.0
 [2,6,1,2] = -0.0
 [2,6,1,3] = -0.0
 [2,6,2,:]
 [2,6,2,1] = -0.0
 [2,6,2,2] = -0.0
 [2,6,2,3] = -0.0
 [2,6,3,:]
 [2,6,3,1] = -0.0
 [2,6,3,2] = -0.0
 [2,6,3,3] = -0.0
[3,:,:,:]
 [3,1,:,:]
 [3,1,1,:]
 [3,1,1,1] = 0.0
 [3,1,1,2] = 0.0
 [3,1,1,3] = 0.0
 [3,1,2,:]
 [3,1,2,1] = -0.0
 [3,1,2,2] = 0.0
 [3,1,2,3] = 0.0
 [3,1,3,:]
 [3,1,3,1] = -0.0
 [3,1,3,2] = -0.0
 [3,1,3,3] = 0.0
 [3,2,:,:]
 [3,2,1,:]
 [3,2,1,1] = 0.0
 [3,2,1,2] = -0.0
 [3,2,1,3] = 0.0
 [3,2,2,:]
 [3,2,2,1] = 0.0
 [3,2,2,2] = -0.0
 [3,2,2,3] = 1.0
 [3,2,3,:]
 [3,2,3,1] = 1.0
 [3,2,3,2] = 0.9999999999999996
 [3,2,3,3] = 0.0
 [3,3,:,:]
 [3,3,1,:]
 [3,3,1,1] = 0.0
 [3,3,1,2] = 0.0
 [3,3,1,3] = 0.0
 [3,3,2,:]
 [3,3,2,1] = 0.0
 [3,3,2,2] = 0.0
 [3,3,2,3] = 0.0
 [3,3,3,:]
 [3,3,3,1] = 0.0
 [3,3,3,2] = 0.0
 [3,3,3,3] = 0.0
 [3,4,:,:]
 [3,4,1,:]
 [3,4,1,1] = 0.0
 [3,4,1,2] = -0.0
 [3,4,1,3] = -0.0
 [3,4,2,:]
 [3,4,2,1] = -0.0
 [3,4,2,2] = -0.0
 [3,4,2,3] = 0.0
 [3,4,3,:]
 [3,4,3,1] = 0.0
 [3,4,3,2] = -0.0
 [3,4,3,3] = -0.0
 [3,5,:,:]
 [3,5,1,:]
 [3,5,1,1] = 0.0
 [3,5,1,2] = -0.0
 [3,5,1,3] = 0.0
 [3,5,2,:]
 [3,5,2,1] = 0.0
 [3,5,2,2] = -0.0
 [3,5,2,3] = -0.0
 [3,5,3,:]
 [3,5,3,1] = -0.0
 [3,5,3,2] = -0.0
 [3,5,3,3] = -0.0
 [3,6,:,:]
 [3,6,1,:]
 [3,6,1,1] = -0.0
 [3,6,1,2] = -0.0
 [3,6,1,3] = -0.0
 [3,6,2,:]
 [3,6,2,1] = -0.0
 [3,6,2,2] = -0.0
 [3,6,2,3] = -0.0
 [3,6,3,:]
 [3,6,3,1] = -0.0
 [3,6,3,2] = -0.0
 [3,6,3,3] = -0.0
[4,:,:,:]
 [4,1,:,:]
 [4,1,1,:]
 [4,1,1,1] = -0.0
 [4,1,1,2] = 0.0
 [4,1,1,3] = 0.0
 [4,1,2,:]
 [4,1,2,1] = -0.0
 [4,1,2,2] = 0.0
 [4,1,2,3] = -0.0
 [4,1,3,:]
 [4,1,3,1] = -0.0
 [4,1,3,2] = -0.0
 [4,1,3,3] = -0.0
 [4,2,:,:]
 [4,2,1,:]
 [4,2,1,1] = -0.0
 [4,2,1,2] = -0.0
 [4,2,1,3] = -0.0
 [4,2,2,:]
 [4,2,2,1] = -0.0
 [4,2,2,2] = -0.0
 [4,2,2,3] = 0.0
 [4,2,3,:]
 [4,2,3,1] = -0.0
 [4,2,3,2] = 0.0
 [4,2,3,3] = -0.0
 [4,3,:,:]
 [4,3,1,:]
 [4,3,1,1] = 0.0
 [4,3,1,2] = 0.0
 [4,3,1,3] = -0.0
 [4,3,2,:]
 [4,3,2,1] = 0.0
 [4,3,2,2] = 0.0
 [4,3,2,3] = 1.0
 [4,3,3,:]
 [4,3,3,1] = 1.0
 [4,3,3,2] = 0.9999999999999996
 [4,3,3,3] = 0.0
 [4,4,:,:]
 [4,4,1,:]
 [4,4,1,1] = 0.0
 [4,4,1,2] = 0.0
 [4,4,1,3] = 0.0
 [4,4,2,:]
 [4,4,2,1] = 0.0
 [4,4,2,2] = 0.0
 [4,4,2,3] = 0.0
 [4,4,3,:]
 [4,4,3,1] = 0.0
 [4,4,3,2] = 0.0
 [4,4,3,3] = 0.0
 [4,5,:,:]
 [4,5,1,:]
 [4,5,1,1] = -0.0
 [4,5,1,2] = -0.0
 [4,5,1,3] = 0.0
 [4,5,2,:]
 [4,5,2,1] = 0.0
 [4,5,2,2] = 0.0
 [4,5,2,3] = -0.0
 [4,5,3,:]
 [4,5,3,1] = -0.0
 [4,5,3,2] = -0.0
 [4,5,3,3] = 0.0
 [4,6,:,:]
 [4,6,1,:]
 [4,6,1,1] = -0.0
 [4,6,1,2] = -0.0
 [4,6,1,3] = -0.0
 [4,6,2,:]
 [4,6,2,1] = -0.0
 [4,6,2,2] = -0.0
 [4,6,2,3] = -0.0
 [4,6,3,:]
 [4,6,3,1] = -0.0
 [4,6,3,2] = -0.0
 [4,6,3,3] = -0.0
[5,:,:,:]
 [5,1,:,:]
 [5,1,1,:]
 [5,1,1,1] = -0.0
 [5,1,1,2] = 0.0
 [5,1,1,3] = 0.0
 [5,1,2,:]
 [5,1,2,1] = -0.0
 [5,1,2,2] = 0.0
 [5,1,2,3] = -0.0
 [5,1,3,:]
 [5,1,3,1] = 0.0
 [5,1,3,2] = 0.0
 [5,1,3,3] = -0.0
 [5,2,:,:]
 [5,2,1,:]
 [5,2,1,1] = 0.0
 [5,2,1,2] = -0.0
 [5,2,1,3] = -0.0
 [5,2,2,:]
 [5,2,2,1] = -0.0
 [5,2,2,2] = -0.0
 [5,2,2,3] = 0.0
 [5,2,3,:]
 [5,2,3,1] = 0.0
 [5,2,3,2] = 0.0
 [5,2,3,3] = -0.0
 [5,3,:,:]
 [5,3,1,:]
 [5,3,1,1] = 0.0
 [5,3,1,2] = -0.0
 [5,3,1,3] = 0.0
 [5,3,2,:]
 [5,3,2,1] = 0.0
 [5,3,2,2] = -0.0
 [5,3,2,3] = 0.0
 [5,3,3,:]
 [5,3,3,1] = 0.0
 [5,3,3,2] = -0.0
 [5,3,3,3] = -0.0
 [5,4,:,:]
 [5,4,1,:]
 [5,4,1,1] = 0.0
 [5,4,1,2] = 0.0
 [5,4,1,3] = 0.0
 [5,4,2,:]
 [5,4,2,1] = 0.0
 [5,4,2,2] = -0.0
 [5,4,2,3] = 1.0
 [5,4,3,:]
 [5,4,3,1] = 1.0
 [5,4,3,2] = 0.9999999999999996
 [5,4,3,3] = 0.0
 [5,5,:,:]
 [5,5,1,:]
 [5,5,1,1] = 0.0
 [5,5,1,2] = 0.0
 [5,5,1,3] = 0.0
 [5,5,2,:]
 [5,5,2,1] = 0.0
 [5,5,2,2] = 0.0
 [5,5,2,3] = 0.0
 [5,5,3,:]
 [5,5,3,1] = 0.0
 [5,5,3,2] = 0.0
 [5,5,3,3] = 0.0
 [5,6,:,:]
 [5,6,1,:]
 [5,6,1,1] = -0.0
 [5,6,1,2] = -0.0
 [5,6,1,3] = 0.0
 [5,6,2,:]
 [5,6,2,1] = 0.0
 [5,6,2,2] = 0.0
 [5,6,2,3] = -0.0
 [5,6,3,:]
 [5,6,3,1] = 0.0
 [5,6,3,2] = -0.0
 [5,6,3,3] = -0.0
[6,:,:,:]
 [6,1,:,:]
 [6,1,1,:]
 [6,1,1,1] = -0.0
 [6,1,1,2] = 0.0
 [6,1,1,3] = -0.0
 [6,1,2,:]
 [6,1,2,1] = -0.0
 [6,1,2,2] = -0.0
 [6,1,2,3] = -0.0
 [6,1,3,:]
 [6,1,3,1] = -0.0
 [6,1,3,2] = -0.0
 [6,1,3,3] = -0.0
 [6,2,:,:]
 [6,2,1,:]
 [6,2,1,1] = -0.0
 [6,2,1,2] = -0.0
 [6,2,1,3] = -0.0
 [6,2,2,:]
 [6,2,2,1] = -0.0
 [6,2,2,2] = -0.0
 [6,2,2,3] = 0.0
 [6,2,3,:]
 [6,2,3,1] = -0.0
 [6,2,3,2] = -0.0
 [6,2,3,3] = -0.0
 [6,3,:,:]
 [6,3,1,:]
 [6,3,1,1] = -0.0
 [6,3,1,2] = -0.0
 [6,3,1,3] = -0.0
 [6,3,2,:]
 [6,3,2,1] = -0.0
 [6,3,2,2] = -0.0
 [6,3,2,3] = -0.0
 [6,3,3,:]
 [6,3,3,1] = -0.0
 [6,3,3,2] = -0.0
 [6,3,3,3] = -0.0
 [6,4,:,:]
 [6,4,1,:]
 [6,4,1,1] = -0.0
 [6,4,1,2] = -0.0
 [6,4,1,3] = -0.0
 [6,4,2,:]
 [6,4,2,1] = -0.0
 [6,4,2,2] = -0.0
 [6,4,2,3] = -0.0
 [6,4,3,:]
 [6,4,3,1] = -0.0
 [6,4,3,2] = 0.0
 [6,4,3,3] = -0.0
 [6,5,:,:]
 [6,5,1,:]
 [6,5,1,1] = 0.0
 [6,5,1,2] = 0.0
 [6,5,1,3] = -0.0
 [6,5,2,:]
 [6,5,2,1] = -0.0
 [6,5,2,2] = -0.0
 [6,5,2,3] = 1.0
 [6,5,3,:]
 [6,5,3,1] = 1.0
 [6,5,3,2] = 0.9999999999999996
 [6,5,3,3] = 0.0
 [6,6,:,:]
 [6,6,1,:]
 [6,6,1,1] = 0.0
 [6,6,1,2] = 0.0
 [6,6,1,3] = 0.0
 [6,6,2,:]
 [6,6,2,1] = 0.0
 [6,6,2,2] = 0.0
 [6,6,2,3] = 0.0
 [6,6,3,:]
 [6,6,3,1] = 0.0
 [6,6,3,2] = 0.0
 [6,6,3,3] = 0


.0`






multidimensional-array julia







share|improve this question
















I have a multiple dimensional matrix in my result for example x[i,j,k,t]. how can I export it from Julia in excel?
for example I have this matrix in Julia. I coded a location inventory vehicle routing model in Julia. that is the optimum routing matrix. I want to export it in excel. please help me. 



`xx
x: 4 dimensions:
[1,:,:,:]
 [1,1,:,:]
 [1,1,1,:]
 [1,1,1,1] = 0.0
 [1,1,1,2] = 0.0
 [1,1,1,3] = 0.0
 [1,1,2,:]
 [1,1,2,1] = 0.0
 [1,1,2,2] = 0.0
 [1,1,2,3] = 0.0
 [1,1,3,:]
 [1,1,3,1] = 0.0
 [1,1,3,2] = 0.0
 [1,1,3,3] = 0.0
 [1,2,:,:]
 [1,2,1,:]
 [1,2,1,1] = -0.0
 [1,2,1,2] = 0.0
 [1,2,1,3] = 0.0
 [1,2,2,:]
 [1,2,2,1] = 0.0
 [1,2,2,2] = 0.0
 [1,2,2,3] = 0.0
 [1,2,3,:]
 [1,2,3,1] = 0.0
 [1,2,3,2] = 0.0
 [1,2,3,3] = 0.0
 [1,3,:,:]
 [1,3,1,:]
 [1,3,1,1] = -0.0
 [1,3,1,2] = 0.0
 [1,3,1,3] = 0.0
 [1,3,2,:]
 [1,3,2,1] = 0.0
 [1,3,2,2] = 0.0
 [1,3,2,3] = -0.0
 [1,3,3,:]
 [1,3,3,1] = 0.0
 [1,3,3,2] = 0.0
 [1,3,3,3] = 0.0
 [1,4,:,:]
 [1,4,1,:]
 [1,4,1,1] = -0.0
 [1,4,1,2] = -0.0
 [1,4,1,3] = -0.0
 [1,4,2,:]
 [1,4,2,1] = -0.0
 [1,4,2,2] = -0.0
 [1,4,2,3] = -0.0
 [1,4,3,:]
 [1,4,3,1] = 0.0
 [1,4,3,2] = 0.0
 [1,4,3,3] = 0.0
 [1,5,:,:]
 [1,5,1,:]
 [1,5,1,1] = -0.0
 [1,5,1,2] = -0.0
 [1,5,1,3] = -0.0
 [1,5,2,:]
 [1,5,2,1] = -0.0
 [1,5,2,2] = -0.0
 [1,5,2,3] = 0.0
 [1,5,3,:]
 [1,5,3,1] = -0.0
 [1,5,3,2] = 0.0
 [1,5,3,3] = 0.0
 [1,6,:,:]
 [1,6,1,:]
 [1,6,1,1] = -0.0
 [1,6,1,2] = -0.0
 [1,6,1,3] = -0.0
 [1,6,2,:]
 [1,6,2,1] = -0.0
 [1,6,2,2] = -0.0
 [1,6,2,3] = 1.0
 [1,6,3,:]
 [1,6,3,1] = 1.0
 [1,6,3,2] = 1.0
 [1,6,3,3] = -0.0
[2,:,:,:]
 [2,1,:,:]
 [2,1,1,:]
 [2,1,1,1] = 0.0
 [2,1,1,2] = 0.0
 [2,1,1,3] = 0.0
 [2,1,2,:]
 [2,1,2,1] = 0.0
 [2,1,2,2] = 0.0
 [2,1,2,3] = 1.0
 [2,1,3,:]
 [2,1,3,1] = 1.0
 [2,1,3,2] = 1.0
 [2,1,3,3] = 0.0
 [2,2,:,:]
 [2,2,1,:]
 [2,2,1,1] = 0.0
 [2,2,1,2] = 0.0
 [2,2,1,3] = 0.0
 [2,2,2,:]
 [2,2,2,1] = 0.0
 [2,2,2,2] = 0.0
 [2,2,2,3] = 0.0
 [2,2,3,:]
 [2,2,3,1] = 0.0
 [2,2,3,2] = 0.0
 [2,2,3,3] = 0.0
 [2,3,:,:]
 [2,3,1,:]
 [2,3,1,1] = 0.0
 [2,3,1,2] = 0.0
 [2,3,1,3] = -0.0
 [2,3,2,:]
 [2,3,2,1] = 0.0
 [2,3,2,2] = 0.0
 [2,3,2,3] = 0.0
 [2,3,3,:]
 [2,3,3,1] = 0.0
 [2,3,3,2] = 0.0
 [2,3,3,3] = 0.0
 [2,4,:,:]
 [2,4,1,:]
 [2,4,1,1] = -0.0
 [2,4,1,2] = -0.0
 [2,4,1,3] = -0.0
 [2,4,2,:]
 [2,4,2,1] = -0.0
 [2,4,2,2] = -0.0
 [2,4,2,3] = -0.0
 [2,4,3,:]
 [2,4,3,1] = 0.0
 [2,4,3,2] = -0.0
 [2,4,3,3] = -0.0
 [2,5,:,:]
 [2,5,1,:]
 [2,5,1,1] = 0.0
 [2,5,1,2] = -0.0
 [2,5,1,3] = -0.0
 [2,5,2,:]
 [2,5,2,1] = 0.0
 [2,5,2,2] = -0.0
 [2,5,2,3] = -0.0
 [2,5,3,:]
 [2,5,3,1] = 0.0
 [2,5,3,2] = -0.0
 [2,5,3,3] = -0.0
 [2,6,:,:]
 [2,6,1,:]
 [2,6,1,1] = -0.0
 [2,6,1,2] = -0.0
 [2,6,1,3] = -0.0
 [2,6,2,:]
 [2,6,2,1] = -0.0
 [2,6,2,2] = -0.0
 [2,6,2,3] = -0.0
 [2,6,3,:]
 [2,6,3,1] = -0.0
 [2,6,3,2] = -0.0
 [2,6,3,3] = -0.0
[3,:,:,:]
 [3,1,:,:]
 [3,1,1,:]
 [3,1,1,1] = 0.0
 [3,1,1,2] = 0.0
 [3,1,1,3] = 0.0
 [3,1,2,:]
 [3,1,2,1] = -0.0
 [3,1,2,2] = 0.0
 [3,1,2,3] = 0.0
 [3,1,3,:]
 [3,1,3,1] = -0.0
 [3,1,3,2] = -0.0
 [3,1,3,3] = 0.0
 [3,2,:,:]
 [3,2,1,:]
 [3,2,1,1] = 0.0
 [3,2,1,2] = -0.0
 [3,2,1,3] = 0.0
 [3,2,2,:]
 [3,2,2,1] = 0.0
 [3,2,2,2] = -0.0
 [3,2,2,3] = 1.0
 [3,2,3,:]
 [3,2,3,1] = 1.0
 [3,2,3,2] = 0.9999999999999996
 [3,2,3,3] = 0.0
 [3,3,:,:]
 [3,3,1,:]
 [3,3,1,1] = 0.0
 [3,3,1,2] = 0.0
 [3,3,1,3] = 0.0
 [3,3,2,:]
 [3,3,2,1] = 0.0
 [3,3,2,2] = 0.0
 [3,3,2,3] = 0.0
 [3,3,3,:]
 [3,3,3,1] = 0.0
 [3,3,3,2] = 0.0
 [3,3,3,3] = 0.0
 [3,4,:,:]
 [3,4,1,:]
 [3,4,1,1] = 0.0
 [3,4,1,2] = -0.0
 [3,4,1,3] = -0.0
 [3,4,2,:]
 [3,4,2,1] = -0.0
 [3,4,2,2] = -0.0
 [3,4,2,3] = 0.0
 [3,4,3,:]
 [3,4,3,1] = 0.0
 [3,4,3,2] = -0.0
 [3,4,3,3] = -0.0
 [3,5,:,:]
 [3,5,1,:]
 [3,5,1,1] = 0.0
 [3,5,1,2] = -0.0
 [3,5,1,3] = 0.0
 [3,5,2,:]
 [3,5,2,1] = 0.0
 [3,5,2,2] = -0.0
 [3,5,2,3] = -0.0
 [3,5,3,:]
 [3,5,3,1] = -0.0
 [3,5,3,2] = -0.0
 [3,5,3,3] = -0.0
 [3,6,:,:]
 [3,6,1,:]
 [3,6,1,1] = -0.0
 [3,6,1,2] = -0.0
 [3,6,1,3] = -0.0
 [3,6,2,:]
 [3,6,2,1] = -0.0
 [3,6,2,2] = -0.0
 [3,6,2,3] = -0.0
 [3,6,3,:]
 [3,6,3,1] = -0.0
 [3,6,3,2] = -0.0
 [3,6,3,3] = -0.0
[4,:,:,:]
 [4,1,:,:]
 [4,1,1,:]
 [4,1,1,1] = -0.0
 [4,1,1,2] = 0.0
 [4,1,1,3] = 0.0
 [4,1,2,:]
 [4,1,2,1] = -0.0
 [4,1,2,2] = 0.0
 [4,1,2,3] = -0.0
 [4,1,3,:]
 [4,1,3,1] = -0.0
 [4,1,3,2] = -0.0
 [4,1,3,3] = -0.0
 [4,2,:,:]
 [4,2,1,:]
 [4,2,1,1] = -0.0
 [4,2,1,2] = -0.0
 [4,2,1,3] = -0.0
 [4,2,2,:]
 [4,2,2,1] = -0.0
 [4,2,2,2] = -0.0
 [4,2,2,3] = 0.0
 [4,2,3,:]
 [4,2,3,1] = -0.0
 [4,2,3,2] = 0.0
 [4,2,3,3] = -0.0
 [4,3,:,:]
 [4,3,1,:]
 [4,3,1,1] = 0.0
 [4,3,1,2] = 0.0
 [4,3,1,3] = -0.0
 [4,3,2,:]
 [4,3,2,1] = 0.0
 [4,3,2,2] = 0.0
 [4,3,2,3] = 1.0
 [4,3,3,:]
 [4,3,3,1] = 1.0
 [4,3,3,2] = 0.9999999999999996
 [4,3,3,3] = 0.0
 [4,4,:,:]
 [4,4,1,:]
 [4,4,1,1] = 0.0
 [4,4,1,2] = 0.0
 [4,4,1,3] = 0.0
 [4,4,2,:]
 [4,4,2,1] = 0.0
 [4,4,2,2] = 0.0
 [4,4,2,3] = 0.0
 [4,4,3,:]
 [4,4,3,1] = 0.0
 [4,4,3,2] = 0.0
 [4,4,3,3] = 0.0
 [4,5,:,:]
 [4,5,1,:]
 [4,5,1,1] = -0.0
 [4,5,1,2] = -0.0
 [4,5,1,3] = 0.0
 [4,5,2,:]
 [4,5,2,1] = 0.0
 [4,5,2,2] = 0.0
 [4,5,2,3] = -0.0
 [4,5,3,:]
 [4,5,3,1] = -0.0
 [4,5,3,2] = -0.0
 [4,5,3,3] = 0.0
 [4,6,:,:]
 [4,6,1,:]
 [4,6,1,1] = -0.0
 [4,6,1,2] = -0.0
 [4,6,1,3] = -0.0
 [4,6,2,:]
 [4,6,2,1] = -0.0
 [4,6,2,2] = -0.0
 [4,6,2,3] = -0.0
 [4,6,3,:]
 [4,6,3,1] = -0.0
 [4,6,3,2] = -0.0
 [4,6,3,3] = -0.0
[5,:,:,:]
 [5,1,:,:]
 [5,1,1,:]
 [5,1,1,1] = -0.0
 [5,1,1,2] = 0.0
 [5,1,1,3] = 0.0
 [5,1,2,:]
 [5,1,2,1] = -0.0
 [5,1,2,2] = 0.0
 [5,1,2,3] = -0.0
 [5,1,3,:]
 [5,1,3,1] = 0.0
 [5,1,3,2] = 0.0
 [5,1,3,3] = -0.0
 [5,2,:,:]
 [5,2,1,:]
 [5,2,1,1] = 0.0
 [5,2,1,2] = -0.0
 [5,2,1,3] = -0.0
 [5,2,2,:]
 [5,2,2,1] = -0.0
 [5,2,2,2] = -0.0
 [5,2,2,3] = 0.0
 [5,2,3,:]
 [5,2,3,1] = 0.0
 [5,2,3,2] = 0.0
 [5,2,3,3] = -0.0
 [5,3,:,:]
 [5,3,1,:]
 [5,3,1,1] = 0.0
 [5,3,1,2] = -0.0
 [5,3,1,3] = 0.0
 [5,3,2,:]
 [5,3,2,1] = 0.0
 [5,3,2,2] = -0.0
 [5,3,2,3] = 0.0
 [5,3,3,:]
 [5,3,3,1] = 0.0
 [5,3,3,2] = -0.0
 [5,3,3,3] = -0.0
 [5,4,:,:]
 [5,4,1,:]
 [5,4,1,1] = 0.0
 [5,4,1,2] = 0.0
 [5,4,1,3] = 0.0
 [5,4,2,:]
 [5,4,2,1] = 0.0
 [5,4,2,2] = -0.0
 [5,4,2,3] = 1.0
 [5,4,3,:]
 [5,4,3,1] = 1.0
 [5,4,3,2] = 0.9999999999999996
 [5,4,3,3] = 0.0
 [5,5,:,:]
 [5,5,1,:]
 [5,5,1,1] = 0.0
 [5,5,1,2] = 0.0
 [5,5,1,3] = 0.0
 [5,5,2,:]
 [5,5,2,1] = 0.0
 [5,5,2,2] = 0.0
 [5,5,2,3] = 0.0
 [5,5,3,:]
 [5,5,3,1] = 0.0
 [5,5,3,2] = 0.0
 [5,5,3,3] = 0.0
 [5,6,:,:]
 [5,6,1,:]
 [5,6,1,1] = -0.0
 [5,6,1,2] = -0.0
 [5,6,1,3] = 0.0
 [5,6,2,:]
 [5,6,2,1] = 0.0
 [5,6,2,2] = 0.0
 [5,6,2,3] = -0.0
 [5,6,3,:]
 [5,6,3,1] = 0.0
 [5,6,3,2] = -0.0
 [5,6,3,3] = -0.0
[6,:,:,:]
 [6,1,:,:]
 [6,1,1,:]
 [6,1,1,1] = -0.0
 [6,1,1,2] = 0.0
 [6,1,1,3] = -0.0
 [6,1,2,:]
 [6,1,2,1] = -0.0
 [6,1,2,2] = -0.0
 [6,1,2,3] = -0.0
 [6,1,3,:]
 [6,1,3,1] = -0.0
 [6,1,3,2] = -0.0
 [6,1,3,3] = -0.0
 [6,2,:,:]
 [6,2,1,:]
 [6,2,1,1] = -0.0
 [6,2,1,2] = -0.0
 [6,2,1,3] = -0.0
 [6,2,2,:]
 [6,2,2,1] = -0.0
 [6,2,2,2] = -0.0
 [6,2,2,3] = 0.0
 [6,2,3,:]
 [6,2,3,1] = -0.0
 [6,2,3,2] = -0.0
 [6,2,3,3] = -0.0
 [6,3,:,:]
 [6,3,1,:]
 [6,3,1,1] = -0.0
 [6,3,1,2] = -0.0
 [6,3,1,3] = -0.0
 [6,3,2,:]
 [6,3,2,1] = -0.0
 [6,3,2,2] = -0.0
 [6,3,2,3] = -0.0
 [6,3,3,:]
 [6,3,3,1] = -0.0
 [6,3,3,2] = -0.0
 [6,3,3,3] = -0.0
 [6,4,:,:]
 [6,4,1,:]
 [6,4,1,1] = -0.0
 [6,4,1,2] = -0.0
 [6,4,1,3] = -0.0
 [6,4,2,:]
 [6,4,2,1] = -0.0
 [6,4,2,2] = -0.0
 [6,4,2,3] = -0.0
 [6,4,3,:]
 [6,4,3,1] = -0.0
 [6,4,3,2] = 0.0
 [6,4,3,3] = -0.0
 [6,5,:,:]
 [6,5,1,:]
 [6,5,1,1] = 0.0
 [6,5,1,2] = 0.0
 [6,5,1,3] = -0.0
 [6,5,2,:]
 [6,5,2,1] = -0.0
 [6,5,2,2] = -0.0
 [6,5,2,3] = 1.0
 [6,5,3,:]
 [6,5,3,1] = 1.0
 [6,5,3,2] = 0.9999999999999996
 [6,5,3,3] = 0.0
 [6,6,:,:]
 [6,6,1,:]
 [6,6,1,1] = 0.0
 [6,6,1,2] = 0.0
 [6,6,1,3] = 0.0
 [6,6,2,:]
 [6,6,2,1] = 0.0
 [6,6,2,2] = 0.0
 [6,6,2,3] = 0.0
 [6,6,3,:]
 [6,6,3,1] = 0.0
 [6,6,3,2] = 0.0
 [6,6,3,3] = 0


.0`






multidimensional-array julia




multidimensional-array julia






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 28 at 15:20







Soma

















asked Mar 27 at 18:19









SomaSoma

1779 bronze badges




1779 bronze badges










  • 1





    Can you please specify how you want the data to look like in Excel?

    – Bogumił Kamiński
    Mar 27 at 18:34











  • xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

    – Soma
    Mar 28 at 13:40






  • 5





    Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

    – E_net4
    Mar 28 at 14:19












  • 1





    Can you please specify how you want the data to look like in Excel?

    – Bogumił Kamiński
    Mar 27 at 18:34











  • xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

    – Soma
    Mar 28 at 13:40






  • 5





    Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

    – E_net4
    Mar 28 at 14:19







1




1





Can you please specify how you want the data to look like in Excel?

– Bogumił Kamiński
Mar 27 at 18:34





Can you please specify how you want the data to look like in Excel?

– Bogumił Kamiński
Mar 27 at 18:34













xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

– Soma
Mar 28 at 13:40





xx x: 4 dimensions: [1,:,:,:] [1,1,:,:] [1,1,1,:] [1,1,1,1] = 0.0 [1,1,1,2] = 0.0 [1,1,1,3] = 0.0 [1,1,2,:] [1,1,2,1] = 0.0 [1,1,2,2] = 0.0 [1,1,2,3] = 0.0 I have this matrix in my code that i=1...6, j=1...6, k=1...3, t=1...3

– Soma
Mar 28 at 13:40




5




5





Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

– E_net4
Mar 28 at 14:19





Please edit your post to include any additional information you have to your question. Avoid adding this in the comments.

– E_net4
Mar 28 at 14:19












1 Answer
1






active

oldest

votes


















0
















You can write it to a .csv file which will be easily imported in an Excel sheet.
Working code for Julia 1.1.0 and JuMP 0.19.0



 x = [0.0 for _ in 1:6, _ in 1:6, _ in 1:3, _ in 1:3]

 using CSV
 using DataFrames

 function arr_to_csv(x, outputstring)
 df = DataFrame(i = Int[], j = Int[], k = Int[], t = Int[], x = Float64[])
 sizes = size(x)

 for i in 1:sizes[1]
 for j in 1:sizes[2]
 for k in 1:sizes[3]
 for t in 1:sizes[4]
 push!(df, (i, j, k, t, x[i,j,k,t]))
 end
 end
 end
 end
 df |> CSV.write(outputstring, header = ["i", "j", "k", "t", "value"])
 end

 arr_to_csv(x, "./4dim-x.csv")


Replace x with your matrix






share|improve this answer



























  • It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

    – Soma
    Apr 6 at 5:44












  • @SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

    – JKHA
    Apr 6 at 9:31











  • it is Julia 0.6.4.1. Thanks for your kindly help.

    – Soma
    Apr 6 at 11:13












  • ,I cant use excel for my results in this version? should I update the Julia? Thanks

    – Soma
    Apr 12 at 9:52












  • It might be a good idea to upgrade Julia ^^

    – JKHA
    Apr 12 at 21:58










Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);














draft saved

draft discarded
















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55384080%2fhow-can-i-export-multidimensional-matrix-from-julia-in-excel%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0
















You can write it to a .csv file which will be easily imported in an Excel sheet.
Working code for Julia 1.1.0 and JuMP 0.19.0



 x = [0.0 for _ in 1:6, _ in 1:6, _ in 1:3, _ in 1:3]

 using CSV
 using DataFrames

 function arr_to_csv(x, outputstring)
 df = DataFrame(i = Int[], j = Int[], k = Int[], t = Int[], x = Float64[])
 sizes = size(x)

 for i in 1:sizes[1]
 for j in 1:sizes[2]
 for k in 1:sizes[3]
 for t in 1:sizes[4]
 push!(df, (i, j, k, t, x[i,j,k,t]))
 end
 end
 end
 end
 df |> CSV.write(outputstring, header = ["i", "j", "k", "t", "value"])
 end

 arr_to_csv(x, "./4dim-x.csv")


Replace x with your matrix






share|improve this answer



























  • It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

    – Soma
    Apr 6 at 5:44












  • @SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

    – JKHA
    Apr 6 at 9:31











  • it is Julia 0.6.4.1. Thanks for your kindly help.

    – Soma
    Apr 6 at 11:13












  • ,I cant use excel for my results in this version? should I update the Julia? Thanks

    – Soma
    Apr 12 at 9:52












  • It might be a good idea to upgrade Julia ^^

    – JKHA
    Apr 12 at 21:58















0
















You can write it to a .csv file which will be easily imported in an Excel sheet.
Working code for Julia 1.1.0 and JuMP 0.19.0



 x = [0.0 for _ in 1:6, _ in 1:6, _ in 1:3, _ in 1:3]

 using CSV
 using DataFrames

 function arr_to_csv(x, outputstring)
 df = DataFrame(i = Int[], j = Int[], k = Int[], t = Int[], x = Float64[])
 sizes = size(x)

 for i in 1:sizes[1]
 for j in 1:sizes[2]
 for k in 1:sizes[3]
 for t in 1:sizes[4]
 push!(df, (i, j, k, t, x[i,j,k,t]))
 end
 end
 end
 end
 df |> CSV.write(outputstring, header = ["i", "j", "k", "t", "value"])
 end

 arr_to_csv(x, "./4dim-x.csv")


Replace x with your matrix






share|improve this answer



























  • It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

    – Soma
    Apr 6 at 5:44












  • @SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

    – JKHA
    Apr 6 at 9:31











  • it is Julia 0.6.4.1. Thanks for your kindly help.

    – Soma
    Apr 6 at 11:13












  • ,I cant use excel for my results in this version? should I update the Julia? Thanks

    – Soma
    Apr 12 at 9:52












  • It might be a good idea to upgrade Julia ^^

    – JKHA
    Apr 12 at 21:58













0














0










0









You can write it to a .csv file which will be easily imported in an Excel sheet.
Working code for Julia 1.1.0 and JuMP 0.19.0



 x = [0.0 for _ in 1:6, _ in 1:6, _ in 1:3, _ in 1:3]

 using CSV
 using DataFrames

 function arr_to_csv(x, outputstring)
 df = DataFrame(i = Int[], j = Int[], k = Int[], t = Int[], x = Float64[])
 sizes = size(x)

 for i in 1:sizes[1]
 for j in 1:sizes[2]
 for k in 1:sizes[3]
 for t in 1:sizes[4]
 push!(df, (i, j, k, t, x[i,j,k,t]))
 end
 end
 end
 end
 df |> CSV.write(outputstring, header = ["i", "j", "k", "t", "value"])
 end

 arr_to_csv(x, "./4dim-x.csv")


Replace x with your matrix






share|improve this answer















You can write it to a .csv file which will be easily imported in an Excel sheet.
Working code for Julia 1.1.0 and JuMP 0.19.0



 x = [0.0 for _ in 1:6, _ in 1:6, _ in 1:3, _ in 1:3]

 using CSV
 using DataFrames

 function arr_to_csv(x, outputstring)
 df = DataFrame(i = Int[], j = Int[], k = Int[], t = Int[], x = Float64[])
 sizes = size(x)

 for i in 1:sizes[1]
 for j in 1:sizes[2]
 for k in 1:sizes[3]
 for t in 1:sizes[4]
 push!(df, (i, j, k, t, x[i,j,k,t]))
 end
 end
 end
 end
 df |> CSV.write(outputstring, header = ["i", "j", "k", "t", "value"])
 end

 arr_to_csv(x, "./4dim-x.csv")


Replace x with your matrix







share|improve this answer














share|improve this answer



share|improve this answer








edited Apr 6 at 9:32

























answered Mar 28 at 14:33









JKHAJKHA

4742 silver badges15 bronze badges




4742 silver badges15 bronze badges















  • It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

    – Soma
    Apr 6 at 5:44












  • @SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

    – JKHA
    Apr 6 at 9:31











  • it is Julia 0.6.4.1. Thanks for your kindly help.

    – Soma
    Apr 6 at 11:13












  • ,I cant use excel for my results in this version? should I update the Julia? Thanks

    – Soma
    Apr 12 at 9:52












  • It might be a good idea to upgrade Julia ^^

    – JKHA
    Apr 12 at 21:58

















  • It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

    – Soma
    Apr 6 at 5:44












  • @SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

    – JKHA
    Apr 6 at 9:31











  • it is Julia 0.6.4.1. Thanks for your kindly help.

    – Soma
    Apr 6 at 11:13












  • ,I cant use excel for my results in this version? should I update the Julia? Thanks

    – Soma
    Apr 12 at 9:52












  • It might be a good idea to upgrade Julia ^^

    – JKHA
    Apr 12 at 21:58
















It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

– Soma
Apr 6 at 5:44






It has this error, arr_to_csv(xx, "./4dim-x.csv") ERROR: size (and "end" syntax) not implemented for JuMPArray objects.Use JuMP.size if you want to ac cess the dimensions. Stacktrace: [1] arr_to_csv(::JuMP.JuMPArrayFloat64,4,NTuple4,UnitRangeInt64, ::String) at C:Usersadmin Desktopmodelwithtriangle97.12.25mainnnmodel.juliarc.jl:119 [2] macro expansion at C:UsersadminAppDataLocalJuliaPro-0.6.4.1pkgs-0.6.4.1v0.6Atomsrcrep l.jl:118 [inlined] [3] anonymous at .<missing>:? it seems, the error is for size function

– Soma
Apr 6 at 5:44














@SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

– JKHA
Apr 6 at 9:31





@SomayehEsmaeili This is working on Julia 1.1.0 and JuMP 0.19.0. It might be possible this isn't working for you because you're on a different version. Can you please tell me what are your Julia and JuMP versions ?

– JKHA
Apr 6 at 9:31













it is Julia 0.6.4.1. Thanks for your kindly help.

– Soma
Apr 6 at 11:13






it is Julia 0.6.4.1. Thanks for your kindly help.

– Soma
Apr 6 at 11:13














,I cant use excel for my results in this version? should I update the Julia? Thanks

– Soma
Apr 12 at 9:52






,I cant use excel for my results in this version? should I update the Julia? Thanks

– Soma
Apr 12 at 9:52














It might be a good idea to upgrade Julia ^^

– JKHA
Apr 12 at 21:58





It might be a good idea to upgrade Julia ^^

– JKHA
Apr 12 at 21:58






Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.




















draft saved

draft discarded















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55384080%2fhow-can-i-export-multidimensional-matrix-from-julia-in-excel%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

Image
Pages using ISBN magic linksMbegu za lughaKamusiIsimu nenoKiarabukitabulughaKiswahilialfabetimaanaufafanuzimanenomuhtasarisarufividahizoalfabeti Kamusi Kutoka Wikipedia, kamusi elezo huru Jump to navigation Jump to search Kamusi za Kiswahili Kamusi ya Kiswahili-Kiswahili (kamusi wahidiya) Kamusi ya Kiswahili - Kiingereza (kamusi thania) Kamusi (kutoka neno la Kiarabu قاموس qamus ) ni kitabu ambacho kinaorodhesha maneno ya lugha yaliyokusanywa kutoka kwa watumiaji wa lugha fulani, kwa mfano lugha ya Kiswahili. Maneno hupangwa kwa mtindo wa alfabeti, hutoa maana, asili na ufafanuzi wa utumizi wa maneno na jinsi yanavyotumika au yanavyotamkwa. [1] Yaliyomo 1 Aina za kamusi 2 Muundo wa kamusi 2.1 1. Utangulizi wa kamusi 2.2 2. Matini ya kamusi 2.3 3. Sherehe ya kamusi 3 Faida za kamusi 4 Dhima ya picha katika kamusi 5 Marejeo 6 Tazama pia 7 Viungo vya nje Aina za kamusi | Kuna aina mbalimbali za kamusi ambazo n...
Read more

SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

Image
Does a multiclassed wizard start with a spellbook? Minimizing medical costs with HSA Boss has banned cycling to work because he thinks it's unsafe Is there a typical layout to blocking installed for backing in new construction framing? In the Seventh Seal why does Death let the chess game happen? Why has Novell never written its own boot loader? Should I warn my boss I might take sick leave Why is the saxophone not common in classical repertoire? Is it possible to spoof an IP address to an exact number? Motorcyle Chain needs to be cleaned every time you lube it? Bypass with wrong cvv of debit card and getting OTP Do we have a much compact and generalized version of erase–remove idiom? how can i make this execution plan more efficient? Why did moving the mouse cursor cause Windows 95 to run more quickly? What's the big deal about the Nazgûl losing their horses? Has chattel slavery ever been used as a criminal punishment in the USA since the passag...
Read more

은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현

Image
송씨은진 송씨충청남도 소재 성씨논산시 충청남도논산시은진면한국의 성씨고려송명의회덕 황씨류준고흥 류씨송유조선송준길문묘송시열좌의정문묘종묘송준길송규렴송상기송시열송인수송환기송치규송근수충청남도논산시은진면백제757년충청남도은진군논산군논산시은진면송유 은...
Read more