spreadsheet

Read and write spreadsheets from and to CSV files in a lazy way http://www.haskell.org/haskellwiki/Spreadsheet

LTS Haskell 8.20:0.1.3.4
Stackage Nightly 2017-06-26:0.1.3.4
Latest on Hackage:0.1.3.4
BSD3 licensed and maintained by Henning Thielemann

Module documentation for 0.1.3.4

Read and write spreadsheets from and to files containing comma separated values (CSV) in a lazy way. See also the csv package http://hackage.haskell.org/package/csv and http://www.xoltar.org/languages/haskell.html, http://www.xoltar.org/languages/haskell/CSV.hs. Both do not parse lazy. Reading from other source than plain Strings could be easily added.

If you install this package by

cabal install -fbuildExamples

then an example program is compiled and installed, too. This program fills a template text using data from a CSV file. E.g. given a file template.txt with content

Name: FIRSTNAME SURNAME
Born: BIRTH

and names.csv with content

"FIRSTNAME","SURNAME",BIRTH
"Georg","Cantor",1845
"Haskell","Curry",1900
"Ada","Lovelace",1815

the call

csvreplace template.txt <names.csv

produces the output

Name: Georg Cantor
Born: 1845
Name: Haskell Curry
Born: 1900
Name: Ada Lovelace
Born: 1815

You may also generate one file per CSV row in the following manner:

csvreplace --multifile=FIRSTNAME-SURNAME.txt template.txt <names.csv

For similar (non-Haskell) programs see cut, csvfix, csvtool.

comments powered byDisqus