Two adjacent column values cannot be the same.

[Anoop-Goudar]

If same value exists in two adjacent columns then json wont be formed properly. var options = {} var workbookJson = excel.utils.sheet_to_json( sheet, options );

jsonObject below

{ first_name: 'James',
last_name: 'Butt',
company_name: 'Benton, John B Jr',
address: '6649 N Blue Gum St',
city: 'New Orleans',
county: 'Orleans',
state: 'LA',
zip: '70116',
phone1: '789',
email: 'jbutt@gmail.com',
web: 'http://www.bentonjohnbjr.com' },
{ first_name: 'Josephine',
last_name: 'Darakjy',
company_name: 'Chanay, Jeffrey A Esq',
address: '4 B Blue Ridge Blvd',
city: 'Brighton',
county: 'Livingston',
state: 'MI',
zip: '48116',
phone1: '456',
email: 'josephine_darakjy@darakjy.org',
web: 'http://www.chanayjeffreyaesq.com' },
{ first_name: 'Art',
last_name: 'Venere',
company_name: 'Chemel, James L Cpa',
address: '8 W Cerritos Ave #54',
city: 'Bridgeport',
county: 'Gloucester',
state: 'NJ',
zip: '8014',
phone1: '678',
email: 'art@venere.org',
web: 'http://www.chemeljameslcpa.com' },
{ first_name: 'Lenna',
last_name: 'Feltz Printing Service',
company_name: '639 Main St',
address: 'Anchorage',
city: 'WrerAnchorage',
county: 'AK',
state: '99501',
zip: '1234',
phone1: 'lpaprocki@hotmail.com',
email: 'http://www.feltzprintingservice.com' }

Value of the right cell in the two adjacent cells will be skipped, leading to a left shift operation.

[Anoop-Goudar]

any update on this ?