tabulator icon indicating copy to clipboard operation
tabulator copied to clipboard

rowHeader breaks table.import("xlsx")

Open owbear opened this issue 8 months ago • 1 comments

Describe the bug rowHeader breaks table.import("xlsx").

While trying to add import/export to a Tabulator table with row selection I noticed that the row selection column seems to slurp a bit of data and generally confuse the import.

Tabulator Info Version 6.3

Working Example https://jsfiddle.net/sw18p09j/2/

To Reproduce A step by step guide to recreate the issue in your JS Fiddle or Codepen:

  1. Export
  2. Import the generated export.xlsx

Expected behavior The data should survive the roundtrip.

Screenshots Before import: Image

After import: Image

The table gets incorrectly populated and always with an extra row (but that seems to be a different problem).

Desktop (please complete the following information): Same result with firefox on linux and chrome on windows

owbear avatar Mar 25 '25 13:03 owbear

I can confirm the same issue. I also noticed that this will occur with hidden columns. It seems the upload is completely column position/index-based. Is there a way to reliably map the Excel field name to the Tabulator column field name?

codethisio avatar May 14 '25 16:05 codethisio