Good bives to all.
I'm trying to create a program that opens a file (it already does this) and reads each line in a loop to save it to an array.
The thing is that I know how to do it for a csv but I don't know how I could do it in an XLS file.
The XLS file has n lines so the loop would be until the last line or end of the file.
How could I do it?
Well, we don't know what your data looks like, so I've created a simple example, to see if it can serve your needs.
I have designed a simple table in Excel with data. My data starts in Cell A1 and ends in cell C32. Each cell, the only thing it contains is
Nº Fila || Nº Columna
.Well, I want to take all that data to an array (matrix). That is, I want to take all 32 lines.
And a screenshot of the data.
To get all that data into an Array, then I would use the following code.
I hope this answer can help you, or at least guide you and that you can apply it to your needs. I've also uploaded the file to my Google Drive in case you want to download it and check it out for yourself. https://drive.google.com/file/d/124YZqsIEkG5HGmfzM7lylFWUWVW465uS/view?usp=sharing