DEV Community

# excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to Process Large EXCEL File with Python Win32com

How to Process Large EXCEL File with Python Win32com

Comments
1 min read
Java Insert or Delete Rows and Columns in Excel Worksheet

Java Insert or Delete Rows and Columns in Excel Worksheet

4
Comments
4 min read
How to quickly delete duplicate rows in CSV, Excel, Markdown tables?

How to quickly delete duplicate rows in CSV, Excel, Markdown tables?

3
Comments
2 min read
Excelize 2.7.0 Released - Go language API for spreadsheets (Excel) files

Excelize 2.7.0 Released - Go language API for spreadsheets (Excel) files

5
Comments
5 min read
PowerBI -Getting started with one of the most powerful Visualisation tool!

PowerBI -Getting started with one of the most powerful Visualisation tool!

112
Comments 2
3 min read
Office Scripts (Typescript) in Excel

Office Scripts (Typescript) in Excel

5
Comments
5 min read
Easiest Ways to Highlight Data in Excel Using C#

Easiest Ways to Highlight Data in Excel Using C#

2
Comments
10 min read
Excel and Sheets. Is it time for a third alternative ?

Excel and Sheets. Is it time for a third alternative ?

2
Comments
1 min read
Excel Automation with RPA

Excel Automation with RPA

6
Comments
2 min read
Java - Add or Remove Cell Borders in Excel

Java - Add or Remove Cell Borders in Excel

2
Comments
4 min read
How to Master Excel Office Scripts

How to Master Excel Office Scripts

54
Comments
8 min read
Basic operations

Basic operations

4
Comments
2 min read
Django Sheet Upload

Django Sheet Upload

4
Comments
3 min read
Java: How to convert Excel to Word

Java: How to convert Excel to Word

2
Comments 2
6 min read
Java - Convert Excel Cell Value from Text to Number or Number to Text

Java - Convert Excel Cell Value from Text to Number or Number to Text

1
Comments
3 min read
Java - How to Create Pivot Tables in Excel

Java - How to Create Pivot Tables in Excel

Comments
5 min read
Java - How to Apply or Remove Data Validation in Excel

Java - How to Apply or Remove Data Validation in Excel

4
Comments
4 min read
Created a CLI tool to backup Slack export data in Excel

Created a CLI tool to backup Slack export data in Excel

Comments
2 min read
Java - Export Data from Database to Excel

Java - Export Data from Database to Excel

8
Comments
2 min read
Java - Insert, Edit or Delete Comments in Excel

Java - Insert, Edit or Delete Comments in Excel

1
Comments
4 min read
Are Office Scripts the new VBA?

Are Office Scripts the new VBA?

9
Comments
4 min read
Excelize 2.6.1 Released - Go language API for spreadsheets (Excel) files

Excelize 2.6.1 Released - Go language API for spreadsheets (Excel) files

6
Comments
3 min read
5️⃣ Free Excel-Like JS Libraries Used For Showing Big Data You Must Know 👨‍💻 A Thread 🧵

5️⃣ Free Excel-Like JS Libraries Used For Showing Big Data You Must Know 👨‍💻 A Thread 🧵

8
Comments
1 min read
How to build your own LinkedIn Profile Scraper in 2022

How to build your own LinkedIn Profile Scraper in 2022

14
Comments 2
6 min read
How To Export Data To Excel From Api Using ReactJS (incl. Custom Headers)

How To Export Data To Excel From Api Using ReactJS (incl. Custom Headers)

40
Comments 20
3 min read
The complete guide to managing translation projects with Excel

The complete guide to managing translation projects with Excel

10
Comments
4 min read
Is MS EXCEL A database management system ?

Is MS EXCEL A database management system ?

6
Comments 1
1 min read
Creating collabrative javascript spreadsheet made easy

Creating collabrative javascript spreadsheet made easy

15
Comments
3 min read
Insert and Read Form Controls in Excel in Java

Insert and Read Form Controls in Excel in Java

6
Comments
4 min read
Create Excel-like javascript spreadsheet in less than 10 lines of code

Create Excel-like javascript spreadsheet in less than 10 lines of code

63
Comments 10
2 min read
Excelize 2.6.0 Released - Go language API for spreadsheets (Excel) files

Excelize 2.6.0 Released - Go language API for spreadsheets (Excel) files

10
Comments
4 min read
Easily Create New Bulk Work Items From a Spreadsheet

Easily Create New Bulk Work Items From a Spreadsheet

5
Comments
6 min read
How to create bins with a monotonic weight of evidence trend in Excel

How to create bins with a monotonic weight of evidence trend in Excel

6
Comments
5 min read
Notes on Excel Dynamic Arrays

Notes on Excel Dynamic Arrays

6
Comments
3 min read
Java – How to Split a Worksheet into Multiple Sheets by Cell Ranges

Java – How to Split a Worksheet into Multiple Sheets by Cell Ranges

6
Comments
4 min read
How to combine and summarize excel/CSV files in Python?

How to combine and summarize excel/CSV files in Python?

3
Comments
2 min read
Did you know you can import data tables from any web page to Excel?

Did you know you can import data tables from any web page to Excel?

34
Comments 3
2 min read
Excelize 2.5.0 Released - Go language API for spreadsheets (Excel) files

Excelize 2.5.0 Released - Go language API for spreadsheets (Excel) files

5
Comments
4 min read
Excel - How to get a substring from a text

Excel - How to get a substring from a text

6
Comments
2 min read
Office Scripts : publish a serverless function from Excel365

Office Scripts : publish a serverless function from Excel365

1
Comments 2
6 min read
How to estimate value-at-risk given skewness and kurtosis in Excel

How to estimate value-at-risk given skewness and kurtosis in Excel

3
Comments
5 min read
How to estimate expected shortfall given skewness and kurtosis in Excel

How to estimate expected shortfall given skewness and kurtosis in Excel

3
Comments
5 min read
How to Create an Excel File in C#

How to Create an Excel File in C#

9
Comments
8 min read
Excel Automation with Python : Latitude and Longitude

Excel Automation with Python : Latitude and Longitude

11
Comments
4 min read
How to calculate accuracy ratio in Excel using only a formula

How to calculate accuracy ratio in Excel using only a formula

4
Comments
3 min read
How to perform logistic regression in Excel using only a formula

How to perform logistic regression in Excel using only a formula

5
Comments 1
4 min read
How to generate random numbers for Monte Carlo simulation in Excel

How to generate random numbers for Monte Carlo simulation in Excel

1
Comments
3 min read
Parsing and reading Excel binary data using Pandas

Parsing and reading Excel binary data using Pandas

7
Comments
3 min read
ExcelMerger-文創小農獨立手做 app 幫你合併 Excel 檔

ExcelMerger-文創小農獨立手做 app 幫你合併 Excel 檔

2
Comments
2 min read
Hide or Show Gridlines in Excel in Java

Hide or Show Gridlines in Excel in Java

3
Comments
1 min read
用 Python 寫 Excel 巨集

用 Python 寫 Excel 巨集

6
Comments
2 min read
Java: Add and Read Comments in Excel

Java: Add and Read Comments in Excel

5
Comments
2 min read
Print Excel Documents Using Java

Print Excel Documents Using Java

4
Comments
2 min read
Highlight Values Below or Above Average in Excel Using Java

Highlight Values Below or Above Average in Excel Using Java

3
Comments
2 min read
5th Anniversary of the Excelize Open Source 🎉

5th Anniversary of the Excelize Open Source 🎉

3
Comments
2 min read
How to use openpyxl: A python module for excel files

How to use openpyxl: A python module for excel files

8
Comments 2
4 min read
Add Borders to Cells in Excel Using Java

Add Borders to Cells in Excel Using Java

5
Comments
1 min read
Excelize 2.4.1 is Released

Excelize 2.4.1 is Released

16
Comments
3 min read
Excel como Base de Datos de lectura.

Excel como Base de Datos de lectura.

3
Comments
14 min read
Set Background Color and Image for Excel Using Java

Set Background Color and Image for Excel Using Java

6
Comments
2 min read
loading...