excel to csv powershell

Chad Owens answered on December 12, 2022 Popularity 9/10 Helpfulness 2/10

answer excel to csv powershell

excel to csv powershell

Comment

# To execute the script without agreeing with the execution policy
Set-ExecutionPolicy Bypass -Scope Process
# Defines the directory where the file is located
$dir = "D:\"

# Defines the name of the Excel file
$excelFileName = "YOUR_FILE_NAME"

# Define a function to convert the file
Function ExportWSToCSV ($excelFileName, $csvLoc)
{
    $excelFile = $dir + $excelFileName + ".xlsx"
    $E = New-Object -ComObject Excel.Application
    $E.Visible = $false
    $E.DisplayAlerts = $false
    $wb = $E.Workbooks.Open($excelFile)
    foreach ($ws in $wb.Worksheets)
    {
        $n = $excelFileName  + "_" + $WS.Name
        $ws.SaveAs($csvLoc + $n + ".csv", 6)
    }
    $E.Quit()
}

# For each file in the directory with the xlsx format, convert to CSV using the function above
$ens = Get-ChildItem $dir -filter *.xlsx
foreach($e in $ens)
{
    ExportWSToCSV -excelFileName $e.BaseName -csvLoc $dir
}

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: guimatheus92.medium.com

Tags: csv excel powershell whatever

Link to this answer
Share Copy Link

Contributed on Dec 12 2022

Chad Owens

0 Answers Avg Quality 2/10

excel to csv powershell

Contents

More Related Answers

excel to csv powershell

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.