Get data from excel file

Don't hesitate to post if you have an improvement idea
Post Reply
berepe
Posts: 2
Joined: 27 Feb 2016, 06:36

Get data from excel file

Post 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
User avatar
Jmgr
Admin
Posts: 1649
Joined: 07 Dec 2005, 15:45
Contact:

Re: Get data from excel file

Post 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.
"My software never has bugs. It just develops random features."
alx0id
Posts: 2
Joined: 02 Apr 2016, 10:26

Re: Get data from excel file

Post 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 )
TinaNamdev
Posts: 2
Joined: 08 Dec 2018, 07:56

Re: Get data from excel file

Post by TinaNamdev »

I will have a look at this. Thanks.
Post Reply