problem about xlrd-Collection of common programming errors

11 years ago
admin
2 minutes

  • Makoto
    python xls cjk xlrd hindi
    http://scienceoss.com/read-excel-files-from-python/comment-page-1/#comment-1051From the above link, I use this utility to read an xls file. If the xls contains different language characters like Chinese or Hindi, it does not output the words correctly .Is there a work around for this?After Googling I found this:import xlrddef upload_xls(dir,file,request):try:global msgglobal row_numrow_num = []header_arr = []global file_pathfile_path = dir#reader = csv.reader(open(file), delimiter=’#’, quotecha

  • addy
    python xlrd
    I am using xlrd to read cell values from excel sheets. My code follows, it was working fine before but don’t know what changed in xlrd package, I am getting the error “TypeError: open_workbook() got an unexpected keyword argument ‘on_demand'”from xlrd import open_workbook bench = open_workbook(‘excelsheet.xls’,on_demand=True) for name in bench.sheet_names():sheetnew = bench.sheet_by_name(name)for i in range(0, 13):for cell in sheetnew.col(i):print cell.valuebench.unload_sheet(name)

  • LucasS
    python hyperlink xlrd openpyxl
    I have been looking at mostly the xlrd and openpyxl libraries for Excel file manipulation. However, xlrd currently does not support formatting_info=True for .xlsx files, so I can not use the xlrd hyperlink_map function. So I turned to openpyxl, but have also had no luck extracting a hyperlink from an excel file with it. Test code below (the test file contains a simple hyperlink to google with hyperlink text set to “test”):import openpyxlwb = openpyxl.load_workbook(‘testFile.xlsx’)ws = wb.get_she

  • bforcer
    python xlrd
    I’m trying to get a data management program running so I can rearrange some data for the company I work for using Python. I don’t really have any experience with Python, but I do with java.http://www.simplistix.co.uk/presentations/python-excel.pdfI found this website that talks about using xlrd and xlwt. I ran xlrd-0.7.1.win32.exe so the api is installed. But even when I try to get the simple script running, it can’t find the open_workbook function:”Undefined variable from import: open_workbook”

Web site is in building