Leave dates as strings using read_excel function from pandas in python

Python 2.7.10 Tried pandas 0.17.1 -- function read_excel Tried pyexcel 0.1.7 + pyexcel-xlsx 0.0.7 -- function get_records() When using pandas in Python is it possible to read excel files (formats:...

Python write dictionary into excel

I want to write a dictionary into an excel file. I always get some error messages, can someone explain me how to do? import sys import argparse import pyexcel import...

Pyexcel changing a cell value

So I was using openpyxl for all my Excel projects, but now I have to work with .xls files, so I was forced to change library. I've chosen pyexcel cuz it seemed to be fairly easy and well...

django: Unexpected data type exception trying to use django-excel

So I am trying to use django-excel: https://github.com/pyexcel/django-excel and just simply export a certain model into xls. I set up the settings according to the documentation, but I got this...

How to select all the rows with the same name and not only the first one?

This is the xls file : moto 5 2 45 moto 2 4 43 coche 8 54 12 coche 43 21 6 coche 22 14 18 And this is the code working with pyexcel library: import pyexcel as pe data =...

pyexcel export error "No content, file name. Nothing is given"

I'm using django-pyexcel to export data from the website, but when I go to the export URL I get the error: Exception Type: IOError Exception Value: No content, file name. Nothing is given The...

OSError: No suitable library found for xls

I've imported pyexcel as pe and am trying to run get_array, and iget_records, on an xls file and I'm getting a strange error, surrounding which I haven't found much documentation. Error: "OSError:...

Unable to use pyexcel-xls with pyinstaller . python executable not working . python version 3.4.4

The program works when run using: Python filename.py but when I create its executable file using "pyinstaller" pyinstaller -F filename.py the executable is successfully created, but execution...

pyexcel hook missing in pyinstaller (unable to load pyexcel)

I am using below code to convert .xls file to .xlsx. It works fine when I run it normally or in debug mode, but If I convert this to the executable file(.exe ) the below code is not working. I...

Why pyexcel throws exception "UnknownParameters: Please check if there were typos in function parameters"?

My Python 3.5 code looks like: folder_with_files = 'C:\\procXls\\20170809\\' path_to_m = folder_with_files + names[0] sheet_m = pe.get_sheet(file_name=path_to_m) #this is 72 line When i execute...

Improving python code for updating google spreadsheets

First of all, I am new to python (practically I have learned only from Sololearn, that too only up to half course). So I request you to give me a little bit detailed answer. My task has following...

Error trying to read blockede xls file on python

I am trying to open an Xls file on using python pandas ( also tried several others libraries like xlrd and pyexcel) and wasnt able to open it. when a try to used the comand df =...

error trying to read .xls file on python using pandas

I am trying to open an Xls file on using python pandas ( also tried several others libraries like xlrd and pyexcel) but wasnt able to open it. When a try to use the comand: df =...

PostgreSQL docker: "could not bind IPv6 socket: Cannot assign requested address"

EDIT 2: After a long time, solved! See answer below. EDIT: I am sorry to say that the the problems went away "on their own" between yesterday and today, without me having done anything. Great...

Python, CSV to XLS by merge_all_to_a_book

Simple lines to convert .csv files to .xls files. They work fine but for some files they don't. Seems like the problem lies in the file names. from pyexcel.cookbook import...

pyexcel.exceptions.UnknownParameters error after bundling with pyinstaller

I am trying to convert a python file to .exe using pyinstaller with the following command. Please suggest what is wrong with this approach. pyinstaller.exe --hidden-import pyexcel --hidden-import...

Issue uploading and processing xls in Heroku using Python Flask

I'm trying to upload xls in my application and then processing it in backend i.e.python flask, the below code works in ubuntu 14.04 but fails in Heroku with Attribute Error 'Request' object has no...

Unable to use pyexcel-xls with pyinstaller python version 3.6

when I create an exe file and try to run it here is an exception that I am getting: Exception in Tkinter callback Traceback (most recent call last): File "tkinter\__init__.py", line 1702, in...

Calling a method from a class in Python getting argument has unexpected type

I am trying to call "def getfile(self,text)" and every time it returns "argument 1 has unexpected type "str" How do I avoid that? Here is the code: from colorama import Fore, Back, Style import...

xlrd not working for 1997 - 2003 xls files :

I am trying to open a ".xls" file from an old version of Excel (1997-2003) to copy it in a .csv file. The url of the data is...

Pandas:XLDR error while reading an xls file from a url

i am getting an error while reading an xls file the error is as stated below **XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\x08jstanle'** i tried out various...

Unable to open Excel file using Pyexcel even after ininstalling pyexcel-xls and pyexcel-xlsx

I try to open a simple excel file with pyexcel, however I get the following error: SupportingPluginAvailableButNotInstalled: Please install one of these plugins for read data in 'xlsx':...

from django.utils import six Importerror: cannot import name six

I am working with Haystack 2.8.1 and django 3.0.1 and python 3.6 , getting that error. Solutions looking for, did not solve it for me.the crash is happening in a file i cannot edit...

My exe. file created from pyinstaller doesn't work like it does when it was .py (Pyexcel problem)

This is my first question I am using pyexcel in my python(3.7.4) script and it worked well. However after creating an exe file using Pyinstaller my exe file cannot run as it was .py Here is the...

Convert .xls to .xlsx for processing in openpyxl trouble

I'm trying to avoid a error openpyxl does not support the old .xls file format, please use xlrd to read this file, or convert it to the more recent .xlsx file format. Following the information...

Possible ways to convert excel file formats from xls to xlsx for use in openpyxl

Im using openpyxl and have a file with dynamically changing structure.I was supposed to do a parser, which based on matches of the values of cells with the elements of the list paren category =...

How to merge multiple .xls files with hyperlinks in python?

I am trying to merge multiple .xls files that have many columns, but 1 column with hyperlinks. I try to do this with Python but keep running into unsolvable errors. Just to be concise, the...