Page 1 of 1

Get data from excel file

Posted: 27 Feb 2016, 06:54
by berepe
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

Re: Get data from excel file

Posted: 19 Mar 2016, 10:23
by Jmgr
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.

Re: Get data from excel file

Posted: 04 Apr 2016, 19:20
by alx0id
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 )

Re: Get data from excel file

Posted: 10 Dec 2018, 10:14
by TinaNamdev
I will have a look at this. Thanks.