BoxLang 🚀 A New JVM Dynamic Language Learn More...
Commandbox Convert is a module for working with excel/csv data. The module utilizes the amazing lucee-spreadsheet created by Julian Halliwell. The module tries to handle some of the common use cases for working with table like data coming from a csv, excel, or any other valid JSON type data like an array, array of arrays, array of structs, or a JSON file.
This module can:
Apache License, Version 2.0.
Install the commands via CommandBox like so:
box install commandbox-convert
Import and export excel, csv, json, and pdf data through commandbox.
Import a csv or excel file to a query object Examples:
csvToQuery inputOrFile="~/Downloads/cities.csv" firstRowIsHeader=true
excelToQuery "~/Downloads/cities.xlsx"
Import a csv or excel file to a query object, which can then be piped into other commands Examples:
csvToQuery inputOrFile="~/Downloads/cities.csv" firstRowIsHeader=true | sql select="id,name" | exportTo cities.xlsx
excelToQuery "~/Downloads/POI.xlsx" | sql where="name != 'tom'" | exportTo POI_list.pdf
Export JSON or Query Data to one of many formats including
#extensionlist | sql select="id,name" | exportTo extention_list.csv
#extensionlist | sql select="id,name" | exportTo extention_list.xlsx
#extensionlist | sql select="id,name" | exportTo extention_list.json
#extensionlist | sql select="id,name" | exportTo extention_list.pdf
I THANK GOD FOR HIS WISDOM FOR THIS PROJECT
"I am the way, and the truth, and the life; no one comes to the Father, but by me (JESUS)" Jn 14:1-12
$
box install commandbox-convert