I use the Postgre database.
The user must select the date on the client and after that an file Excel has been exported for the selected date.
So how can I, on the server side, export data from a database to Excel.
Asked
Active
Viewed 529 times
0
-
what database are you using? – SanSolo Jan 22 '19 at 12:54
-
@SanSolo In sense of? I wrote PostgreSQL – user10720571 Jan 23 '19 at 02:58
-
2Possible duplicate of [How to create an Excel File with Nodejs?](https://stackoverflow.com/questions/17450412/how-to-create-an-excel-file-with-nodejs) – Chance Jan 23 '19 at 03:22
1 Answers
0
Maybe this could help. I've tried this in v10.6 and it is working fine
COPY "Table_Name" TO 'D:/sample.csv' (format csv);
Akshara
- 211
- 1
- 9