Working with Sheet Cells Using Python

Python 3: Automating Your Job Tasks Superhero Level: Automate Excel Tasks with Python 3
4 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€92.01
List Price:  €128.82
You save:  €36.80
£78.38
List Price:  £109.74
You save:  £31.35
CA$136.52
List Price:  CA$191.13
You save:  CA$54.61
A$150.48
List Price:  A$210.68
You save:  A$60.19
S$134.87
List Price:  S$188.83
You save:  S$53.95
HK$780.66
List Price:  HK$1,092.95
You save:  HK$312.29
CHF 91.34
List Price:  CHF 127.88
You save:  CHF 36.54
NOK kr1,052.31
List Price:  NOK kr1,473.28
You save:  NOK kr420.96
DKK kr686.58
List Price:  DKK kr961.24
You save:  DKK kr274.66
NZ$162.83
List Price:  NZ$227.97
You save:  NZ$65.13
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
৳11,719.82
List Price:  ৳16,408.23
You save:  ৳4,688.40
₹8,312.02
List Price:  ₹11,637.16
You save:  ₹3,325.14
RM469.75
List Price:  RM657.67
You save:  RM187.92
₦147,331.26
List Price:  ₦206,269.66
You save:  ₦58,938.40
₨27,796.36
List Price:  ₨38,916.02
You save:  ₨11,119.65
฿3,662.34
List Price:  ฿5,127.43
You save:  ฿1,465.08
₺3,217.98
List Price:  ₺4,505.30
You save:  ₺1,287.32
B$517.06
List Price:  B$723.91
You save:  B$206.84
R1,837.02
List Price:  R2,571.91
You save:  R734.88
Лв180.27
List Price:  Лв252.38
You save:  Лв72.11
₩136,066.92
List Price:  ₩190,499.14
You save:  ₩54,432.21
₪368.12
List Price:  ₪515.38
You save:  ₪147.26
₱5,814.46
List Price:  ₱8,140.48
You save:  ₱2,326.02
¥15,687.99
List Price:  ¥21,963.82
You save:  ¥6,275.82
MX$1,668.59
List Price:  MX$2,336.09
You save:  MX$667.50
QR364.34
List Price:  QR510.10
You save:  QR145.75
P1,357.56
List Price:  P1,900.64
You save:  P543.07
KSh13,298.67
List Price:  KSh18,618.67
You save:  KSh5,320
E£4,713.99
List Price:  E£6,599.78
You save:  E£1,885.78
ብር5,741.12
List Price:  ብር8,037.80
You save:  ብር2,296.67
Kz84,932.10
List Price:  Kz118,908.34
You save:  Kz33,976.24
CLP$90,081.08
List Price:  CLP$126,117.11
You save:  CLP$36,036.03
CN¥724.33
List Price:  CN¥1,014.10
You save:  CN¥289.76
RD$5,884.09
List Price:  RD$8,237.97
You save:  RD$2,353.87
DA13,459.27
List Price:  DA18,843.53
You save:  DA5,384.25
FJ$222.79
List Price:  FJ$311.92
You save:  FJ$89.12
Q776.15
List Price:  Q1,086.64
You save:  Q310.49
GY$20,904.26
List Price:  GY$29,266.81
You save:  GY$8,362.54
ISK kr13,793.62
List Price:  ISK kr19,311.62
You save:  ISK kr5,518
DH996.63
List Price:  DH1,395.33
You save:  DH398.69
L1,771.78
List Price:  L2,480.56
You save:  L708.78
ден5,664.24
List Price:  ден7,930.17
You save:  ден2,265.92
MOP$804.05
List Price:  MOP$1,125.70
You save:  MOP$321.65
N$1,836.30
List Price:  N$2,570.90
You save:  N$734.59
C$3,677.56
List Price:  C$5,148.73
You save:  C$1,471.17
रु13,287.88
List Price:  रु18,603.56
You save:  रु5,315.68
S/373.53
List Price:  S/522.95
You save:  S/149.42
K388.30
List Price:  K543.64
You save:  K155.33
SAR375.02
List Price:  SAR525.05
You save:  SAR150.02
ZK2,666.83
List Price:  ZK3,733.66
You save:  ZK1,066.83
L457.94
List Price:  L641.14
You save:  L183.19
Kč2,276.37
List Price:  Kč3,187.01
You save:  Kč910.64
Ft35,391.42
List Price:  Ft49,549.41
You save:  Ft14,157.98
SEK kr1,062.40
List Price:  SEK kr1,487.41
You save:  SEK kr425
ARS$89,066.09
List Price:  ARS$124,696.09
You save:  ARS$35,630
Bs690.41
List Price:  Bs966.60
You save:  Bs276.19
COP$385,967.67
List Price:  COP$540,370.17
You save:  COP$154,402.50
₡51,227.77
List Price:  ₡71,720.93
You save:  ₡20,493.15
L2,469.21
List Price:  L3,457
You save:  L987.78
₲751,546.38
List Price:  ₲1,052,195.01
You save:  ₲300,648.62
$U3,849.38
List Price:  $U5,389.29
You save:  $U1,539.90
zł391.29
List Price:  zł547.82
You save:  zł156.53
Already have an account? Log In

Transcript

Following up on the previous lecture, in this lecture, we are going to see more sheet operations. And we are going to start with getting the value of a cell in a sheet by using the cell coordinates. First of all, we are referencing the same sheet from within the workbook, and that is employee data. And now in order to get the value of a particular cell, we will use sheet and in between square brackets and also in between quotes, let's enter the coordinates of that particular cell. So let's assume we want to get the value for cell B seven. And now after the square brackets, we are using the value attribute.

So dot value, and we have the value of the cell returns which is Anna. Let's check this. Indeed, the cell B seven has this value right here, which is Anna and this is correct. Another way to get the value of a sale in a sheet Using the coordinates of that cell is the following sheet, dot cell. And in between the parentheses of this method, we specify row equals, let's say six, comma column equals two. And again dot value.

Sorry, I entered the comma instead of a.so dot value. And this time we have Emily returned. So we are referencing row six and column two. That would be this cell right here basics, which is indeed, Emily. Okay. Now how can we reference a particular cell inside the sheet?

Well, that's pretty easy. Cell equals sheet, and in between square brackets, we enter the coordinates of the cell. So that would be let's say, B, nine, okay, and Enter. Now we can check several attributes for this cell, so cell, dot row, and of course We have row nine cell dot column. And that returns B, of course. And finally, cell dot coordinate, returns B nine, which is the full coordinate of this cell.

Okay, another set of information about the cells that we might need is the data type of the value inside the cell. And in order to get this data type, we are going to use cell dot data type. And we have s for string, because inside cell B nine, we have the first name of one of our employees, which is of course, a string. Now let's get back into the Python interpreter. And also we can check out the encoding format for a cell for the value inside the cell. So cell dot encoding, and that would be UTF eight, which is the default.

Also we can set a certain value for a cell. So first of all, I'm going to close this workbook to avoid any permission related issues, and I'm going to use Cell equals, let's say sheet of v2. And since we are working on column B, we will change the first name of one of our employees inside the workbook. So let's say cell dot value equals, and let's enter David for example. Okay. And of course, we should save our workbook.

So workbook dot Save, and the full path to the file. Now let's check our workbook once again. And indeed, we now have David in cell v2 inside our sheet, which is correct. The last thing I'll show you in this lecture is how to get the parent worksheet for a cell. So referring to our cell B two, let's find out the worksheet that is the parent of this cell by simply using the parent attributes or cell, not parent. And indeed, we have worksheet employee data returned.

Okay, I'll see you in the next lecture where we are going to talk about styles

Sign Up

Share

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.