I need to convert excel files into a Foundry dataset. I have a bunch of excel files in a dataset that are being read in via a data connection. What is the easiest way to do this? I found this code (https://www.palantir.com/docs/foundry/code-examples/raw-file-parsing-transforms#parse-excel-file-with-python), however it does not work for me because some functions are not included in the code snippet. Thank you.
You can use uploading excel files on dataset and treat them on pipeline builder
Hello jenny,
Check out this tutorial from The Ontologize Youtube channel.
From Excel Worksheets to Scheduled Reporting