Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
#
excel
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
How to calculate accuracy ratio in Excel using only a formula
Wynn Tee
Wynn Tee
Wynn Tee
Follow
for
Quantitative Risk Solutions PLT
Nov 15 '21
How to calculate accuracy ratio in Excel using only a formula
#
excel
#
risk
#
statistics
#
datascience
3
reactions
Comments
Add Comment
3 min read
How to perform logistic regression in Excel using only a formula
Wynn Tee
Wynn Tee
Wynn Tee
Follow
for
Quantitative Risk Solutions PLT
Nov 8 '21
How to perform logistic regression in Excel using only a formula
#
excel
#
risk
#
statistics
#
datascience
5
reactions
Comments
1
comment
4 min read
How to generate random numbers for Monte Carlo simulation in Excel
Wynn Tee
Wynn Tee
Wynn Tee
Follow
for
Quantitative Risk Solutions PLT
Oct 31 '21
How to generate random numbers for Monte Carlo simulation in Excel
#
excel
#
risk
#
datascience
#
montecarlo
1
reaction
Comments
Add Comment
3 min read
Parsing and reading Excel binary data using Pandas
Bruno Oliveira
Bruno Oliveira
Bruno Oliveira
Follow
Oct 23 '21
Parsing and reading Excel binary data using Pandas
#
python
#
pandas
#
excel
#
webdev
10
reactions
Comments
Add Comment
3 min read
ExcelMerger-文創小農獨立手做 app 幫你合併 Excel 檔
Leon
Leon
Leon
Follow
Oct 19 '21
ExcelMerger-文創小農獨立手做 app 幫你合併 Excel 檔
#
excel
#
tauri
#
python
#
svelte
2
reactions
Comments
Add Comment
2 min read
Hide or Show Gridlines in Excel in Java
CodeSharing
CodeSharing
CodeSharing
Follow
Oct 18 '21
Hide or Show Gridlines in Excel in Java
#
java
#
excel
#
api
3
reactions
Comments
Add Comment
1 min read
用 Python 寫 Excel 巨集
Leon
Leon
Leon
Follow
Oct 18 '21
用 Python 寫 Excel 巨集
#
python
#
excel
5
reactions
Comments
Add Comment
2 min read
Java: Add and Read Comments in Excel
CodeSharing
CodeSharing
CodeSharing
Follow
Oct 11 '21
Java: Add and Read Comments in Excel
#
java
#
excel
#
comments
#
api
5
reactions
Comments
Add Comment
2 min read
5th Anniversary of the Excelize Open Source 🎉
xuri
xuri
xuri
Follow
Aug 31 '21
5th Anniversary of the Excelize Open Source 🎉
#
go
#
excel
#
xlsx
3
reactions
Comments
Add Comment
2 min read
Print Excel Documents Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Sep 13 '21
Print Excel Documents Using Java
#
java
#
excel
#
print
4
reactions
Comments
Add Comment
2 min read
Highlight Values Below or Above Average in Excel Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Sep 1 '21
Highlight Values Below or Above Average in Excel Using Java
#
java
#
excel
#
api
3
reactions
Comments
Add Comment
2 min read
How to use openpyxl: A python module for excel files
Shijo Shaji
Shijo Shaji
Shijo Shaji
Follow
Aug 21 '21
How to use openpyxl: A python module for excel files
#
python
#
openpyxl
#
basics
#
excel
8
reactions
Comments
2
comments
4 min read
Create, View, Edit and Save Your Excel Files Using WPF Spreadsheet
Suresh Mohan
Suresh Mohan
Suresh Mohan
Follow
for
Syncfusion, Inc.
Aug 10 '21
Create, View, Edit and Save Your Excel Files Using WPF Spreadsheet
#
excel
#
spreadsheet
#
wpf
#
productivity
4
reactions
Comments
Add Comment
6 min read
Add Borders to Cells in Excel Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Aug 11 '21
Add Borders to Cells in Excel Using Java
#
java
#
excel
#
border
5
reactions
Comments
Add Comment
1 min read
Excelize 2.4.1 is Released
xuri
xuri
xuri
Follow
Aug 1 '21
Excelize 2.4.1 is Released
#
go
#
excel
#
xlsx
16
reactions
Comments
Add Comment
3 min read
Excel como Base de Datos de lectura.
Code Chappie
Code Chappie
Code Chappie
Follow
Jul 27 '21
Excel como Base de Datos de lectura.
#
database
#
excel
#
api
#
spreadsheets
3
reactions
Comments
Add Comment
14 min read
Set Background Color and Image for Excel Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Jun 28 '21
Set Background Color and Image for Excel Using Java
#
java
#
excel
#
background
6
reactions
Comments
Add Comment
2 min read
Apply Different Font Styles in Excel Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Jun 21 '21
Apply Different Font Styles in Excel Using Java
#
java
#
excel
#
front
#
api
2
reactions
Comments
Add Comment
2 min read
Dominate MS Office Reporting With Python Part2
as3fn
as3fn
as3fn
Follow
Jun 8 '21
Dominate MS Office Reporting With Python Part2
#
python
#
excel
#
powerpint
#
datascience
5
reactions
Comments
Add Comment
5 min read
Highlight Highest and Lowest Value in Excel Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Jun 4 '21
Highlight Highest and Lowest Value in Excel Using Java
#
java
#
excel
6
reactions
Comments
Add Comment
2 min read
How to Export Data from Excel to DataTable with Customization in C#
Suresh Mohan
Suresh Mohan
Suresh Mohan
Follow
for
Syncfusion, Inc.
Jun 2 '21
How to Export Data from Excel to DataTable with Customization in C#
#
csharp
#
dotnet
#
excel
#
productivity
3
reactions
Comments
Add Comment
8 min read
Sort Excel Data Using Java
CodeSharing
CodeSharing
CodeSharing
Follow
May 31 '21
Sort Excel Data Using Java
#
java
#
sortdata
#
excel
6
reactions
Comments
Add Comment
1 min read
7 tips to automate your daily DWH/BI developer life using PowerShell and Excel
rgogloza
rgogloza
rgogloza
Follow
May 25 '21
7 tips to automate your daily DWH/BI developer life using PowerShell and Excel
#
powershell
#
excel
#
automation
6
reactions
Comments
2
comments
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
nguyên
nguyên
nguyên
Follow
Apr 27 '21
Làm thế nào để tìm lại những trang web hay mà mình đã từng truy cập
#
python
#
excel
#
chrome
#
pandas
2
reactions
Comments
Add Comment
3 min read
AspNet Core 5 Reading and Exporting Excel
Mohamad Lawand
Mohamad Lawand
Mohamad Lawand
Follow
Apr 28 '21
AspNet Core 5 Reading and Exporting Excel
#
dotnet
#
csharp
#
excel
18
reactions
Comments
1
comment
4 min read
Create MS Project converter for .NET 5.0 in 5 steps
Alexander Efremov
Alexander Efremov
Alexander Efremov
Follow
Apr 16 '21
Create MS Project converter for .NET 5.0 in 5 steps
#
csharp
#
netcore
#
msproject
#
excel
11
reactions
Comments
1
comment
2 min read
Set Row Height and Column Width in Excel using a free Java API
CodeSharing
CodeSharing
CodeSharing
Follow
Apr 20 '21
Set Row Height and Column Width in Excel using a free Java API
#
java
#
excel
#
column
#
api
6
reactions
Comments
Add Comment
1 min read
Excelize 2.4.0 is Released – New support 152 formula functions
xuri
xuri
xuri
Follow
Apr 18 '21
Excelize 2.4.0 is Released – New support 152 formula functions
#
go
#
excel
#
xlsx
8
reactions
Comments
Add Comment
4 min read
Highlight Dulicate and Unique Values in Excel using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Mar 31 '21
Highlight Dulicate and Unique Values in Excel using Java
#
java
#
highlight
#
excel
#
api
5
reactions
Comments
Add Comment
2 min read
Dominate MS Office Reporting with Python part1
as3fn
as3fn
as3fn
Follow
Mar 24 '21
Dominate MS Office Reporting with Python part1
#
python
#
excel
#
powerpoint
#
datascience
2
reactions
Comments
Add Comment
7 min read
Pixel art in Excel
Alex Antsiferov
Alex Antsiferov
Alex Antsiferov
Follow
Mar 21 '21
Pixel art in Excel
#
excel
#
vba
#
bgr
6
reactions
Comments
Add Comment
2 min read
Fixing a 40-year-old Software Bug
Ovid
Ovid
Ovid
Follow
Mar 16 '21
Fixing a 40-year-old Software Bug
#
bug
#
excel
#
history
#
etl
26
reactions
Comments
4
comments
6 min read
Create Pivot Chart in Excel using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Mar 12 '21
Create Pivot Chart in Excel using Java
#
java
#
excel
#
pivotchart
6
reactions
Comments
Add Comment
1 min read
Give your classic spreadsheet a modern touch
Hawk Chen
Hawk Chen
Hawk Chen
Follow
Mar 4 '21
Give your classic spreadsheet a modern touch
#
spreadsheet
#
web
#
excel
#
java
5
reactions
Comments
Add Comment
3 min read
How To Export Data To Excel From Api Using React
Jasur Kurbanov
Jasur Kurbanov
Jasur Kurbanov
Follow
Feb 22 '21
How To Export Data To Excel From Api Using React
#
react
#
javascript
#
excel
#
api
25
reactions
Comments
17
comments
2 min read
Microsoft Excel is Now Turing Complete
Ben Halpern
Ben Halpern
Ben Halpern
Follow
Feb 10 '21
Microsoft Excel is Now Turing Complete
#
news
#
microsoft
#
excel
48
reactions
Comments
14
comments
1 min read
Set Number Format in Excel using Java
CodeSharing
CodeSharing
CodeSharing
Follow
Feb 9 '21
Set Number Format in Excel using Java
#
java
#
excel
#
free
6
reactions
Comments
Add Comment
2 min read
JXLS: How to generate Excel documents using templates?
Andres Sacco
Andres Sacco
Andres Sacco
Follow
Feb 3 '21
JXLS: How to generate Excel documents using templates?
#
java
#
excel
#
report
#
library
4
reactions
Comments
6
comments
5 min read
Create Excel file using Perl from JSON data
Gaurav Rai
Gaurav Rai
Gaurav Rai
Follow
Feb 2 '21
Create Excel file using Perl from JSON data
#
perl
#
automation
#
excel
#
tutorial
9
reactions
Comments
1
comment
10 min read
How to explore ClickHouse data via Excel PivotTable using Mondrian
Sergei Semenkov
Sergei Semenkov
Sergei Semenkov
Follow
Jan 20 '21
How to explore ClickHouse data via Excel PivotTable using Mondrian
#
clickhouse
#
mondrian
#
opensource
#
excel
5
reactions
Comments
5
comments
5 min read
E-Mail Automation with Python and Excel
Anja
Anja
Anja
Follow
Jan 19 '21
E-Mail Automation with Python and Excel
#
python
#
excel
3
reactions
Comments
Add Comment
1 min read
Upload & Read Excel File in Node.js
Tien Nguyen
Tien Nguyen
Tien Nguyen
Follow
Jan 6 '21
Upload & Read Excel File in Node.js
#
node
#
excel
#
javascript
#
webdev
47
reactions
Comments
Add Comment
3 min read
Upload and Read Excel File in Node.js
Loi Le
Loi Le
Loi Le
Follow
Jan 4 '21
Upload and Read Excel File in Node.js
#
node
#
excel
#
upload
#
readfile
6
reactions
Comments
1
comment
2 min read
Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files
xuri
xuri
xuri
Follow
Jan 3 '21
Excelize 2.3.2 is Released – Go library for spreadsheet (Excel) files
#
go
#
excel
#
xlsx
5
reactions
Comments
Add Comment
3 min read
The Challenge: Create a Spreadsheet from a React Application?
Jesse Smith Byers
Jesse Smith Byers
Jesse Smith Byers
Follow
Dec 30 '20
The Challenge: Create a Spreadsheet from a React Application?
#
react
#
javascript
#
excel
#
codenewbie
11
reactions
Comments
1
comment
4 min read
3️⃣ Websites to Convert Tables to JSON
Yusuf
Yusuf
Yusuf
Follow
Dec 21 '20
3️⃣ Websites to Convert Tables to JSON
#
json
#
table
#
excel
#
convert
2
reactions
Comments
Add Comment
1 min read
Sort Data in Excel in Java
E-iceblue Product Family
E-iceblue Product Family
E-iceblue Product Family
Follow
Nov 12 '20
Sort Data in Excel in Java
#
java
#
excel
#
sortdata
6
reactions
Comments
1
comment
3 min read
The backend of the spreadsheet Luckysheet is also open source! Support online collaboration, one-click docker private deployment
Dushusir
Dushusir
Dushusir
Follow
Dec 3 '20
The backend of the spreadsheet Luckysheet is also open source! Support online collaboration, one-click docker private deployment
#
javascript
#
opensource
#
java
#
excel
3
reactions
Comments
Add Comment
2 min read
Basics of openpyxl : A Python module for Excel files
ADEMOLA OGUNMOKUN
ADEMOLA OGUNMOKUN
ADEMOLA OGUNMOKUN
Follow
Dec 10 '20
Basics of openpyxl : A Python module for Excel files
#
python
#
excel
#
openpyxl
#
automation
3
reactions
Comments
Add Comment
2 min read
Connecting to BigQuery From Excel and Python
Peter Jackson
Peter Jackson
Peter Jackson
Follow
Dec 2 '20
Connecting to BigQuery From Excel and Python
#
bigquery
#
excel
#
python
#
odbcdriver
5
reactions
Comments
Add Comment
2 min read
Create Pivot Table and Pivot Chart in Excel in Java
E-iceblue Product Family
E-iceblue Product Family
E-iceblue Product Family
Follow
Oct 16 '20
Create Pivot Table and Pivot Chart in Excel in Java
#
java
#
excel
#
pivottable
#
pivotchart
5
reactions
Comments
Add Comment
3 min read
DataGridView AutoFilter
Zujaj Misbah Khan
Zujaj Misbah Khan
Zujaj Misbah Khan
Follow
Nov 8 '20
DataGridView AutoFilter
#
excel
#
csharp
#
filter
#
datagrid
3
reactions
Comments
Add Comment
1 min read
Excel tips - lock column and row in formula
Franz Wong
Franz Wong
Franz Wong
Follow
Oct 4 '20
Excel tips - lock column and row in formula
#
excel
3
reactions
Comments
Add Comment
1 min read
Introducing CustomerTestsExcel
ceddlyburge
ceddlyburge
ceddlyburge
Follow
Nov 6 '20
Introducing CustomerTestsExcel
#
bdd
#
csharp
#
excel
6
reactions
Comments
Add Comment
8 min read
Document conversion with zoom option
Atir Tahir
Atir Tahir
Atir Tahir
Follow
Oct 19 '20
Document conversion with zoom option
#
dotnet
#
productivity
#
csharp
#
excel
6
reactions
Comments
Add Comment
1 min read
How-to Avoid Rounding "Errors" in Excel
CP
CP
CP
Follow
Oct 18 '20
How-to Avoid Rounding "Errors" in Excel
#
excel
#
finance
#
javascript
6
reactions
Comments
4
comments
2 min read
Excelize 2.3.1 is Released – Go library for spreadsheet (Excel) files, support to open the spreadsheet with password protection
xuri
xuri
xuri
Follow
Sep 22 '20
Excelize 2.3.1 is Released – Go library for spreadsheet (Excel) files, support to open the spreadsheet with password protection
#
go
#
excel
#
xml
#
office
5
reactions
Comments
1
comment
2 min read
Merge and Unmerge Cells in Excel in Java
CodeSharing
CodeSharing
CodeSharing
Follow
Sep 11 '20
Merge and Unmerge Cells in Excel in Java
#
java
#
excel
#
mergecell
6
reactions
Comments
Add Comment
2 min read
[Java] Insert and Read Formulas in Excel
CodeSharing
CodeSharing
CodeSharing
Follow
Sep 8 '20
[Java] Insert and Read Formulas in Excel
#
java
#
excel
#
formula
4
reactions
Comments
Add Comment
3 min read
Freeze/ Unfreeze Excel Panes in Java Application
CodeSharing
CodeSharing
CodeSharing
Follow
Aug 28 '20
Freeze/ Unfreeze Excel Panes in Java Application
#
java
#
excel
#
freezepanes
6
reactions
Comments
Add Comment
2 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account