Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Excel format support #8

Open
shawnbot opened this issue Apr 1, 2015 · 0 comments
Open

Add Excel format support #8

shawnbot opened this issue Apr 1, 2015 · 0 comments

Comments

@shawnbot
Copy link
Owner

shawnbot commented Apr 1, 2015

Looks like js-xlsx is the most eligible candidate because it does parsing and formatting (and reads from a buffer, which is necessary for stdio). The read and write APIs are synchronous, but we could do something similar to what the HTML parser does and just buffer all the data until the end of the stream.

CLI API for reading:

# just read the first sheet
tito --read excel data.xls
# read the second sheet (1-based index?)
tito --read.format excel --read.sheet 2
# read a named sheet
tito --read.format excel --read.sheet "Sheet Name"

and writing:

# what should the default sheet name be? "Data"?
tito --read csv --write excel
tito --read csv --write.format excel --write.sheet "Sheet Name"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant