epplus_test.fs

open System.IO
open OfficeOpenXml
open System.Data

[<EntryPoint>]
let main argv = 
    let f = FileInfo("test.xlsx")
    use p = new ExcelPackage(f)
    let ws = p.Workbook.Worksheets.Add("testi")
    use dt = new DataTable("mundata")
    dt.Columns.AddRange( [| new DataColumn("foo"); new DataColumn("bar") |] )
    let row = dt.NewRow()
    row.["foo"] <- "12"
    row.["bar"] <- "13"
    dt.Rows.Add(row)
    let range = ws.Cells.[1,1,2,5]
    let tab = range.LoadFromDataTable(dt, true)
    p.Save()
    0