NotificationsYou must be signed in to change notification settings
Fork555
Star1.8k

Add Copying and Exporting Support to Edit Data#20812

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.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Jump to bottom

Open

lewis-sanchez wants to merge18 commits intomain

base:main

Choose a base branch

fromlewissanchez/editData/addCopyAndExportFunctionality

Open

Add Copying and Exporting Support to Edit Data#20812

lewis-sanchez wants to merge18 commits intomainfromlewissanchez/editData/addCopyAndExportFunctionality

Conversation

Copy link

Contributor

lewis-sanchez commentedDec 15, 2025•
edited
Loading

Pull Request Template – vscode-mssql

Description

This PR adds support for the following copy and export operations:

Copy - Copies the selected grid data
Copy with Headers - Copies selected grid data with column headers
Copy Headers - Doesn't copy grid data, but only the column headers of selected columns.
Export to CSV
Export to Excel
Export to JSON

Here's a demo of copying with these 3 copy options:

This PR also adds support for exporting to CSV, Excel, and JSON.
Here's a demo of exporting to CSV

Here's a demo of exporting to Excel

Here's a demo of exporting to JSON

Provide a clear, concise summary of the changes in this PR. What problem does it solve? Why is it needed? Link any related issues usingissue closing keywords.

Code Changes Checklist

New or updatedunit tests added
All existing tests pass (npm run test)
Code followscontributing guidelines
Telemetry/logging updated if relevant
No regressions or UX breakage

Reviewers:Please read our reviewer guidelines

lewis-sanchez added8 commits

December 13, 2025 00:59

Add copying and exporting to Edit Data grid

bcd70d5

Generated loc's

438bd4c

Fix copy icon

2837efc

Fix export icon

6d840f0

Add unit tests for new reducer

e0dea82

Fix export to excel

7b08769

Fix unit tests

3a85f42

Fix comment

19479fd

lewis-sanchez requested review fromBenjin,aasimkhan30,allancascante,caohai,kburtram,laurenastrid1,manujoseph85 andssreerama ascode owners

December 15, 2025 23:16

Copy link

github-actionsbot commentedDec 15, 2025•
edited
Loading

PR Changes

Category	Target Branch	PR Branch	Difference
vscode-mssql VSIX	5285 KB	5286 KB	⚪ 1 KB ( 0% )
sql-database-projects VSIX	5668 KB	5668 KB	⚪ 0 KB ( 0% )
data-workspace VSIX	null KB	532 KB	⚪ 532 KB ( 0% )

Copy link

codecov-commenter commentedDec 15, 2025•
edited
Loading

Codecov Report

❌ Patch coverage is98.07692% with1 line in your changes missing coverage. Please review.
✅ Project coverage is 65.99%. Comparing base (2339af6) to head (a237f47).
⚠️ Report is 4 commits behind head on main.

Files with missing lines	Patch %	Lines
...rc/tableExplorer/tableExplorerWebViewController.ts	96.66%	1 Missing⚠️

Additional details and impacted files

@@            Coverage Diff             @@##             main   #20812      +/-   ##==========================================+ Coverage   65.91%   65.99%   +0.07%==========================================  Files         210      210                Lines       19997    20049      +52       Branches     2600     2605       +5     ==========================================+ Hits        13182    13232      +50- Misses       6718     6719       +1- Partials       97       98       +1

Files with missing lines	Coverage Δ
extensions/mssql/src/constants/locConstants.ts	`87.12% <100.00%> (+0.05%)`	⬆️
extensions/mssql/src/models/contracts.ts	`100.00% <100.00%> (ø)`
...ensions/mssql/src/services/tableExplorerService.ts	`100.00% <100.00%> (ø)`
...nsions/mssql/src/sharedInterfaces/tableExplorer.ts	`100.00% <ø> (ø)`
...rc/tableExplorer/tableExplorerWebViewController.ts	`90.62% <96.66%> (+0.46%)`	⬆️

... and1 file with indirect coverage changes

🚀 New features to boost your workflow:

❄️Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
📦JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.