Hi,
Based on my research, you could have a try with the following demo scripts to achieve your goal. Hope it is helpful to you:
1. Get data from Excel:
$excelpath = 'D:\Book1.xlsx'
$excelsheet = 'Sheet1'
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.WorkBooks.Open("$excelpath")
$sheet = $workbook.Sheets.Item("$excelsheet")
$sheet.Columns.Item(1).Value2
2. Create directories and files
New-Item -Path 'D:\' -Name 'Apple' -ItemType Directory
New-Item -Path 'D:\Apple' -Name 'Apple.txt'
3. Add data to a text file
Add-Content -Path 'D:\Apple\Apple.txt' -Value 'Apple'
If you need further help, please feel free to let us know.
Best Regards,
Albert Ling
Please remember to mark the replies as an answers if they help.
If you have feedback for TechNet Subscriber Support, contact
tnmff@microsoft.com
