Extract Shared Drive Details into an Excel

[stacy.m.stolz (Stacy Stolz)]

I am trying to get text from a Shared Drive Details list (multiple columns) for each document in the shared drive and export the text to an excel, each document having its own row in the excel and each shared drive column having its own column in excel and repeat until all document’s details have populated into the excel. I can get it one time but cannot get it to repeat. I am not sure what I need to do. I have Studio X.

[Anil_G (Anil Gorthi)]

@stacy.m.stolz

You can use a for each loop and keep all your steps inside the for each and give a count if you have the document count

Or can use while loop till the next document is not found

Cheers

[Shanmathi (Shanmathi Sadhasivam)]

Hi @stacy.m.stolz

1. Get Text: Extract the text from the shared drive details list.
2. Split Text: Split the text into individual columns.
3. For Each: Iterate through the columns.
4. Write Cell: Write the current column to the Excel file.
5. Save Workbook: Save the Excel file.