Python Forum
code to read files in folders and transfer the file name, type, date created to excel
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
code to read files in folders and transfer the file name, type, date created to excel
#1
Hi Forum,

I am trying to write a code to create a excel file with table based on number of files present in the folder.

the output should look like
SNo, File Name, file type, created date, created by and hyperlink to file

Can someone help me with code.

Regards,
|Divya
Reply


Messages In This Thread
code to read files in folders and transfer the file name, type, date created to excel - by Divya577 - Dec-06-2020, 04:14 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 219 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Code to check folder and sub folders for new file and alert fioranosnake 2 163 Jan-06-2022, 05:03 PM
Last Post: deanhystad
  Error When Trying To Read CSV File kaega2 3 454 Dec-03-2021, 09:10 PM
Last Post: kaega2
  Date format and past date check function Turtle 5 743 Oct-22-2021, 09:45 PM
Last Post: deanhystad
  [SOLVED] Read text file from some point till EOF? Winfried 1 425 Oct-10-2021, 10:29 PM
Last Post: Winfried
  Working with excel files arsouzaesilva 6 940 Sep-17-2021, 06:52 PM
Last Post: arsouzaesilva
  File type (mode) rayleiter 5 733 Aug-29-2021, 07:46 PM
Last Post: Larz60+
  Problem in saving .xlsm (excel) file using pandas dataframe in python shantanu97 2 976 Aug-29-2021, 12:39 PM
Last Post: snippsat
  How to read this code? Jlyk 3 519 Aug-19-2021, 06:10 AM
Last Post: Jlyk
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 848 Aug-18-2021, 05:27 AM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020