Re:Ask HN: Rate my Product : QueryCell
by amih on Monday August 31, 2009 @02:43AM
(#795536)
I like the idea, I sometimes need to work with excel and hate formulas and filters. I prefer sql and most of the time I don't export data from excel to a DB, I just grind my teeth and do some filtering and formulas in excel.
some remarks:
1. Perhaps you can let define the tables in the FROM clause like: FROM workbook1.xls~sheet2~A1:D4 AS table1
2. Add an option to autohide the not selected rows instead of coloring the selected rows, this will give a condensed result set that the user can maybe copy and paste to another sheet.
3. Don't worry about Microsoft competing - they might offer to buy you out.
1. Perhaps you can let define the tables in the FROM clause like: FROM workbook1.xls~sheet2~A1:D4 AS table1
2. Add an option to autohide the not selected rows instead of coloring the selected rows, this will give a condensed result set that the user can maybe copy and paste to another sheet.
3. Don't worry about Microsoft competing - they might offer to buy you out.
keep focused! Good luck!