Baeldung
baeldung.com › home › kotlin › kotlin io › read and write to excel with kotlin
Read and Write to Excel With Kotlin | Baeldung on Kotlin
March 26, 2025 - Let’s first have a look at how to handle an Excel file. First of all, Kotlin does not provide out-of-the-box handling of the Excel format. For that purpose, we’ll use the Apache POI libraries.
GitHub
github.com › evanrupert › ExcelKt
GitHub - evanrupert/ExcelKt: Kotlin Wrapper over the Apache POI Excel Library that enables creating xlsx files with kotlin builders · GitHub
An idiomatic Kotlin wrapper over the Apache POI Excel library for easily generating Excel xlsx files.
Starred by 115 users
Forked by 14 users
Languages Kotlin
Videos
Export data to Excel by extracting from MSSQL Server 2022 ...
Escribir y Leer Archivo Excel con ApachePOI, Compose y ...
Escribir y Leer Archivo Excel con ApachePOI, Kotlin y Android ...
Export data to Excel by extracting from MySQL DB tables ...
15:40
How to create an Excel file from your Android App? - YouTube
11:24
How to Read file from Excel | Kotlin Tutorial - YouTube
Java in Excel
exceljava.com › docs › tutorials › kotlin.html
Creating a Kotlin Excel Add-In - Java in Excel
This tutorial shows how Jinx can be used to write an Excel Add-In exposing user defined functions to Excel written in Kotlin.
GitHub
github.com › 4sh › retable
GitHub - 4sh/retable: Kotlin library to work with tabular data files (csv, excel, open document)
File(pathTo("simple_data.xlsx")).inputStream().use { val hello = Retable.excel().read(it) // read as excel with default settings .records // access the records sequence .map { it["first_name"] + " " + it["last_name"] } // access data by column name (headers in file) .first() // sequence is consumed only on call, so getting first record in a large file is fast println(hello) // prints `Xavier Hanin` }
Author 4sh
Developer Soapbox
developersoapbox.com › basic-read-and-write-excel-using-kotlin
Basic Read and Write Excel Using Kotlin - Developer Soapbox
December 2, 2019 - This post is a very simple example of reading and writing to Excel using Kotlin. Thanks to its Java interoperability, we can utilize the…
GitHub
github.com › peterbecker › xls-utils
GitHub - peterbecker/xls-utils: Kotlin utilities for dealing with Excel files
kotlin-xls - a wrapper around POI to make handling Excel files easier, also includes code to compare Excel workbooks, aimed primarily at unit testing
Author peterbecker
YouTube
youtube.com › watch
Basic Read and Write to Excel / LibreOffice Using Kotlin - YouTube
Basic Read and Write to Excel / LibreOffice Using Kotlin Apache POI Project Page - https://poi.apache.org/DeveloperSoapbox.com blog article about this tutori...
Published February 5, 2018
Reddit
reddit.com › r/kotlin › write excel add-ins in kotlin
r/Kotlin on Reddit: Write Excel Add-Ins in Kotlin
March 14, 2018 - Discussion about Kotlin, a statically typed programming language for the JVM, Android, JavaScript, and native. ... It works by embedding the JVM in Excel and exposing annotated Kotlin (or Java, Scala etc) functions to Excel as UDFs.
DataFrame Help
kotlin.github.io › dataframe › write.html
Write | DataFrame
// Create a new Excel workbook with a single sheet called "allPersons", replacing the file if it already exists -> Current sheets: allPersons df.writeExcel(file, sheetName = "allPersons") // Add a new sheet to the previous file without replacing it, by setting keepFile = true -> Current sheets: allPersons, happyPersons df.filter { person -> person.isHappy }.remove("isHappy") .writeExcel(file, sheetName = "happyPersons", keepFile = true) // Add a new sheet to the previous file without replacing it, by setting keepFile = true -> Current sheets: allPersons, happyPersons, unhappyPersons df.filter { person -> !person.isHappy }.remove("isHappy") .writeExcel(file, sheetName = "unhappyPersons", keepFile = true)
Medium
nwillc.medium.com › poink-a-tiny-apache-poi-kotlin-dsl-aff4fe107eff
Poink! A Tiny Apache POI Kotlin DSL | by nwillc | Medium
January 13, 2020 - If you’ve ever had to deal with Excel spreadsheets from Java/Kotlin I hope you found Apache POI. It makes it doable. It’s a very good framework with one expected drawback, the API is a bit awkward and mechanical. It is working with Excel after all, so really there’s just no amount of lipstick that will make that pig pretty.