Re:Show HN: Tool I created to covert tabular data to a 'pret...
by tastroder on Thursday October 24, 2019 @01:50AM
(#21341987)
If you find the time and mobile viewing is in scope, the site would benefit from an example on the homepage for us mobile users that don't have a table handy.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by bobbonew on Thursday October 24, 2019 @02:19AM
(#21342122)
Example, yes please!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Friday October 25, 2019 @12:40PM
(#21356720)
An example has been added!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Friday October 25, 2019 @12:40PM
(#21356718)
An example has been added!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by onion2k on Thursday October 24, 2019 @03:22AM
(#21342425)
SheetJS has an open source library xlsx-js[1] that can parse most Excel files. You could use that combined with FileReader (the browser file API) to enable users to drop a spreadsheet file on the page instead of copying and pasting. It'd be a nice addition.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by akx on Thursday October 24, 2019 @03:57AM
(#21342564)
+1. I'm using xlsx-js in the similar-ish tool I recently wrote: https://akx.github.io/d2d/
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @01:47PM
(#21347171)
Thank you for the suggestion, I will look into the library!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by Flashtoo on Thursday October 24, 2019 @02:58AM
(#21342321)
You might also be interested in JExcel: https://bossanova.uk/jexcel/v3/
It can take tabular data, allows you to do some Excel-like editing on it and download as CSV. Might be a bit heavy for your purposes, but it is easy to use and extend.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by martin_ on Thursday October 24, 2019 @01:49AM
(#21341976)
Any chance of adding a placeholder text for each of the options so folks can see what the output looks like without obtaining a result-set themselves :)
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Friday October 25, 2019 @12:40PM
(#21356729)
An example has been added to the homepage to see what the output looks like!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @01:48PM
(#21347183)
Absolutely, the next build will have that.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by teekert on Thursday October 24, 2019 @04:53AM
(#21342755)
Is it Pandas based? I'm a bioinformatician and many of my data work flows start with pandas.read_excel() and end with pandas.DataFrame().to_excel(). I had some serious issues with it but I have come to terms with it. Actually Excel is ok as a central project "database" (up to certain size of course), anyone can quickly fill in a lot or rows (the smart dragging, the macro's that take in other Excel files, drop-downs for categories that I later use in Pandas/Seaborn...) and programmatically dealing with it is not too bad (pandas for bulk stuff, openpyxl for very fine-grained control and even conditional formatting, which we use a lot, etc).
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @02:35PM
(#21347742)
There isn't too much to the rendered document, it reads the text as TSV and breaks that out into rows and cells. I tried keeping it as simple as possible for now, the idea isn't to help analyze data, but be able to share data in a usable format easily.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by AdieuToLogic on Thursday October 24, 2019 @03:49AM
(#21342537)
It appears your tool does not support pipe-delimited data in the "data to table" choice. An example is:
a|1
b|2
c|3
This is a pretty common data format and one which people whom use your tool may appreciate.HTH
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @01:47PM
(#21347174)
Thank you for the feedback! Pipe and CSV are next on the list :)
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by foreigner on Thursday October 24, 2019 @03:12AM
(#21342376)
Doesn't appear to be working for CSV? e.g.: https://dv.dbb1.dev/sheets/1a53b5aa-2b00-4f58-ad75-84a31dcde...
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @01:48PM
(#21347187)
Thank you for testing it out, it doesn't have support yet, but it will soon!
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by lucasverra on Thursday October 24, 2019 @02:45AM
(#21342255)
i do not understand the use case but im not too much in contact with big ugly excels nor SQL.
Is this for copying some poor visually formatted excel and have a clear view of it in your solution ?
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @01:52PM
(#21347230)
I usually use Sequel Pro to run queries against a MySQL server, typically I'll take a quick screenshot and send it to co-workers, sometimes the screenshots fail, there is too much data in it to be useful, or they do need an excel spreadsheet which requires more steps than I would like. I built it as a quick tool so I can easily copy the output of the query, paste it in the textbox, and an HTML table is generated.
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by iSnow on Thursday October 24, 2019 @04:10AM
(#21342611)
Doesn't seem to work for the following CSV:
date,x-numbers,y-numbers
2015-01-01,3,3
2016-01-01,2,3
2017-01-01,1,5
2018-01-01,3,8
Re:Show HN: Tool I created to covert tabular data to a 'pret...
by dougbarrett on Thursday October 24, 2019 @02:30PM
(#21347668)
CSV support is coming within the next day!
Yesterday, my screenshots weren't working at all when sharing them in slack, and I couldn't find a tool out there that could take tabular data and convert it to an easy to navigate table w/ an option to download as a CSV file, so I made my own.
Let me know if you have any questions or comments!