from datetime import datetime excel_date = 42139 dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + excel_date – 2) tt = dt.timetuple() print(dt) print(tt) As mentioned by J.F. Sebastian, this answer only works for any date after 1900/03/01 EDIT: (in answer to @R.K) If your excel_date is a float number, use this code: from datetime import datetime def … Read more
I’m the author of xlrd. There is so much confusion in other answers and comments to rebut in comments so I’m doing it in an answer. @katriealex: “””precision being lost in the guts of xlrd””” — entirely unfounded and untrue. xlrd reproduces exactly the 64-bit float that’s stored in the XLS file. @katriealex: “””It may … Read more
Here are some options to choose from: xlwt (writing xls files) xlrd (reading xls/xlsx files) openpyxl (reading/writing xlsx files) xlsxwriter (writing xlsx files) If you need to copy only data (without formatting information), you can just use any combination of these tools for reading/writing. If you have an xls file, you should go with xlrd+xlwt … Read more
I just implemented a wrapper class that tracks the widths of items as you enter them. It seems to work pretty well. import arial10 class FitSheetWrapper(object): “””Try to fit columns to max size of any entry. To use, wrap this around a worksheet returned from the workbook’s add_sheet method, like follows: sheet = FitSheetWrapper(book.add_sheet(sheet_name)) The … Read more
As I wrote in the edits of the op, to edit existing excel documents you must use the xlutils module (Thanks Oliver) Here is the proper way to do it: #xlrd, xlutils and xlwt modules need to be installed. #Can be done via pip install <module> from xlrd import open_workbook from xlutils.copy import copy rb … Read more
You can use Pandas pandas.read_excel just like pandas.read_csv: import pandas as pd file_errors_location = ‘C:\\Users\\atheelm\\Documents\\python excel mission\\errors1.xlsx’ df = pd.read_excel(file_errors_location) print(df)
Here is one way to handle this: import xlrd book = xlrd.open_workbook(“sample.xls”, formatting_info=True) sheets = book.sheet_names() print “sheets are:”, sheets for index, sh in enumerate(sheets): sheet = book.sheet_by_index(index) print “Sheet:”, sheet.name rows, cols = sheet.nrows, sheet.ncols print “Number of rows: %s Number of cols: %s” % (rows, cols) for row in range(rows): for col in … Read more
Try python setup.py install –user You shouldn’t use sudo as suggested above for two reasons: You’re allowing arbitrary untrusted code off the internet to be run as root Passing the –user flag to python setup.py install will install the package to a user-owned directory. Your normal non-root user won’t be able to access the files … Read more
Try to open it as an HTML with pandas: import pandas as pd data = pd.read_html(‘filename.xls’) Or try any other html python parser. That’s not a proper excel file, but an html readable with excel.
There are two parts to this. First, you must enable the reading of formatting info when opening the source workbook. The copy operation will then copy the formatting over. import xlrd import xlutils.copy inBook = xlrd.open_workbook(‘input.xls’, formatting_info=True) outBook = xlutils.copy.copy(inBook) Secondly, you must deal with the fact that changing a cell value resets the formatting … Read more