Giter Club home page Giter Club logo

poink's Introduction

Coverage license Build Status Download

Poink!

POI iN Kotlin

A Kotlin DSL to read/write XLSX files via Apache POI.

Really almost nothing here, the DSL is a facade for Apache POI, providing for somewhat simpler use.

Generating

        workbook {
            // Create a named cell style
            val headerStyle = cellStyle("Header") {
                fillForegroundColor = IndexedColors.GREY_25_PERCENT.index
                fillPattern = FillPatternType.SOLID_FOREGROUND
            }
            sheet("One") {
                // Add a row with a style
                row(listOf("a", "b", "c"), headerStyle)
                // Add a row without style
                row(listOf(1, 2.0, 3L))
            }
            sheet {
                row(listOf("A very wide cell"))
                row(listOf("An even wider column"))
                // Auto size the width of a column
                autoSizeColumn(0)
            }
        }.write("test.xlsx")

Reading

   workbook("test.xlsx") {
            sheet("One") {
               iterator().forEach { row ->
                    row.iterator().forEach { cell ->
                        println(cell.stringCellValue)
                    }
               }
            }
        }

See Also

poink's People

Contributors

nwillc avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.