Is possible to arrange bad formated Worksheet(xlsx) and make it table like

[jose candido]

hi, i've a xlsx file that contais person registration info, i need to import it to a database, normaly data come on table like, but this one was very different, is there a way to use the xlsio to make this crazyness workable

Pessoa

Tipo

Fantasia

Venda Vista/Prazo

CPF/CNPJ

Insc. Est.

Insc. Munic.

Data Fundação/Aniv.

Data Cadastro

Vendedores

2 - DIOGENES FONSECA LOPES -  FUNC. FIDA

CLIENTE

Somente à Vista

463.244.880-04

-

09/01/2017

-

CEP

Logradouro

Número

Complemento

Bairro

Cidade/UF/País

Observação

96570-000

RUA BORGES DE MEDEIROS

1021

CENTRO

CACAPAVA DO SUL/RS/BRASIL

Pessoa

Tipo

Fantasia

Venda Vista/Prazo

CPF/CNPJ

Insc. Est.

Insc. Munic.

Data Fundação/Aniv.

Data Cadastro

Vendedores

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Jose,

Kindly help us by sharing the input Excel document, to check by importing the data to the data table.

Regards,

Keerthi.

[jose candido]

Hi, sure

Attachment: RelatorioPessoas_74a70191.zip

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Jose,

Sorry for the delay in getting back to you.

We have prepared a simple sample to format the shared Excel document. This sample can be downloaded from the below link.

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/F181768_Console803293277.zip 

Kindly try and let us know if this helps.

Regards,

Keerthi.