DEV Community

# excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Comprehensive Apache POI Tutorial: Excel File Handling in Java

Comprehensive Apache POI Tutorial: Excel File Handling in Java

3
Comments
11 min read
Convert Blobs of Text into Rows in Excel Without Manual Work

Convert Blobs of Text into Rows in Excel Without Manual Work

Comments
2 min read
Fórmulas de Excel/Sheets que ni la IA puede resolver (aún)

Fórmulas de Excel/Sheets que ni la IA puede resolver (aún)

Comments
3 min read
Automate Excel and Google Sheets Tasks with Python (Practical Examples)

Automate Excel and Google Sheets Tasks with Python (Practical Examples)

1
Comments
1 min read
Python XLSX Reader Guide

Python XLSX Reader Guide

Comments
3 min read
Send Excel Rows as Individual Emails Automatically

Send Excel Rows as Individual Emails Automatically

Comments 1
5 min read
Excel for Predictive Analysis: Friend or Foe in Data-Driven Decisions?

Excel for Predictive Analysis: Friend or Foe in Data-Driven Decisions?

11
Comments
2 min read
📊 Building a Data Job Salary Dashboard in Excel: A Detailed Walkthrough

📊 Building a Data Job Salary Dashboard in Excel: A Detailed Walkthrough

Comments
3 min read
[Review] 20250620: The Plan to Supersede Excel

[Review] 20250620: The Plan to Supersede Excel

Comments
5 min read
How Do I Find Cell Contains Maximum or Minimum Values in Excel?

How Do I Find Cell Contains Maximum or Minimum Values in Excel?

1
Comments
4 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

Comments
2 min read
How to transform workflows from Excel to a project management tool

How to transform workflows from Excel to a project management tool

Comments
6 min read
Thought 20250530 Python in Excel

Thought 20250530 Python in Excel

Comments
1 min read
How Can You Reverse Signs of Cell Values in Excel?

How Can You Reverse Signs of Cell Values in Excel?

2
Comments
3 min read
3 bewährte Wege für den HTML-zu-Excel-Export

3 bewährte Wege für den HTML-zu-Excel-Export

Comments 1
1 min read
Fastest way to import excel into mysql

Fastest way to import excel into mysql

Comments
2 min read
Open Excel Spreadsheets Anywhere — No Software, No Signup

Open Excel Spreadsheets Anywhere — No Software, No Signup

Comments 1
1 min read
How Can You Convert an Angle Between Degrees and Radians in Excel?

How Can You Convert an Angle Between Degrees and Radians in Excel?

Comments
3 min read
How to import excel into mysql only 1 step

How to import excel into mysql only 1 step

Comments
2 min read
Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

4
Comments 3
4 min read
Excel File Options Shortcuts List & It’s Explanations!

Excel File Options Shortcuts List & It’s Explanations!

1
Comments
3 min read
How to Merge & Combine Columns without Losing Data in Excel?

How to Merge & Combine Columns without Losing Data in Excel?

2
Comments
4 min read
How to import Excel to MySQL

How to import Excel to MySQL

Comments
2 min read
How to Use a Formula to Convert Text to Sentence Case in Excel?

How to Use a Formula to Convert Text to Sentence Case in Excel?

Comments 1
3 min read
How to Use Excel YEAR Function?

How to Use Excel YEAR Function?

3
Comments
5 min read
loading...