After importing xlsx file, how to read the data according to the original matrix form?
Although it was imported, it was not presented in the matrix form of 24 * 3 in the original excel.
Although it was imported, it was not presented in the matrix form of 24 * 3 in the original excel.
Hi, please check the official XLSX.jl documentation. File reading returns and object containing all the sheets. You need to read whatever matrix you want from a particular sheet by specifying the cell range:
https://felipenoris.github.io/XLSX.jl/stable/tutorial/
PS: please avoid posting screenshots. A minimum code example is much more useful for other people who wish to help:
2 Likes