Hi, I'm trying to import a matrix from an Excel file. The imported matrix appears to transposed and in vector form.
Firstly, I created a test matrix and exported into an Excel file.
m = Table[i - j, {i, 5}, {j, 6}]
Export["mfile.xls", m, "XLS"]
Then tried to import the mfile.xls (created above)
mn = Import["mfile.xls", "XLS"] // MatrixForm
The output appears to be different from the original matrix.
a. How can I get rid of the vector form and transform the matrix?
b . How to get rid of the "." periods after each integer?
