You can run the DIR command from the built-in Console tab. The Console displays the selected folder's contents in a command-line like interface. You can customize the list of columns and save the column selection for future use. It's more of a file explorer view than a separate tool. The Tree-List view is the same as the Filter view but without the search options. By default, it uses the filter view, i.e., you can use a keyword or RegEx (Regular Expression) in the Include/Exclude fields to narrow down the search to specific file formats, names, or other parameters. You may have noticed that the pane has its own toolbar. name, size, extension, path, date modified and others. The pane displays file and folder listings in columns, e.g. Let's go back to the main pane of DirPrintOK, because that's where you will find all the useful options. The left side bar acts as the tree pane and is kind of similar to Windows Explorer's you can click on any item there to display its content in the main pane. The address bar at the top displays the path of the current folder and the large pane to the right displays the folder's content. The interface of DirPrintOK may look slightly confusing on first glance but that feeling will go away once you start using it. If the connector is not able to get the rows then you cannot use the logic for your requirement and as I mentioned earlier you need to create a custom solution for your requirement using the azure function and also using office sdk to extract the data and ingest into the sql table.DirPrintOK is a freeware tool made by Nenad Hrg, the developer of the brilliant Q-Dir file manager. In case if you are taking about some other view then please let me know or you can test it from your end using the excel connector to read/exact the data (using get a row action) from the file. Error code is 'PasswordProtectedWorkbook'. 'message': 'The request is forbidden by Graph API.

If you are talking about protected view with password then excel online (Business) connector doesn't support and it will throw the below error.

Download dirprintok excel