I have an excel file like this:
I use xlsx to parse a sheet’s data to json:
import * as XLSX from 'xlsx';
const wb = XLSX.read(data, { type: 'binary' });
const ws = wb.Sheets['Sheet'];
const json = XLSX.utils.sheet_to_json(ws);
The json object is just a key/value objects:
[
{
account_number: '109325380759',
amount: 1000000,
channel_code: 'VN_VCB',
account_name: 'DANICA MARIE REYES',
__rowNum__: 1
},
{
account_number: 4300540341,
amount: 1000000,
channel_code: 'VN_VCB',
account_name: 'JONEL PINPIN',
__rowNum__: 2
},
{
account_number: 9366892320,
amount: 1000000,
channel_code: 'VN_VCB',
account_name: 'ALBERT GADIANA',
__rowNum__: 3
}
]
My goal is to find a way to get the cell’s type (number, text…) of all cells except the header cells. Any solution for this?