teleren/devto huggingface dataset:
Java Delete Blank Rows and Columns in Excel
Published: 2020-09-24 08:58:59

When we are operating a Excel document that contains a large amount of data, some blank rows or columns may appear due to the modification of the data. At this time, we can use Free Spire.XLS for Java to delete these blank rows and columns in the Excel worksheet in batches. In this article, I will share the Java code used.

**Installation**
**Method 1:** Download the [Free Spire.XLS for Java](https://www.e-iceblue.com/Download/xls-for-java-free.html) and unzip it. Then add the Spire.Xls.jar file to your project as dependency.

**Method 2:** You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

```xml
<repositories>
        <repository>
            <id>com.e-iceblue</id>
            <name>e-iceblue</name>
            <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
        </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>2.2.0</version>
    </dependency>
</dependencies>

```


**The Original Excel Document:**

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/bp7scnkqdfflrg9ejmsx.jpg)


**Delete Blank Rows and Columns:**

```java
import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class MergeCells {
    public static void main(String[] args){
        //Create a Workbook instance
        Workbook workbook = new Workbook();
        //Load the Excel file
        workbook.loadFromFile("test1.xlsx");

        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);
        //Merge cells by range
        sheet.getRange().get("A1:C1").merge();

        //Save the resultant file
        workbook.saveToFile("MergeCells.xlsx", FileFormat.Version2013);
    }
}
```

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/h16b7fvtywkwct9azywv.jpg)
ENTRYPOINT vs. CMD: The Dockerfile Dilemma
Tags: docker, devops, linux
Published: 2020-09-24 13:25:05

Since I started using Docker ages ago, I occasionally come across blog posts or videos telling in details how the two are different, but failing to explain how and when to use them

### With enough experience...
you quickly realise that each instruction helps in different situations.

### The best use for ENTRYPOINT is...
to set the image's main command. Are you running the image as though it was a command? Then **ENTRYPOINT** is the right choice. In addition to that, you can use **CMD** to provide additional command line arguments.

For example: you can package the `dig` command to run DNS queries with this **Dockerfile**:
```
FROM ubuntu:18.04

RUN apt-get update &&\
        apt-get install -qqy --no-install-recommends dnsutils

ENTRYPOINT ["dig"]

CMD ["--help"]
```

Notice that I have provided `--help` as default command line parameter for the container, this way, if none is provided, we the container displays the help page. (Because you have to love your users, don't you? 🙂)

If you now build and tag your image as `dig:latest`, you can run DNS queries with ease from any operating system!

```
# On your Windows or MacOs

❯ docker run dig google.com

; <<>> DiG 9.11.3-1ubuntu1.13-Ubuntu <<>> google.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 7619
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;google.com.			IN	A

;; ANSWER SECTION:
google.com.		377	IN	A	172.217.23.142

;; Query time: 55 msec
;; SERVER: 192.168.65.1#53(192.168.65.1)
;; WHEN: Thu Sep 24 12:51:14 UTC 2020
;; MSG SIZE  rcvd: 44
```
AWESOME! 🔥

### Forget about ENTRYPOINT...
when your container's users are not already familiar with how the ENTRYPOINT works! It's easy to get fancy by adding magic tricks at container startup, but avoid hiding nasty logic at all costs!

### Use CMD for...
**everything else!** When in doubt, I always use the plain and simple **CMD**. And if you're not sure what your container should do by default, just give your users a Shell to work with, as simple as that.
```
CMD ["bash"]
```

### What do you think?
I'm curious to know how you use ENTRYPOINT and CMD in your Dockerfiles!

Thanks for reading! And don't forget to follow me if you want to see more content like this!

- [YouTube](https://bit.ly/3hTkyWU) 🎬
- [Twitter](https://twitter.com/castellinmanuel)
- [LinkedIn](https://www.linkedin.com/in/castellinmanuel/)
Webinar: Building a dashboard from a REST API in UI Bakery
Tags: webdev, uiweekly, lowcode, dashboard
Published: 2020-09-24 13:15:21

Hey everyone!

When: Sep 29 (Tue), 7 pm (CET), 1 pm (EST).
What: A free webinar on building a dashboard from a REST API in UI Bakery.
What exactly: From frontend creation to API connection & app deployment and hosting performed right in the platform.

Would be happy to see you there, sign up -> https://share.hsforms.com/1oMV1Ka23Sca_jSqKRP2XpQ1gk6e?utm_campaign=ui_bakery%20-%20webinar_REST%20API%20-%20xx%20-%20cacq%20-%20xx%20-%20check-in&utm_source=DevTo&utm_medium=general&utm_content=SN_post
On .NET Episode: Securing Services with MSAL
Tags: dotnet, aspnet, azure, security
Published: 2020-09-24 13:11:13

It's common for web, desktop, or even mobile applications to require access to protected resources in their environment. This may be custom Web APIs, Microsoft Graph or some other third-party service.

In the episode, Principal PM Kyle Marsh joins Christos to give us a better understanding on how we can use Microsoft Authentication Library (MSAL) to secure our daemon services with the OAuth 2.0 client credentials flow.


{% youtube 0Je4IzyLqG0 %}

If you liked this video and would like to see some more of our .NET content, please subscribe to our [.NET Developers YouTube Channel](https://www.youtube.com/channel/UCvtT19MZW8dq5Wwfu6B0oxw).


## Useful Links
<ul>
<li><a href="https://docs.microsoft.com/azure/active-directory/develop/msal-overview?WT.mc_id=ondotnet-c9-cephilli" target="_blank">Overview of Microsoft Authentication Library (MSAL)</a></li>
<li><a href="https://docs.microsoft.com/azure/active-directory/develop/v2-oauth2-client-creds-grant-flow?WT.mc_id=ondotnet-c9-cephilli" target="_blank">Microsoft identity platform and the OAuth 2.0 client credentials flow</a></li>
<li><a href="https://docs.microsoft.com/azure/active-directory/develop/quickstart-v2-netcore-daemon?WT.mc_id=ondotnet-c9-cephilli" target="_blank">Acquire a token and call Microsoft Graph API using console app's identity</a></li>
<li><a href="https://github.com/azure-samples/active-directory-dotnetcore-daemon-v2?WT.mc_id=ondotnet-c9-cephilli" target="_blank">Client Credentials grant sample code</a></li>
</ul>
We Are TekMutants
Tags: tekmutants
Published: 2020-09-24 13:06:42

<p style="text-align: justify;">We offer out of the box enterprise &ndash; level IT consulting services to automate business processes and operations, Hire TekMutants to empower your business model with the latest&nbsp;<a href="https://www.tekmutants.com/ecommerce-solutions/">eCommerce development</a>, <a href="https://www.tekmutants.com/services/mobile-application-development/" target="_blank">Mobile Application Development</a><span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Mobile App Development&quot;}" data-sheets-userformat="{&quot;2&quot;:26685,&quot;3&quot;:{&quot;1&quot;:0,&quot;3&quot;:1},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:[null,2,0]},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;14&quot;:{&quot;1&quot;:3,&quot;3&quot;:1},&quot;16&quot;:11,&quot;17&quot;:1}">,&nbsp;</span>web innovation, and business intelligence.</p>
<p style="text-align: justify;">We&rsquo;r a dynamic team comprising creative, innovative and futuristic approached heads, We help companies with digital transformation and enable them to address diverse strategic and technology challenges</p>
<p style="text-align: justify;">We Are <a href="https://www.tekmutants.com/" target="_blank">TekMutants</a></p>
شركة الرحاب للخدمات العامة بالرياض
Tags: security, clean, pest, control
Published: 2020-09-24 12:36:19


حيث النظافة هي أن عنوان بيتك ونظافتها تدل عليك لذلك يهتم العملاء بنظافتها
وغسيلها بشكل دوري لكن ذلك يحتاج إلي شركة متخصصة حتي تتم النظافة علي أكمل وجة.
نستخدم في شركة ماكينات تنظيف تحافظ علي القماش الخارجي للمجلس
وتجعلة يبدو كالجديد تماما لأنها تعمل علي ضخ المياه وشفط
ولذلك عمليات الشفط امر مهم لان مع الشفط يتم سحب الاوساخ والاتربه


<a href="https://www.elr7ab.com/cleaning-company-riyadh/" >شركة تنظيف بالرياض</a>
<a href="https://www.elr7ab.com/pest-control-company-riyadh/" >شركة مكافحة حشرات بالرياض</a>
<a href="https://www.elr7ab.com/furniture-transfer-company-riyadh/" >شركة نقل اثاث بالرياض</a>
Learn Power BI From Mindmajix
Published: 2020-09-24 12:33:21

Mindmajix is organizing a free demo for Power online BI Course.This demo is for the  We provide the best online training classes to help you learn Power BI architecture, Desktop, Service, Mobile Apps, Visualizations, Reports, and deriving business insights. As part of this program, you will work on real-world projects.
<a href="https://mindmajix.com/power-bi-training">Learn Power BI</a>from Mindmajix:
What will you learn in this Power BI Course?

Get an in-depth understanding of Power BI and how it works in different scenarios
Three vital components: Desktop, Service and Mobile apps
Visualize and analyze data and derive insights from Excel spreadsheet or local database
Create compelling reports and visualizations, derive real-time insights and deploy it on demand
Create, share, collaborate and benefit from business information with purpose-built dashboards
Get the work done without being a Business Intelligence professional
Use Salesforce Data, Azure SQL Database and SQL server analysis tabular data
Deploy content packs to work with Quick Books online and Adobe analytics
Work on live projects on Power BI to get hands-on experienceWho can join the Power BI Training and Power BI Certification?

Individuals looking for jobs as Business Analysts, Business Development Manager, etc.
Statisticians aiming to implement their statistics skill to derive business insights
Marketing, Finance, Sales, and other domain Professionals who need extensive business intelligene
Create a Simple React with Redux
Tags: react, reactnative, javascript, webdev
Published: 2020-09-24 12:31:45

{% codesandbox create-a-simple-react-with-redux-yz95j %}
Youtube demo:
{% youtube WcfjruGzQ9w %}
The Article : [Create a Simple React with Redux](https://hoanguyenit.com/create-a-simple-react-with-redux.html)
Please do like it and [Subscribe]
(https://www.youtube.com/channel/UCBOZRctXJSg9YNLyddedASg?sub_confirmation=1) to my channel for more videos.
Create Todo Application using React
Tags: react, reactnative, javascript, webdev
Published: 2020-09-24 12:29:20

{% youtube 0QYWGxru9a0 %}
The Article : [Create Todo Application using React](https://hoanguyenit.com/create-todo-application-using-react.html)
Please do like it and [Subscribe]
(https://www.youtube.com/channel/UCBOZRctXJSg9YNLyddedASg?sub_confirmation=1) to my channel for more videos.
Create CRUD in React
Tags: javascript, react, reactnative, webdev
Published: 2020-09-24 12:26:48

{% youtube FHnUr_YAtm0 %}
The Article : [Create CRUD in React](https://hoanguyenit.com/create-crud-in-react.html)
Please do like it and [Subscribe]
(https://www.youtube.com/channel/UCBOZRctXJSg9YNLyddedASg?sub_confirmation=1) to my channel for more videos.
Redux VS Context API
Published: 2020-09-24 12:25:11

I am very familiar with Context API, I completed a crash course with Redux and they both appear alike (in principle) to me. The question is, which one should I focus on? What are the major Pros and Cons between Context API and Redux?. Which is best in React State management.

https://stackoverflow.com/questions/64046369/redux-vs-context-api
URL Router in React
Tags: react, reactnative, javascript, webdev
Published: 2020-09-24 12:23:48

{% youtube LlNCMiM8FR8 %}
The Article : [URL Router in React](https://hoanguyenit.com/url-router-in-react.html)
Please do like it and [Subscribe]
(https://www.youtube.com/channel/UCBOZRctXJSg9YNLyddedASg?sub_confirmation=1) to my channel for more videos.
Render Data in React
Tags: react, reactnative, javascript, webdev
Published: 2020-09-24 12:20:29

{% youtube f5d6dnpy5yI %}
The Article : [Render Data in React](https://hoanguyenit.com/render-data-in-react.html)
Please do like it and [Subscribe]
(https://www.youtube.com/channel/UCBOZRctXJSg9YNLyddedASg?sub_confirmation=1) to my channel for more videos.
nodename and hostname in ansible
Tags: ansible
Published: 2020-09-24 12:15:50


-   inventory_hostname is the hostname as it is set in your Ansible inventory. For example www.internal-name.example.
-   ansible_hostname is the unqualified hostname as reported by the system. For example www.
-   ansible_nodename is the fully qualified hostname as reported by the system. For example www.example.com.
All you need to know about cediland
Tags: news, gossip, ghana, entertainment
Published: 2020-09-24 12:14:11

Cediland.net is the No. 1 Best Ghanaian Forum that covers Entertainment, News, Gossips, Technology News and More. 

Cediland allows users to share their views on what is happening in their locality and also to socialize with one another.

Cediland welcomes everyone from all ethnic groups to interact with people all over the world.

To know more, kindly visit [Cediland](https://www.cediland.net)
Website erstellen für passives Einkommen - Teil 1: Project 24
Tags: wordpress, bloggen, einkommen, websiteerstellen
Published: 2020-10-05 15:09:08

---
title: Website erstellen für passives Einkommen - Teil 1: Project 24
published: true
date: 2020-09-24 12:13:00 UTC
tags: Wordpress,bloggen,einkommen,websiteerstellen
canonical_url: https://j0e.org/website-erstellen/
---

![Website erstellen](https://j0e.org/wp-content/uploads/2020/09/website-erstellen.png)

    In dieser Artikelserie werde ich eine neue Website erstellen, mit der ich ein passives Einkommen …

[Website erstellen für passives Einkommen - Teil 1: Project 24 Weiter Lesen »](https://j0e.org/website-erstellen/)
small error related to quote and indent in ansible playbook loop
Tags: ansible
Published: 2020-09-24 12:03:44

```
- name: set name resolve                                                                                                                                                                                         
    blockinfile:                                                                                                                                                                                                   
      path: /etc/hosts                                                                                                                                                                                             
      block: |                                                                                                                                                                                                     
        {{ hostvars[item]['ansible_facts']['eth1']['ipv4']['address'] }} cluster-endpoint                                                                                                                          
      loop: "{{ groups[master] }}" 
```

> The task includes an option with an undefined variable. The error was: 'master' is undefined

```
- name: set name resolve                                                                                                                                                                                         
    blockinfile:                                                                                                                                                                                                   
      path: /etc/hosts                                                                                                                                                                                             
      block: |                                                                                                                                                                                                     
        {{ hostvars[item]['ansible_facts']['eth1']['ipv4']['address'] }} cluster-endpoint                                                                                                                          
      loop: "{{ groups[`master`] }}" 
```
> The task includes an option with an undefined variable. The error was: 'item' is undefined

the indent level of loop directive is wrong


在 `{{ }}` 中，字符串（非变量名，filter 名，test名）需要引用起来，以与变量名区分
Time to Free up Space on Ubuntu.
Tags: 100daysofcode, linux
Published: 2020-09-24 12:03:03

Out of Space? Welcome to the club. Time for some space hunt. Here are some techniques that came through for me, today. You might want to start with the last one, it will save you so much work. 

* Remove all unused packages.
```
sudo apt-get autoremove
```
* Clear the APT cache. 

Check the cache size:
```
sudo du -sh /var/cache/apt 
```
Clear cache
```
sudo apt-get clean
```
* Clear systemd journal logs. This freed up a good amount of space.

Check the space occupied:
```
journalctl --disk-usage
```
Clean out some logs. You might want to read about this:  [Clearing systemd journal logs in linux](https://linuxhandbook.com/clear-systemd-journal-logs/). But if you are in dire need of space and have no time, use the command below. It will clear all the logs older than 2 days.
```
sudo journalctl --vacuum-time=2d
```
* Remove older versions of Snap applications
Check the space occupied
```
du -h /var/lib/snapd/snaps
```
Create a script file, add the lines below, and save. I saved mine as script.sh on Home directory.
```script
set -eu
snap list --all | awk '/disabled/{print $1, $3}' |
    while read snapname revision; do
        snap remove "$snapname" --revision="$revision"
    done
```
Give the file execute permissions
```
chmod 0700 script.sh
```
Run the script to remove older packages.
```
sudo ./script.sh
```
* Uninstall apps you don't use. Stop saving them for the future! Easy for me to say but this was hard for me. I resorted to deleting everything I haven't used in the past two months, or anything with an online alternative. 

All the above freed up about 3 to 4 GB, then came the mother of all space eaters, my trash! Quite embarrassing and funny cause I did not think of the trash at all until I installed Stacer and the analytics were screaming at me: Take out the trash! 

* Install Stacer and let the system cleaner do the work for you. 
You can search ubuntu software or use the command below to install.
```
 sudo apt install stacer
```
_That's it for day 70: 100 days of code_
_Lets do this again tommorrow_
Daily Developer Jokes - Thursday, Sep 24, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-09-24 12:00:11

---
title: "Daily Developer Jokes - Thursday, Sep 24, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Thursday%2C%20Sep%2024%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e12590a84b94.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ What are computers' favorite snacks?

___A:___ Microchips, phish sticks, and cookies. But just a few bytes of each.
 -->
S1E10: Does XR have a Chicken and Egg problem?
Published: 2020-11-18 00:41:32

---
title: S1E10: Does XR have a Chicken and Egg problem?
published: true
date: 2020-09-24 12:00:00 UTC
tags: 
canonical_url: https://anchor.fm/xrseapod/episodes/S1E10-Does-XR-have-a-Chicken-and-Egg-problem-ek3dfh
---

We all know that content is king. But is the killer app the solution for mass adoption of VR? Or is there still a technology gap that needs to be filled before content can take off? Join us in this episode where Nirav, Vinay, and Kirby discuss and debate, does XR have a Chicken and Egg problem? Would love to hear your thoughts too. Tweet and tag us @xrseapod

--- Send in a voice message: https://anchor.fm/xrseapod/message
Stellvertretend
Tags: revolution, carless, traffic
Published: 2020-09-24 11:57:00

Das [hier](https://www.spiegel.de/panorama/a4-bei-landshut-autotransporter-mit-neufahrzeugen-brennt-vollstaendig-aus-a-1429ca2a-f692-4b7a-b719-37c8f0beb92b) waren wir wirklich nicht. Ehrlich. Aber wir wären es gerne gewesen. (Vielleicht sollten wir einfach proaktiv ein Bekennerschreiben dazu veröffentlichen?)

Bonzenkarren müssen sterben. **Eat the rich!**
Everything you need to know about 247acemedia
Tags: news, ghana, nigeria, entertainment
Published: 2020-09-24 11:56:28

247acemedia is a blog created with the aim of bringing latest Gossip, Entertainment, Politics, Lifestyle, Fashion,News and much more to its blog readers around the globe. We try our best to source for latest news and happenings to feed our users so they can be satisfied.

Visit [247acemedia](https://www.247acemedia.com) for more information.