Make sure, that you provide the name of the sheet you intend to access. The Sheet Name is set per default to Microsoft's current default sheet name. If I would move it into a folder named 'Data', I would need to provide 'Data/Customer Data.xlsx' as the File Path. As you can see, my Excel Sheet is located directly in the upper most folder of my OneDrive for Business. Unfortunately, Microsoft's API does not support private OneDrive accounts, yet.
The File Path needed is the relative path in your OneDrive for Business. For the sheet shown above it will look like this:Įxample process extracting data from OneDrive Drag it into your process and fill in the parameters.
After the installation is complete, you will find a new Operator, called Read Excel Online in your Operator view. Open up RapidMiner and search the Marketplace (found in the Extensions menu item) for Spreadsheet Table Extraction. Its filename is 'Customer Data.xlsx', it contains one sheet called 'Sheet1' and note, that the 4th column is not given a name, yet. Example Excel Online Sheet Above you can see an Excel Sheet stored in a OneDrive for Business instance. It is part of the latest update of the Spreadsheet Table Extraction extension ( download link). Wouldn't it be great to include data from those files directly into your Data Mining process, even without downloading the whole file? Now you can! Introducing the new Read Excel Online Operator. This seems quite natural, when you consider the wide range of benefits: ease of sharing and collaboration, access from any pc with Internet connection, user right management and constant backups, just to name a few. Nowadays many corporate Excel files tend to be online.
0 kommentar(er)
