would be great to have import data from excel ,
it would be similar to " read text file" function that I can chose the sheet name and cell coordinates
Thanks
Great job
Get data from excel file
Re: Get data from excel file
The xls file format is proprietary and cannot be read by other programs. As far as I know, the xlsx format may be more readable, but I'm not sure if there are libraries that allow reading/writing to these files without having to understand how it works (and its very complicated).
Good idea, I will have a look at this. Thanks.
Good idea, I will have a look at this. Thanks.
"My software never has bugs. It just develops random features."
Re: Get data from excel file
Xlsx is just zipped set of xml files. It is not so difficult to parse.. But if I get a task, I'd exported first xls to csv and then did what I need )
-
- Posts: 2
- Joined: 08 Dec 2018, 07:56
Re: Get data from excel file
I will have a look at this. Thanks.