I am working on company server where Python has been installed for us. Now I want process the excel files but I can not install any external packages like Pandas or Xlrd. So is there any way to achieve this?
-
2Is converting the Excel files to e.g. csv (feasibility depending on their content, of course) an option? Otherwise, if I'm not mistaken, xlsx is basically a zip file and the data is kept in an xml file inside of the archive. Both zip and xml can be processed natively by Python. But I don't think you're going to enjoy the process…– DocZerøCommented Mar 24, 2019 at 17:19
-
Well I have excel file which would be provided as input to Python script to process. If converting it to CSV was an option then it could be easily processed as normal text file but unfortunately its not.– adeshCommented Mar 24, 2019 at 17:23
-
1@adesh are you sure installing Python packages is not an option? If the only problem is that you can't install packages globally, then that's okay because you can install packages locally as well (without root/admin privileges).– SumitCommented Mar 24, 2019 at 17:29
-
@sumit could you throw some light on that? How can i install python packages locally?– adeshCommented Mar 24, 2019 at 17:54
-
@adesh use a virtual environment.– SumitCommented Mar 24, 2019 at 17:57
|
Show 3 more comments