I've had success with using the AI to read html email data to extract delivery names and addresses using AI into JSON format, then put it into a structured table/excel before getting emailed.
I'm now looking to apply that to a broad range of excel files.
1. These files don't always have table structure
2. Columns names and number of them can vary.
What I'm after is advice on how to extract that data from a range of excel files so the AI can analyse it and return it in JSON format as before . From there I can then put it into a table/excel as before.
Has anybody done similar with some success? Any advice on the workflow required and sample flows would be greatly appreciated.
If you are able to add a script to your file, you can add a script that reads the data. Then use the Execute/Call a script from SharePoint/Onedrive to retrieve the data you want.
If this does answer your question i'd be grateful if you marked as such and maybe a like.
Thanks!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
22
Share
Report
All responses (
Answers (
