AtBS 12 Excel

Question 1

How to import openpyxl?

Answer 1

import openpyxl

Question 2

How to load a workbook object in openpyxl?

Answer 2

WkbkObject = openpyxl.load_workbook (‘wkbk.xlsx’)

Question 3

How to get Excel tab names with openpyxl?

Answer 3

WkbkObject.sheetnames

Question 4

How to set a sheet object in openpyxl?

Answer 4

sheetname = WkbkObject[‘Sheet1’]

Question 5

How to get a cell value with openpyxl?

Answer 5

1. Set Variable=Sheet[‘A1’]

2. type Variable.value into shell

Question 6

How to convert column letters in Excel

Answer 6

1. From openpyxl.utils import get_column_letter, column_index_from_string
2. get_column_letter(1) returns A or
3. Column_index_from_string(‘A’) returns 1