extracting excel attachments coming into shared mailbox

Sarda702
Tera Contributor

3 weeks ago

Hello Team,

 

I have a use-case where my customer receives email attachments in multiple formats excel, PDF, images. These document type can come in one email and hence the objective is to extract the details of the attachment and then match it against some master data.

 

While Document Intelligence supports PDF and Image formats, how do we handle the excel attachment data. What are the alternate ways to extract and work on the extracted excel data? 

0 Helpfuls
  • 887 Views
3 REPLIES 3

Kieran Anson
Kilo Patron

3 weeks ago

Do the excel files follow the same structure? Or do they vary and require parsing in order to extract the information out of them?

0 Helpfuls

Sarda702
Tera Contributor
In response to Kieran Anson

3 weeks ago

These excel sheets may vary when received as the submitter is a business user who can add details in excel and send to this mailbox.

0 Helpfuls

Kieran Anson
Kilo Patron
In response to Sarda702

3 weeks ago

Understood. I'm not aware of a native solution that would have this level of "intelligence" 

 

If the file was a set format, you could process it via an import set. There is also an excel parser JavaScript API available, but that would simplify allow you to access the data. It wouldn't have intelligence to know how to pass columns and volumes to and a structured output 

0 Helpfuls