Soluții

Python – Reading an excel file using openpyxl module

Openpyxl is a Python library for reading and writing Excel (with extension xlsx/xlsm/xltx/xltm) files. The openpyxl module allows Python program to read and modify Excel files.

For example, user might have to go through thousands of rows and pick out few handful information to make small changes based on some criteria. Using Openpyxl module, these tasks can be done very efficiently and easily.

Use this command to install openpyxl module :

sudo pip3 install openpyxl
[mai mult...]

How to capture portions of your screen

If you’d rather be a little more precise with your screenshots, Windows 10 has a couple tools that can help you. Microsoft has rolled out this app called Snip & Sketch, replacing the old Snipping Tool, and it allows you to take screenshots in several different ways, as well as edit and annotate those screenshots.

Snip & Sketch gives you the option to take screenshots now or in a few seconds, if you need some time to prepare. Additionally, it will allow you to edit, crop and annotate existing screenshots, even the ones you haven’t taken with the app. To run the Snip & Sketch app, simply type “Snip & Sketch” into the Windows 10 search bar to find the app and launch it.

[mai mult...]

How to Pair Fitbit with Alexa

It doesn’t matter what kind of Fitbit you have. Whether you own a fitness band like the Fitbit Charge or a Fitbit smartwatch like the Versa 2, Fitbit and Alexa get along in the exact same way. You simply need to enable the Fitbit skill on the Alexa app. You don’t need to be wearing your Fitbit, and the Fitbit doesn’t even need to be charged.

[mai mult...]