DiegoZoracKy / convert-excel-to-json

Convert Excel to JSON, mapping sheet columns to object keys.
MIT License
290 stars 91 forks source link

Rows with merged cells inside #64

Open TSergey123 opened 2 years ago

TSergey123 commented 2 years ago

Hey everyone, Thanks a lot for your library, appreciate the work that you have done, but I have an unusual problem. what can I do with merged cells in one line? my result: { ClientCat: 'FirstCat', Place: 'Inside', List: '*', Acceptable: 'true', Program: Special, Code: 'I1', Name: Product 'sort'}, { ClientCat: null, productCode: null, CreditType: null, SummFrom: null, SummTo: null, TermFrom: 1, undefined: 360, PvMin: 15, PvMid: 19.99, PVMax: 20, Procent: null },

As you can see, for merged cells in one line, it creates a new object with null data, but I need all data from a row, to be in one object

screen