Stack Overflow
Stack Overflow

Questions tagged [xlrd]

xlrd is a python library to extract data from Microsoft Excel spreadsheet files

xlrd is a python library to extract data from Microsoft Excel spreadsheet files.

xlrd can extract data from Excel spreadsheets (.xls and .xlsx, versions 2.0 onwards) on any platform, is written in pure Python and is Unicode-aware.

1366 questions
-1
votes
1 answer

Get cached value from Excel 2003 spreadsheet using Python xlrd

I have an Excel 2003 spreadsheet with values and formulas. Using Python 2.7, I need to read all the values from the spreadsheet, and none of the formulas. If a cell has a formula, I need the cached value from the cell. Using xlrd, how can I get…
Greymarch
  • 606
  • 2
  • 7
  • 11
-1
votes
1 answer

openpyxl _external_links too slow

I need to read a excel and get the external_books the excel used(for there is INDEX or VLOOKUP func used in the excel) I choose openpyxl,the openpyxl.WorkBook._external_links api can do it well，but the speed is too slow（my excel is 600KB），about…
W G
  • 11
  • 3
-1
votes
1 answer

Copying the segment from one Excel file to another with python: xlrd and xlsxwriter

I am trying to copy an entire segment of an Excel sheet to another file. The segment is actually a header/description, which mainly describes the attributes of the file, the date it was created, etc... All this takes some cells at first five rows…
Michael
  • 415
  • 5
  • 12
-1
votes
1 answer

Parsing for keywords in excel using xlrd python 3.3

I am unfamilar with the parsing of excel files and it has come to my attention that I should use xlrd. I wish to pull out all the line with the "predicted" keyword. The excel array is on sheet1 it is made of 4 columns (A-D) and I need to pull…
M.Smith12
  • 51
  • 6
-1
votes
1 answer

Not printing anything on console

import Tkinter import tkMessageBox import xlwt from xlrd import open_workbook from tempfile import TemporaryFile from xlwt import Workbook import tkSimpleDialog import tkMessageBox from tkFileDialog import * top = Tkinter.Tk() #FSR def fsr(): …
user3848981
  • 11
  • 4
-1
votes
1 answer

How to read sheets in the existing XLSX by using openpyxl?

I am reading existing xlsx sheet and writing data into that using openpyxl,but for reading sheets I used 'load_workbook'is that right way to get sheet from existing xlsx file,it showing error I go t error like this: Traceback (most recent call…
doubts
  • 157
  • 1
  • 1
  • 9
-1
votes
1 answer

How to get total details of current week?

for wk in sorted(out.keys()): rec_date = datetime.datetime(*xlrd.xldate_as_tuple(wk, inputfp.datemode)).isocalendar()[1]#search for dates of current week if rec_date == datetime.date.today().isocalendar()[1]:#conditions to check current week dates …
doubts
  • 157
  • 1
  • 1
  • 9
-1
votes
1 answer

Find word in list created by xlrd and print sentence

I have Excel files with data that I need to summarize so I've created a list called a_master that contains all of this info (using xlrd). What I need to do now is search for a specific word for example "cloud" and if it finds the word, to print out…
Danny
  • 75
  • 1
  • 2
  • 8
-1
votes
3 answers

xlrd python does not work - "syntax error"

I'm trying to get familiar with xlrd so I copied an example into my IDE (spyder). I'm using python(x,y) 2.7.6.1 This is my example import xlrd import os filename=os.path.join("C:/","Desktop/myfile"): book = xlrd.open_workbook(filename) print "The…
user46147
  • 232
  • 1
  • 16
-1
votes
1 answer

Python/Excel - TypeError: 'Book' object is not iterable

Attempting to extract .xlsx docs from a file and compile the data into a single worksheet. Receiving TypeError: 'Book' object is not iterable, but I don't have an object titled "Book". So, I guess my confusion is understanding how to make the…
Mike V.
  • 83
  • 1
  • 3
  • 11
-1
votes
1 answer

Find specific String in Excel Cell using XLRD

My excel files contains some specific values and one of the cells contains general description. Sometimes in the description there are some warning messages with certain keywords (e.g. high, low, increase, decrease, closure). Is there a way to…
Joy
  • 61
  • 2
  • 8
-1
votes
1 answer

Unable to get integer number as text via xlrd

I am unable to get integer number as text from .xls file via xlrd. I have the following data in my cell: 20 and the cell type in Excel is "Text" Also I have the following code to read this value: some_value = sheet.cell(row,…
FrozenHeart
  • 19,844
  • 33
  • 126
  • 242
-1
votes
2 answers

Read From Microsoft Excel (.xlsx) file and Insert into a DB using Python?

I'm working on an application to read an .xlsx, (Excel File) with headers and insert the rows, as-is, into a DB Table in a Postgres DB. I presume i would be using the XLRD library. Any ideas on How to do this? I'm using Python 2.6.6.
Arpan J
  • 11
  • 1
-1
votes
1 answer

return Set of lists from out of function: python

Method collectInfoFromXLS() extracts all the contents which are under quotes ('') from given XLS file, and puts in an List. class ExtractInfo(object): def collectInfoFromXLS(): workbookPath = config.get('TestCaseFileURL','XLSpath') …
WEshruth
  • 769
  • 3
  • 16
  • 32
-1
votes
1 answer

library xlrd is not supported

Possible Duplicate: Is xlrd supported in Google App Engine? I am developeing a google app engine application , in which i want to read some exel file. I am using xlrd lib but it showing me the error ImportError: No module named xlrd I have also…
user1710922
1 2 3
…
91 92