This is a super quick post.
Run a query in our SQL Developer extension for VS Code –
Now, how do I get SOME of those rows into my spreadsheet?
Option 1: Add a WHERE clause, Export to CSV
Right click in the grid, select ‘Export’
Then pick CSV, and choose your file, then open in your office software.
Native MS Excel export support is ONE THE LIST for adding features to our Extension, stay tuned for updates.
Option 2: Select the rows you want, and copy+paste
The trick here is you need to shift/cmd/ctrl select on the ROW number label in the grid. Once the rows are being selected, you can proceed to copy and paste. That looks like this –
Ability to copy also the column headers, will come into the extension as well as ability to range select a group of columns AND rows.
