create account

Automating Excel Spreadsheets With OpenPyXL by geekgirl

View this thread on: hive.blogpeakd.comecency.com
· @geekgirl ·
$143.07
Automating Excel Spreadsheets With OpenPyXL
![openpyxl.png](https://images.hive.blog/DQmZcbARsXt9Tnime189FiPSs1YQkydMYqerNZBhYS6ToB3/openpyxl.png)

Automating tasks with python is fun and saves a lot of time. One of the commonly used document types is excel files. Microsoft Excel is a powerful software that can help with finances, accounting, data sharing and analysis. Things that can be done with Excel range from simple personal finance records to complicated data documents. While it is a very useful software, doing repetitive tasks over and over gets boring and time consuming. That's why using automating tools like OpenPyXL can be more fun, productive, and efficient.

Since Excel and Python both have been around for a while, there are many libraries that make automating excel with python possible. Lately, I have been using OpenPyXL to extract data from excel files and convert them into reports in new excel files. In fact, I spent all day on a project today that I have been planning for weeks now. Now that the project is complete, it will save hours every week and I happy to share here how awesome OpenPyXL is.

OpenPyXL is a python library to create, read, and edit Excel files. It is easy to use, has easy documentation, and many resources online to find solutions when we face problems with our code. To get started with OpenPyXL we pip install the library and start writing code.

```
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
```

Workbook is the main object that creates our excel file in memory. Then we can go to the active worksheet and start reading or editing it. As you may already know worksheets consist of columns, rows, and cells. 

If we want to add a value to a cell, we just do the following.

`ws['A1'] = 'Hive'`

It write Hive into cell B5, which is located in column B and 5th row.

If we want to add entire row of values, we can do the following.

`ws.append(['HBD','pays', '20%', 'APR'])`

This will append four value shown in the list above after the previous value we entered. I knot these are very simple things to do. Experimenting with simple tasks, we continue making the tasks more complicated with using functions like merging cells, assigning fonts, size, colors, fill colors, and much more.

Let's say we want to define width for the columns we use, we can do so as following:

```
ws.column_dimensions['A'].width = 25
ws.column_dimensions['B'].width = 16
ws.column_dimensions['C'].width = 16
ws.column_dimensions['D'].width = 16
ws.column_dimensions['E'].width = 25

```

The best thing about automating with python is once we know what we need to do, and have an understanding of applying various formats and styles to one cell, we can iterate through thousands of them and repeat the same set of tasks.

To define fonts, fill colors, text alignment, borders to the our spreadsheet cells we need import other useful modules of the opepyxl.

```
from openpyxl.styles import PatternFill, Border, Side, Alignment, Font
```

Let's say we would like apply some of these to cell 'C3'.

```
ws['C3'].font = Font(size=24, bold=True)
ws['C3'].fill = PatternFill(start_color='FF76B5C5', end_color='FF76B5C5', fill_type='solid')
ws['C3'].alignment = Alignment(horizontal='center', vertical='center')
ws['C3'].border = Border(left=Side(style='thin'),
			right=Side(style='thin'),
			top=Side(style='thin'),
			bottom=Side(style='thin')
```

Again, once we can do anything with one cell, we can do the same with thousands of them by iterating through the range of cells. Moreover, it become super simple once we create helper functions to do so based on the tasks we are trying to achieve.

These are only some of the examples what can be done with openpyxl. There are many more super useful functions it has. Any that can be done on openpyxl, can be done on excel. We use this library to automate the tasks.

When working with excel files we may want to create new worksheets, and we can do that as folllowing:

`ws = wb.create_sheet('Balance')`

If we wanted to access this or other sheets in the active workbook we do so like this:

`ws = wb['Balance']`

Once we are done with are project we can save the file.

`wb.save(filepath)`

The real fun with OpenPyXL starts we actually try to solve a problem, and automate real life tasks. It is very good at it. If you use excel files on daily basis and know a little bit of python, I would highly recommend to consider automating repetitive tasks and save some time. 

Some may consider using dataframes and csv files. These are really good solutions. But if you need something with properly styled documents to share with clients, teams, or colleagues you would have to spend more time applying them manually. OpenPyXL can help with doing this for you.

One of the ideas for a Hive based project can be, creating a tool that gets wallet transfers for an account, creates an excel file with all the data and formatting and have it ready to be downloaded. If this is something you may be interested in, I can go through that process in the future or maybe even include this to my [Hive Librarian App](https://hivelibrarian.herokuapp.com).

Have you used OpenPyXL or other libraries that help with automating excel worksheets? What are your thoughts on automating repetitive tasks? Let me know in the comments.

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@geekgirl/automating-excel-spreadsheets-with-openpyxl)
πŸ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 305 others
πŸ‘Ž  , ,
properties (23)
authorgeekgirl
permlinkautomating-excel-spreadsheets-with-openpyxl
categoryhive-167922
json_metadata{"app":"leofinance/0.2","format":"markdown","tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"canonical_url":"https://leofinance.io/@geekgirl/automating-excel-spreadsheets-with-openpyxl","links":["https://hivelibrarian.herokuapp.com"],"image":["https://images.hive.blog/DQmZcbARsXt9Tnime189FiPSs1YQkydMYqerNZBhYS6ToB3/openpyxl.png"]}
created2022-04-12 04:59:30
last_update2022-04-12 04:59:30
depth0
children24
last_payout2022-04-19 04:59:30
cashout_time1969-12-31 23:59:59
total_payout_value71.611 HBD
curator_payout_value71.454 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length5,392
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,219,956
net_rshares128,273,704,118,580
author_curate_reward""
vote details (372)
@baby.magic ·
$0.38
When I started reading this I was in good condition. 1 minute into the post and my brains starts to hurt.. I think I need to go to a hospital now. I'll finish reading it once I get out.πŸ€’πŸ€•
πŸ‘  ,
properties (23)
authorbaby.magic
permlinkre-geekgirl-ra85jo
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2022.04.4"}
created2022-04-12 11:40:54
last_update2022-04-12 11:40:54
depth1
children2
last_payout2022-04-19 11:40:54
cashout_time1969-12-31 23:59:59
total_payout_value0.190 HBD
curator_payout_value0.189 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length187
author_reputation11,234,434,429,264
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,226,996
net_rshares338,305,381,530
author_curate_reward""
vote details (2)
@geekgirl ·
$0.04
lol, sorry.
πŸ‘  
properties (23)
authorgeekgirl
permlinkra93mf
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 23:51:51
last_update2022-04-12 23:51:51
depth2
children1
last_payout2022-04-19 23:51:51
cashout_time1969-12-31 23:59:59
total_payout_value0.020 HBD
curator_payout_value0.020 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length11
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,244,887
net_rshares37,743,833,992
author_curate_reward""
vote details (1)
@baby.magic ·
$0.04
This is the patient's doctor sorry he can't reply to you right now
 He's in coma.
πŸ‘  
properties (23)
authorbaby.magic
permlinkre-geekgirl-ra93x3
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2022.04.5"}
created2022-04-13 00:03:21
last_update2022-04-13 00:03:21
depth3
children0
last_payout2022-04-20 00:03:21
cashout_time1969-12-31 23:59:59
total_payout_value0.019 HBD
curator_payout_value0.020 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length81
author_reputation11,234,434,429,264
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,245,084
net_rshares37,706,310,336
author_curate_reward""
vote details (1)
@chinito ·
$0.15
ah ha! some of the where the real magic happens! :) awesome.. automation is cool!
πŸ‘  ,
properties (23)
authorchinito
permlinkre-geekgirl-ra8u7f
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2022.04.5"}
created2022-04-12 20:28:30
last_update2022-04-12 20:28:30
depth1
children0
last_payout2022-04-19 20:28:30
cashout_time1969-12-31 23:59:59
total_payout_value0.076 HBD
curator_payout_value0.077 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length81
author_reputation190,580,489,599,944
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,240,419
net_rshares138,215,622,793
author_curate_reward""
vote details (2)
@dbooster ·
Very interesting. Another of your posts I am bookmarking for future use!

I use a Mac and I use the beejesus out of Applescript, using it to automate almost every app that supports it in some some way (sadly, many newer 3rd party apps no longer support Applescript, I suspect because they come from the iOS ecosystem and don't really understand it). I don't think I could even begin to use Numbers (the Apple spreadsheet app) without my scripts to automate everything for me. Does Windows have something similar to Applescript? Or does Python fill that role?

!PIZZA
properties (22)
authordbooster
permlinkre-geekgirl-raa2it
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2022.04.5"}
created2022-04-13 12:25:45
last_update2022-04-13 12:25:45
depth1
children1
last_payout2022-04-20 12:25:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length566
author_reputation1,023,275,918,482,609
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,259,168
net_rshares0
@geekgirl ·
I also mainly use Mac. However, never used Applescript. I occasionally use Windows, and don't really like it.
properties (22)
authorgeekgirl
permlinkrao7x3
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-21 03:48:39
last_update2022-04-21 03:48:39
depth2
children0
last_payout2022-04-28 03:48:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length109
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,486,299
net_rshares0
@draysax ·
This looks promising. Thanks for the exposition on this.
properties (22)
authordraysax
permlinkre-geekgirl-raedtt
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2022.04.5"}
created2022-04-15 20:20:18
last_update2022-04-15 20:20:18
depth1
children0
last_payout2022-04-22 20:20:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length56
author_reputation35,624,980,545,155
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,330,846
net_rshares0
@elyelma ·
$0.15
Awesome as usual.

@geekgirl thanks again for outstanding content. There is always the normal way to do things, and the optimal way. !PIZZA

\- EvM
πŸ‘  ,
properties (23)
authorelyelma
permlinkre-geekgirl-2022412t22251234z
categoryhive-167922
json_metadata{"tags":["hive-167922","python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.27-mobile","format":"markdown+html"}
created2022-04-12 07:22:51
last_update2022-04-12 07:22:51
depth1
children0
last_payout2022-04-19 07:22:51
cashout_time1969-12-31 23:59:59
total_payout_value0.077 HBD
curator_payout_value0.076 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length147
author_reputation3,280,081,322,329
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,207
net_rshares138,500,239,577
author_curate_reward""
vote details (2)
@erguvani ·
$0.44
I use Exel in my work, thank you for suggesting such an interesting solution, I will definitely try)
πŸ‘  , , ,
properties (23)
authorerguvani
permlinkre-geekgirl-2022412t92338816z
categoryhive-167922
json_metadata{"tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-12 06:23:39
last_update2022-04-12 06:23:39
depth1
children0
last_payout2022-04-19 06:23:39
cashout_time1969-12-31 23:59:59
total_payout_value0.221 HBD
curator_payout_value0.218 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length100
author_reputation184,181,096,029
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,221,278
net_rshares394,976,600,176
author_curate_reward""
vote details (4)
@jfang003 ·
$0.38
I have used it a few times before to generate some test data or to add/modify columsn. However, I don't think I used OpenPyXL specifically but one of the random libraries I found through google.

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@jfang003/re-geekgirl-6attpy)
πŸ‘  ,
properties (23)
authorjfang003
permlinkre-geekgirl-6attpy
categoryhive-167922
json_metadata{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@jfang003/re-geekgirl-6attpy"}
created2022-04-12 07:13:45
last_update2022-04-12 07:13:45
depth1
children0
last_payout2022-04-19 07:13:45
cashout_time1969-12-31 23:59:59
total_payout_value0.191 HBD
curator_payout_value0.191 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length289
author_reputation638,610,680,971,394
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,092
net_rshares342,985,472,114
author_curate_reward""
vote details (2)
@menox98 ·
$0.42
I like using OpenPyXL it faciliates my work that allows more operations and plotting graphs fastly
πŸ‘  , ,
properties (23)
authormenox98
permlinkra7q88
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 06:05:12
last_update2022-04-12 06:05:12
depth1
children1
last_payout2022-04-19 06:05:12
cashout_time1969-12-31 23:59:59
total_payout_value0.211 HBD
curator_payout_value0.210 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length98
author_reputation7,177,297,712,342
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,221,003
net_rshares379,222,290,764
author_curate_reward""
vote details (3)
@geekgirl ·
$0.04
I haven't used it for plotting yet. That is good to know.
πŸ‘  
properties (23)
authorgeekgirl
permlinkra93ls
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 23:51:30
last_update2022-04-12 23:51:30
depth2
children0
last_payout2022-04-19 23:51:30
cashout_time1969-12-31 23:59:59
total_payout_value0.020 HBD
curator_payout_value0.020 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length57
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,244,881
net_rshares37,781,124,762
author_curate_reward""
vote details (1)
@mintfinch ·
$0.42
 Repetitive tasks in never ending boxes is a daunting task. Glad automation is possible. Personally I haven't used the automation to replace all my work Load. But used it to summarise what has been worked on  with the use of formulars to bet to the answer quick. This here is new and work exploring. Thank you 
πŸ‘  , ,
properties (23)
authormintfinch
permlinkre-geekgirl-2022412t94728848z
categoryhive-167922
json_metadata{"tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-12 07:47:30
last_update2022-04-12 07:47:30
depth1
children0
last_payout2022-04-19 07:47:30
cashout_time1969-12-31 23:59:59
total_payout_value0.208 HBD
curator_payout_value0.207 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length310
author_reputation10,209,487,593,656
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,684
net_rshares372,903,118,256
author_curate_reward""
vote details (3)
@olympicdragon ·
$0.30
This is great. I like to learn excel. I think YouTube has lots of videon how to. There is only one version of excel, or perhaps there is different types !

!PIZZA
πŸ‘  , ,
properties (23)
authorolympicdragon
permlinkre-geekgirl-2022412t15404859z
categoryhive-167922
json_metadata{"tags":["hive-167922","python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.27-mobile","format":"markdown+html"}
created2022-04-12 07:40:48
last_update2022-04-12 07:40:48
depth1
children0
last_payout2022-04-19 07:40:48
cashout_time1969-12-31 23:59:59
total_payout_value0.149 HBD
curator_payout_value0.148 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length162
author_reputation34,659,922,596,582
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,581
net_rshares267,715,706,371
author_curate_reward""
vote details (3)
@pizzabot · (edited)
RE: Automating Excel Spreadsheets With OpenPyXL
<center>PIZZA! PIZZA! PIZZA! 


PIZZA Holders sent <strong>$PIZZA</strong> tips in this post's comments:
@dbooster<sub>(3/10)</sub> tipped @geekgirl (x1)
olympicdragon tipped geekgirl (x1)
elyelma tipped geekgirl (x1)


<sub>You can now send $PIZZA tips in <a href="https://discord.gg/hivepizza">Discord</a> via tip.cc!</sub></center>
properties (22)
authorpizzabot
permlinkre-automating-excel-spreadsheets-with-openpyxl-20220412t072349z
categoryhive-167922
json_metadata"{"app": "beem/0.24.26"}"
created2022-04-12 07:23:51
last_update2022-04-13 12:26:54
depth1
children0
last_payout2022-04-19 07:23:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length334
author_reputation7,552,279,351,159
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,222
net_rshares0
@salexa5 ·
$0.15
I have worked some in google sheets.  I like the ease of use.  Was trying to do some sheets on coin tracking.  Any one who can work in excel is a wonder to me.
πŸ‘  ,
properties (23)
authorsalexa5
permlinkre-geekgirl-2022412t1550125z
categoryhive-167922
json_metadata{"tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-12 20:05:00
last_update2022-04-12 20:05:00
depth1
children1
last_payout2022-04-19 20:05:00
cashout_time1969-12-31 23:59:59
total_payout_value0.076 HBD
curator_payout_value0.077 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length159
author_reputation765,701,964,104
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,239,834
net_rshares138,367,356,598
author_curate_reward""
vote details (2)
@geekgirl ·
$0.05
My first project with openpyxl was for a trading journal to keeping track of certain stocks and the prices. Can be useful for coin tracking too.
πŸ‘  ,
properties (23)
authorgeekgirl
permlinkra93s8
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 23:55:21
last_update2022-04-12 23:55:21
depth2
children0
last_payout2022-04-19 23:55:21
cashout_time1969-12-31 23:59:59
total_payout_value0.026 HBD
curator_payout_value0.026 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length144
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,244,950
net_rshares48,494,995,695
author_curate_reward""
vote details (2)
@shortsegments ·
$0.19
Hmmm I need to learn a little Python so I can use this with my excel spreadsheets.
Thanks

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@shortsegments/re-geekgirl-3ms5zz)
πŸ‘  ,
πŸ‘Ž  
properties (23)
authorshortsegments
permlinkre-geekgirl-3ms5zz
categoryhive-167922
json_metadata{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@shortsegments/re-geekgirl-3ms5zz"}
created2022-04-12 09:48:54
last_update2022-04-12 09:48:54
depth1
children1
last_payout2022-04-19 09:48:54
cashout_time1969-12-31 23:59:59
total_payout_value0.096 HBD
curator_payout_value0.095 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length189
author_reputation672,716,973,429,599
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,224,830
net_rshares171,701,949,060
author_curate_reward""
vote details (3)
@geekgirl ·
$0.10
Just a little bit of python is enough. Not too complicated.
πŸ‘  
properties (23)
authorgeekgirl
permlinkra93u6
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 23:56:30
last_update2022-04-12 23:56:30
depth2
children0
last_payout2022-04-19 23:56:30
cashout_time1969-12-31 23:59:59
total_payout_value0.047 HBD
curator_payout_value0.048 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length59
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,244,962
net_rshares85,156,459,832
author_curate_reward""
vote details (1)
@typebox ·
$0.15
applications that helps in saving much time when doing tedious data tasks is really a blessing and Excel won’t be an exception. It’s nice learning of automated excel spreadsheets using OpenPyXL
πŸ‘  ,
properties (23)
authortypebox
permlinkra7tix
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-12 07:16:09
last_update2022-04-12 07:16:09
depth1
children0
last_payout2022-04-19 07:16:09
cashout_time1969-12-31 23:59:59
total_payout_value0.077 HBD
curator_payout_value0.076 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length193
author_reputation38,451,331,998,759
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,222,122
net_rshares138,637,150,239
author_curate_reward""
vote details (2)
@videoaddiction ·
$0.11
I don't use any of them with Excel. Nevertheless, It is obvious that it will save time for adding formulas, drawing charts and so on.
πŸ‘  
properties (23)
authorvideoaddiction
permlinkre-geekgirl-2022412t95426128z
categoryhive-167922
json_metadata{"tags":["hive-167922","python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.27-mobile","format":"markdown+html"}
created2022-04-12 06:54:27
last_update2022-04-12 06:54:27
depth1
children0
last_payout2022-04-19 06:54:27
cashout_time1969-12-31 23:59:59
total_payout_value0.056 HBD
curator_payout_value0.056 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length133
author_reputation166,194,025,312,295
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,221,785
net_rshares101,252,306,022
author_curate_reward""
vote details (1)
@worldstories ·
$0.15
it's very efficient for completing arithmetic operations and doesn't need third-party Microsoft
πŸ‘  ,
properties (23)
authorworldstories
permlinkre-geekgirl-2022412t675320z
categoryhive-167922
json_metadata{"tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-12 06:07:12
last_update2022-04-12 06:07:12
depth1
children0
last_payout2022-04-19 06:07:12
cashout_time1969-12-31 23:59:59
total_payout_value0.077 HBD
curator_payout_value0.076 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length95
author_reputation9,635,411,109,148
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,221,054
net_rshares138,871,436,542
author_curate_reward""
vote details (2)
@wrestlingdesires ·
>What are your thoughts on automating repetitive tasks? 

I'm all for that. As a human who has limited time and interest it just makes sense! Is there a way to use a similar process with .txt or .html files?
properties (22)
authorwrestlingdesires
permlinkre-geekgirl-2022412t15279337z
categoryhive-167922
json_metadata{"tags":["python","coding","dev","automating","data","programming","vyb","proofofbrain","neoxian","ctp","leofinance"],"app":"ecency/3.0.22-vision","format":"markdown+html"}
created2022-04-13 00:27:00
last_update2022-04-13 00:27:00
depth1
children1
last_payout2022-04-20 00:27:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length207
author_reputation202,688,216,355,345
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,245,593
net_rshares0
@geekgirl ·
Yes, it is a lot easier to work with and automate txt and html.
properties (22)
authorgeekgirl
permlinkrao7zi
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2022-04-21 03:50:06
last_update2022-04-21 03:50:06
depth2
children0
last_payout2022-04-28 03:50:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length63
author_reputation1,588,017,852,468,897
root_title"Automating Excel Spreadsheets With OpenPyXL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id112,486,319
net_rshares0