![]() The list won't change dramatically over time, but it will change weekly. My use case is to curate a nice interface to a list of frequently used files. Using the Power Query Editor, remove columns you don’t want to import and/or merge columns together. When you see the list of files, click Transform Data. Browse to the folder that contains the folders you want a list of, and then click Open. ![]() ![]() Or by specifying a file type: the type argument understands MIME types, file extensions, and a few human-friendly keywords. 6 I am playing around with AwesomeTable and like the Post-It template. In the Ribbon, go to Data > Get Data > From File > From Folder. You can narrow the query by specifying a pattern you’d like to match names against. Drive_find (n_max = 30 ) #> # A dribble: 30 × 3 #> name id drive_resource #> #> 1 _r_logo.jpg 1dandXB0QZpjeGQq_56wTXKNwaqgsOa9D #> 2 _r_about.html 1XfCI_orH4oNUZh06C4w6vXtno-BT_zmZ #> 3 _imdb_latin1.csv 163YPvqYmGuqQiEwEFLg2s1URq4EnpkBw #> 4 _chicken.txt 1axJz8GSmecSnaYBx0Sb3Gb-SXVaTzKw7 #> 5 _chicken.pdf 14Hd6_VQAeEgcwBBJamc-FUlnXhp117T2 #> 6 _chicken.jpg 1aslW1T-B8UKzAEotDWpmRFaMyMux5-it #> 7 _chicken.csv 1Mj-zJYZJSMKsNVjk2tYFef5LnCsNoDT #> 8 pqr 143iq-CswFTwJTjVfKkcFMDW0jYqDeUj2 #> 9 mno 1gcUTnFbsF6uioJrLCsVQ78_F1wEzyNtI #> 10 jkl 17T40phn99w0hY-B_Ev0deTvVg9fmUSnt #> # ℹ 20 more rows Files and folders - Retrieve files and folders ordered by name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |