Data-sync on .xlsx with multple sheets

kosuketakeuchi0621 · March 3, 2025, 9:56am

I would like to discuss an enhancement proposal regarding the data-sync functionality when loading an Excel file.

Currently, when reading an Excel file, I appreciate that datagrok effectively reads all the sheet names and their contents. On the other hand, I have encountered an issue when setting to use the data-sync option on saving a project. It appears that only the first sheet is targeted for data-sync, and as a result, the data from the second sheet remains unupdated.

Attached is the screenshot when saving project after loading an Excel file with sheet1 and sheet2.

I wonder if you could deal with this proposal to read all the sheets from the Excel file when with the data-sync option? This enhancement would greatly improve the usability and efficiency of datagrok.

If you have any questions or comments please let me know.
Best regards,
Kosuke

oahadzhanian.datagrok.ai · March 3, 2025, 10:46am

Hi Kosuke,
I’ve reproduced the issue, and it’s now in our queue. Thanks for bringing it to our attention!

github.com/datagrok-ai/public

Projects: XLSX files with multiple sheets: data sync is only provided for the first sheet

opened 10:41AM - 03 Mar 25 UTC

ahadzhanian

DS

Data: any XLSX file with multiple sheets, e.g.[northwind.xlsx](https://github.co…m/user-attachments/files/19051845/northwind.xlsx) 1. Open the XLSX file 2. Save the project - in the dialog, data sync option is only provided for the first sheet 3. Edit the original file (the second or the third sheet) 4. Reopen the project - the data from the second and the third sheets remains unupdated https://github.com/user-attachments/assets/31803fe6-6df0-426b-ac26-542ba24476f4

Best regards,
Olena

kosuketakeuchi0621 · March 3, 2025, 12:06pm

Thanks as always. I am looking forward to fixing it someday.
Best,
Kosuke