DEV Community

# excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Is MS EXCEL A database management system ?

Is MS EXCEL A database management system ?

Reactions 4 Comments 1
1 min read
XNPV Function

XNPV Function

Reactions 2 Comments
2 min read
XIRR Function

XIRR Function

Reactions 3 Comments
2 min read
PMT(Periodic Payment For A Loan)

PMT(Periodic Payment For A Loan)

Reactions 4 Comments
2 min read
PPMT Function

PPMT Function

Reactions 6 Comments
2 min read
The complete guide to managing translation projects with Excel

The complete guide to managing translation projects with Excel

Reactions 10 Comments
4 min read
Add Traffic Lights Icons to Excel in Java

Add Traffic Lights Icons to Excel in Java

Reactions 7 Comments
2 min read
NPV Function

NPV Function

Reactions 9 Comments
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

Reactions 8 Comments
4 min read
Creating collabrative javascript spreadsheet made easy

Creating collabrative javascript spreadsheet made easy

Reactions 14 Comments
3 min read
Free Online Courses To Master MS Excel

Free Online Courses To Master MS Excel

Reactions 4 Comments
2 min read
Insert and Read Form Controls in Excel in Java

Insert and Read Form Controls in Excel in Java

Reactions 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

Reactions 59 Comments 9
2 min read
Easily Create New Bulk Work Items From a Spreadsheet

Easily Create New Bulk Work Items From a Spreadsheet

Reactions 5 Comments
6 min read
Lock Specific Cells in Excel Using Java

Lock Specific Cells in Excel Using Java

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

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

Reactions 3 Comments
2 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

Reactions 6 Comments
5 min read
Notes on Excel Dynamic Arrays

Notes on Excel Dynamic Arrays

Reactions 6 Comments
3 min read
Wrap or Unwrap Text in Excel Cells in Java

Wrap or Unwrap Text in Excel Cells in Java

Reactions 4 Comments
2 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

Reactions 5 Comments
4 min read
Add Data Table to Excel Chart Using Java

Add Data Table to Excel Chart Using Java

Reactions 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?

Reactions 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

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

Excel - How to get a substring from a text

Reactions 6 Comments
2 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

Reactions 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

Reactions 3 Comments
5 min read
Java/ Get Cell Values by Cell Names in Excel

Java/ Get Cell Values by Cell Names in Excel

Reactions 6 Comments
2 min read
How to Create an Excel File in C#

How to Create an Excel File in C#

Reactions 6 Comments
8 min read
Java/ Convert PDF to Excel

Java/ Convert PDF to Excel

Reactions 5 Comments
2 min read
Excel Automation with Python : Latitude and Longitude

Excel Automation with Python : Latitude and Longitude

Reactions 7 Comments
4 min read
Java/ Add Image Comments to Excel

Java/ Add Image Comments to Excel

Reactions 3 Comments
2 min read
How to calculate accuracy ratio in Excel using only a formula

How to calculate accuracy ratio in Excel using only a formula

Reactions 3 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

Reactions 5 Comments
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

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

Parsing and reading Excel binary data using Pandas

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

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

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

Hide or Show Gridlines in Excel in Java

Reactions 3 Comments
1 min read
用 Python 寫 Excel 巨集

用 Python 寫 Excel 巨集

Reactions 5 Comments
2 min read
Java: Add and Read Comments in Excel

Java: Add and Read Comments in Excel

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

5th Anniversary of the Excelize Open Source 🎉

Reactions 3 Comments
2 min read
Print Excel Documents Using Java

Print Excel Documents Using Java

Reactions 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

Reactions 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

Reactions 8 Comments 2
4 min read
Create, View, Edit and Save Your Excel Files Using WPF Spreadsheet

Create, View, Edit and Save Your Excel Files Using WPF Spreadsheet

Reactions 4 Comments
6 min read
Add Borders to Cells in Excel Using Java

Add Borders to Cells in Excel Using Java

Reactions 5 Comments
1 min read
Excelize 2.4.1 is Released

Excelize 2.4.1 is Released

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

Excel como Base de Datos de lectura.

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

Set Background Color and Image for Excel Using Java

Reactions 6 Comments
2 min read
Apply Different Font Styles in Excel Using Java

Apply Different Font Styles in Excel Using Java

Reactions 2 Comments
2 min read
Dominate MS Office Reporting With Python Part2

Dominate MS Office Reporting With Python Part2

Reactions 5 Comments
5 min read
Highlight Highest and Lowest Value in Excel Using Java

Highlight Highest and Lowest Value in Excel Using Java

Reactions 6 Comments
2 min read
How to Export Data from Excel to DataTable with Customization in C#

How to Export Data from Excel to DataTable with Customization in C#

Reactions 3 Comments
8 min read
Sort Excel Data Using Java

Sort Excel Data Using Java

Reactions 6 Comments
1 min read
7 tips to automate your daily DWH/BI developer life using PowerShell and Excel

7 tips to automate your daily DWH/BI developer life using PowerShell and Excel

Reactions 6 Comments 2
3 min read
Làm thế nào để tìm lại những trang web hay mà mình đã từng truy cập

Làm thế nào để tìm lại những trang web hay mà mình đã từng truy cập

Reactions 2 Comments
3 min read
AspNet Core 5 Reading and Exporting Excel

AspNet Core 5 Reading and Exporting Excel

Reactions 15 Comments 1
4 min read
Create MS Project converter for .NET 5.0 in 5 steps

Create MS Project converter for .NET 5.0 in 5 steps

Reactions 11 Comments 1
2 min read
Set Row Height and Column Width in Excel using a free Java API

Set Row Height and Column Width in Excel using a free Java API

Reactions 6 Comments
1 min read
Excelize 2.4.0 is Released – New support 152 formula functions

Excelize 2.4.0 is Released – New support 152 formula functions

Reactions 8 Comments
4 min read
Highlight Dulicate and Unique Values in Excel using Java

Highlight Dulicate and Unique Values in Excel using Java

Reactions 5 Comments
2 min read
loading...