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.

Sign up for GitHub

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

Jump to bottom

Copy selected rows as Excel #125

Closed
invisal opened this issue Aug 30, 2023 · 0 comments · Fixed by #140
Closed

Copy selected rows as Excel #125

invisal opened this issue Aug 30, 2023 · 0 comments · Fixed by #140
Labels
good first issue Good for newcomers

Comments

@invisal
Copy link
Collaborator

invisal commented Aug 30, 2023

image

Allow user to copy selected rows into the clipboard and able to paste it on Excel.

How to implement this

You can follow the "Copy as JSON" implementation

https://github.com/invisal/query-master/blob/main/src/renderer/screens/DatabaseScreen/QueryResultViewer/useDataTableContextMenu.tsx#L71

I think it is possible to do it as this answer:
https://stackoverflow.com/questions/60698115/how-to-copy-a-javascript-2d-array-to-clipboard-to-paste-it-in-excel

You can use getDisplayableFromDatabaseRows to stringify to make result string-friendly
https://github.com/invisal/query-master/blob/main/src/libs/TransformResult.ts#L84
@invisal invisal added the good first issue Good for newcomers label Aug 30, 2023
@jimmymeister98 jimmymeister98 mentioned this issue Sep 20, 2023
Merged
invisal pushed a commit that referenced this issue Sep 21, 2023
@jimmymeister98 @dglalperen @kaan9700
feat: add "Copy selected rows as Excel" #125 (#140)
f34696a 
Resolves #125

Co-authored-by: Alperen Dagli <80391142+dglalperen@users.noreply.github.com>
Co-authored-by: kaan9700 <81586446+kaan9700@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue Good for newcomers
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: add "Copy selected rows as Excel" #125
1 participant
@invisal