Databases
StackOverflow2013
Postsdbo
POhow to extract data from one excel workbook and output to another using python xlrd/xlwt?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to extract data from one excel workbook and output to another using python xlrd/xlwt?
    primarykey
    data
    text
    <p>I am trying to write a script which will automate a copy/paste of employee time sheets from several files to one compiled file. Since they are time sheets with project codes some cells are left blank where an employee worked on a different project that day. Also the files have been converted from xlsx(2007) to .csv.xls which xlrd seems to open just fine.</p> <p>I do know how to open and create a book object but my knowledge of this module is very limited so I thought maybe a general algorithm would be helpful:</p> <pre><code>import xlrd, xlwt put all following in for or while loop to iterate through files: book = xlrd.open_workbook('mybook.csv.xls') extract data; store data for ouput use for loop to iterate over data, output to final sheet open next file, repeat process storing each output below the previous </code></pre> <p>I am looking for anything that will help me find the answers, not just code. Any help would be appreciated. Thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USCorey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAlso I am trying to read columns {A:T} and rows {3:27} which include str and float dtypes. I'm pretty sure that a list with type string for existing values and nan or null any empty space would be easy to work with.
      singulars
      1. POhow to extract data from one excel workbook and output to another using python xlrd/xlwt?
      1. USCorey
    2. COTo read/write xlsx files in python use `openpyxl` (https://bitbucket.org/ericgazoni/openpyxl/downloads). However, the real solution is to stop having employees store their time sheets in excel files!
      singulars
      1. POhow to extract data from one excel workbook and output to another using python xlrd/xlwt?
      1. USSteven Rumbalski
    3. COIndeed. Thanks, I will checkout openpyxl. Also I have worked through most of this problem already so unless you really want to; no more info is needed but thank you!
      singulars
      1. POhow to extract data from one excel workbook and output to another using python xlrd/xlwt?
      1. USCorey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload