From password-protected Excel file to pandas DataFrame

by

Assuming the starting cell is given as (StartRow, StartCol) and the ending cell is given as (EndRow, EndCol), I found the following worked for me:

# Get the content in the rectangular selection region
# content is a tuple of tuples
content = xlws.Range(xlws.Cells(StartRow, StartCol), xlws.Cells(EndRow, EndCol)).Value 

# Transfer content to pandas dataframe
dataframe = pandas.DataFrame(list(content))

Note: Excel Cell B5 is given as row 5, col 2 in win32com. Also, we need list(…) to convert from tuple of tuples to list of tuples, since there is no pandas.DataFrame constructor for a tuple of tuples.

More Related Contents:

  1. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  2. Putting many python pandas dataframes to one excel worksheet
  3. how to calculation cost time [closed]
  4. Filter dataframe rows if value in column is in a set list of values [duplicate]
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. String concatenation of two pandas columns
  7. datetime dtypes in pandas read_csv
  8. Reshape wide to long in pandas
  9. Pandas – Slice large dataframe into chunks
  10. Find column name in pandas that matches an array
  11. How do convert a pandas dataframe to XML?
  12. Sort a pandas dataframe series by month name
  13. Count frequency of values in pandas DataFrame column
  14. Strip / trim all strings of a dataframe
  15. Joining pandas DataFrames by Column names
  16. pandas get the row-wise minimum value of two or more columns
  17. Merge rows based on value (pandas to excel – xlsxwriter)
  18. Set maximum value (upper bound) in pandas DataFrame
  19. Diff of two Dataframes
  20. Apply function to pandas DataFrame that can return multiple rows
  21. Return multiple columns from pandas apply()
  22. How to slice a pandas DataFrame by position?
  23. Python Pandas – Merge based on substring in string
  24. Filling in date gaps in MultiIndex Pandas Dataframe
  25. Writing a Python Pandas DataFrame to Word document
  26. Find unique values in a Pandas dataframe, irrespective of row or column location
  27. Remove ends of string entries in pandas DataFrame column
  28. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment