DEV Community

# excel

Posts

ūüĎč Sign in for the ability sort posts by top and latest.
Java/ Convert PDF to Excel

Java/ Convert PDF to Excel

Reactions 2 Comments
2 min read
Java/ Add Image Comments to Excel

Java/ Add Image Comments to Excel

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

Excel Automation with Python : Latitude and Longitude

Reactions 4 Comments
4 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
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
Hide or Show Gridlines in Excel in Java

Hide or Show Gridlines in Excel in Java

Reactions 3 Comments
1 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 12 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
Dominate MS Office Reporting with Python part1

Dominate MS Office Reporting with Python part1

Reactions 2 Comments
7 min read
Pixel art in Excel

Pixel art in Excel

Reactions 6 Comments
2 min read
Fixing a 40-year-old Software Bug

Fixing a 40-year-old Software Bug

Reactions 26 Comments 4
6 min read
Create Pivot Chart in Excel using Java

Create Pivot Chart in Excel using Java

Reactions 6 Comments
1 min read
Formatting Essential JavaScript Spreadsheet: Conditional Formatting

Formatting Essential JavaScript Spreadsheet: Conditional Formatting

Reactions 6 Comments
6 min read
Give your classic spreadsheet a modern touch

Give your classic spreadsheet a modern touch

Reactions 6 Comments
3 min read
How To Export Data To Excel From Api Using React

How To Export Data To Excel From Api Using React

Reactions 17 Comments 7
2 min read
Microsoft Excel is Now Turing Complete

Microsoft Excel is Now Turing Complete

Reactions 48 Comments 14
1 min read
Set Number Format in Excel using Java

Set Number Format in Excel using Java

Reactions 6 Comments
2 min read
JXLS: How to generate Excel documents using templates?

JXLS: How to generate Excel documents using templates?

Reactions 3 Comments 2
5 min read
Create Excel file using Perl from JSON data

Create Excel file using Perl from JSON data

Reactions 9 Comments 1
10 min read
How to explore ClickHouse data via Excel PivotTable using Mondrian

How to explore ClickHouse data via Excel PivotTable using Mondrian

Reactions 4 Comments 5
5 min read
E-Mail Automation with Python and Excel

E-Mail Automation with Python and Excel

Reactions 3 Comments
1 min read
Upload & Read Excel File in Node.js

Upload & Read Excel File in Node.js

Reactions 40 Comments
3 min read
Upload and Read Excel File in Node.js

Upload and Read Excel File in Node.js

Reactions 5 Comments
2 min read
Excelize 2.3.2 is Released ‚Äď Go library for spreadsheet (Excel) files

Excelize 2.3.2 is Released ‚Äď Go library for spreadsheet (Excel) files

Reactions 5 Comments
3 min read
The Challenge: Create a Spreadsheet from a React Application?

The Challenge: Create a Spreadsheet from a React Application?

Reactions 10 Comments
4 min read
3ÔłŹ‚É£ Websites to Convert Tables to JSON

3ÔłŹ‚É£ Websites to Convert Tables to JSON

Reactions 2 Comments
1 min read
Sort Data in Excel in Java

Sort Data in Excel in Java

Reactions 6 Comments 1
3 min read
The backend of the spreadsheet Luckysheet is also open source! Support online collaboration, one-click docker private deployment

The backend of the spreadsheet Luckysheet is also open source! Support online collaboration, one-click docker private deployment

Reactions 3 Comments
2 min read
Basics of openpyxl : A Python module for Excel files

Basics of openpyxl : A Python module for Excel files

Reactions 3 Comments
2 min read
Connecting to BigQuery From Excel and Python

Connecting to BigQuery From Excel and Python

Reactions 5 Comments
2 min read
Create Pivot Table and Pivot Chart in Excel in Java

Create Pivot Table and Pivot Chart in Excel in Java

Reactions 5 Comments
3 min read
DataGridView AutoFilter

DataGridView AutoFilter

Reactions 3 Comments
1 min read
Excel tips - lock column and row in formula

Excel tips - lock column and row in formula

Reactions 3 Comments
1 min read
Introducing CustomerTestsExcel

Introducing CustomerTestsExcel

Reactions 6 Comments
8 min read
Document conversion with zoom option

Document conversion with zoom option

Reactions 6 Comments
1 min read
How-to Avoid Rounding "Errors" in Excel

How-to Avoid Rounding "Errors" in Excel

Reactions 6 Comments 4
2 min read
loading...