extracting excel attachments coming into shared mailbox

[Sarda702]

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? 

[Kieran Anson]

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

[Sarda702]

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.

[Kieran Anson]

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