Getting General Information About a Sheet

Python 3: Automating Your Job Tasks Superhero Level: Automate Excel Tasks with Python 3
3 minutes
Share the link to this page
You need to have access to the item to view this lesson.
One-time Fee
List Price:  $139.99
You save:  $40
List Price:  €129.06
You save:  €36.87
List Price:  £110.01
You save:  £31.43
List Price:  CA$191.35
You save:  CA$54.67
List Price:  A$210.84
You save:  A$60.24
List Price:  S$188.90
You save:  S$53.97
List Price:  HK$1,093.06
You save:  HK$312.32
CHF 91.36
List Price:  CHF 127.90
You save:  CHF 36.54
NOK kr1,064.83
List Price:  NOK kr1,490.80
You save:  NOK kr425.97
DKK kr687.94
List Price:  DKK kr963.14
You save:  DKK kr275.20
List Price:  NZ$228.40
You save:  NZ$65.26
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  ৳16,418.13
You save:  ৳4,691.23
List Price:  ₹11,653.68
You save:  ₹3,329.86
List Price:  RM658.58
You save:  RM188.18
List Price:  ₦202,635.52
You save:  ₦57,900
List Price:  ₨39,010.23
You save:  ₨11,146.57
List Price:  ฿5,113.97
You save:  ฿1,461.24
List Price:  ₺4,509.83
You save:  ₺1,288.61
List Price:  B$721.46
You save:  B$206.14
List Price:  R2,573.45
You save:  R735.32
List Price:  Лв252.47
You save:  Лв72.14
List Price:  ₩190,865.12
You save:  ₩54,536.78
List Price:  ₪514.04
You save:  ₪146.88
List Price:  ₱8,144.28
You save:  ₱2,327.10
List Price:  ¥21,931.91
You save:  ¥6,266.71
List Price:  MX$2,330.37
You save:  MX$665.86
List Price:  QR510.97
You save:  QR146
List Price:  P1,893.83
You save:  P541.13
List Price:  KSh18,548.67
You save:  KSh5,300
List Price:  E£6,593.52
You save:  E£1,884
List Price:  ብር8,051.60
You save:  ብር2,300.62
List Price:  Kz118,917.63
You save:  Kz33,978.89
List Price:  CLP$125,807.61
You save:  CLP$35,947.60
List Price:  CN¥995.41
You save:  CN¥284.42
List Price:  RD$8,224.32
You save:  RD$2,349.97
List Price:  DA18,834.81
You save:  DA5,381.76
List Price:  FJ$317.23
You save:  FJ$90.64
List Price:  Q1,088.99
You save:  Q311.16
List Price:  GY$29,321.70
You save:  GY$8,378.22
ISK kr13,838.61
List Price:  ISK kr19,374.61
You save:  ISK kr5,536
List Price:  DH1,387.67
You save:  DH396.50
List Price:  L2,475.08
You save:  L707.21
List Price:  ден7,958.33
You save:  ден2,273.97
List Price:  MOP$1,126.84
You save:  MOP$321.97
List Price:  N$2,547.09
You save:  N$727.79
List Price:  C$5,158.32
You save:  C$1,473.91
List Price:  रु18,669.25
You save:  रु5,334.45
List Price:  S/523.33
You save:  S/149.53
List Price:  K544.66
You save:  K155.63
List Price:  SAR525.05
You save:  SAR150.02
List Price:  ZK3,654.34
You save:  ZK1,044.17
List Price:  L642.19
You save:  L183.49
List Price:  Kč3,189.28
You save:  Kč911.28
List Price:  Ft49,959.85
You save:  Ft14,275.26
SEK kr1,068.91
List Price:  SEK kr1,496.52
You save:  SEK kr427.60
List Price:  ARS$124,588.23
You save:  ARS$35,599.18
List Price:  Bs968.45
You save:  Bs276.72
List Price:  COP$533,464.74
You save:  COP$152,429.38
List Price:  ₡71,860.04
You save:  ₡20,532.90
List Price:  L3,463.59
You save:  L989.66
List Price:  ₲1,054,446.66
You save:  ₲301,291.99
List Price:  $U5,362.45
You save:  $U1,532.23
List Price:  zł550.82
You save:  zł157.39
Already have an account? Log In


OK, so let's start working with sheets. First of all, let's reference the sheet that we want to use for this lecture. So that would be the employee data sheet from within the workbook. So sheet equals workbook of employee data, Enter. And now let's get the title of our sheet by using the title attribute sheet dot title. And indeed, we get the name of the sheet.

By the way, if you want to see all the available sheet operations, you can just use the DIR function, so dir, of sheet, and these are all the available methods and attributes for working with sheets. Okay, now let's move further. And let's get the active cell within this sheet. So we would have sheet dot active cell and this is usually the first cell in the sheet and that would be a one. So let's check this. And of course, a one is the active cell of this sheet of the employee.

Data Sheet. Okay, now how can we get the dimensions of the sheet, that would mean the array populated with data. So let's try sheet dot dimensions. And if we open the file, to check this, you can see that within this sheet employee data, we have this array right here populated with data starting from a one up to F 11, right here in the lower right corner. And that's exactly what this attribute returns a one, f 11. Okay, now let's see how can we get the basic parameters of a sheet by using sheet dot sheet format.

And you can see that for example, we have the base column width, and also the default row height, among other parameters. Let's also use sheet dot sheet underscore properties on other attributes, that also returns various parameters about the sheet. Another set Data can also be obtained using sheets dot sheet state. And this returns the state of the sheet if it's visible or hidden inside the workbook. Also, we have sheet dot Sheet view. And again, we have one other set of data about the sheet.

And I'm not going to insist too much on these basic parameters about the sheet because you most probably won't use them too often. However, again, using their sheet, you can find out all the available methods and attributes for a sheet, and you can play around with each of them on your own. For now, let's get on to more interesting things. For example, getting the number of rows inside the sheet. To do that we have sheet dot max row. And of course we have 11 rows inside our sheet as you can see right here, of course, the same thing can be done for the columns.

So sheet dot Max, column, and indeed we have six columns ABCD D and F. Okay, what else? For example, we can return the rows in a sheet as topples by simply iterating over sheet dot values. So using the values attribute, let me show you this. For I in sheet dot values, let's say print I. And indeed, we get the rows in the sheet returned as topples, which can prove to be a very useful thing to have at hand when building an application. Okay, so these were some general considerations about sheets.

You've seen how to access various properties and attributes related to a sheet, how to get the number of rows and columns inside the sheet, and also how to iterate over the rows in a sheet and print these rows in the form of a table. In the next lecture, we are going to start working with more advanced sheet operations and see what other information about the sheet can we extract using the open pi Excel module. So I'll see you in the next lecture.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.