Data-sync on .xlsx with multple sheets

Questions
1

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.

image
image1024×434 60.1 KB

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

1 Like
2

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

Best regards,
Olena

1 Like
3

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

1 Like
4

Hi Kosuke,

I just wanted to let you know that we are planning to improve Excel handling in the next version of the platform. The update in 1.26.0 will include fixes, including your request regarding the data-sync functionality when loading an Excel file.

Best regards,
Olena

1 Like
5

Thanks Olena, I am so excited to hear that.
I always appreciate Datagrok team’s effort.
Best,
Kosuke

1 Like