上传，我完全忘记了这个问题。在此期间，我得到了一个解决方案。

此Powershell脚本将CSV转换为XLSX在后台

Ups, I entirely forgot this question. In the meantime I got a solution.
This Powershell script converts a CSV to XLSX in the background

• 将所有CSV值保留为纯文本，如 = B1 + B2 或 0000001 。
  
  您没有看到 #Name 或任何类似的东西。没有自动格式化。


• 根据您的区域设置自动选择正确的分隔符（逗号或分号）


• 自动调整列

• Preserves all CSV values as plain text like =B1+B2 or 0000001.
  You don't see #Name or anything like that. No autoformating is done.
• Automatically chooses the right delimiter (comma or semicolon) according to your regional setting
• Autofit columns

### Set input and output path
$inputCSV = "C:\somefolder\input.csv"
$outputXLSX = "C:\somefolder\output.xlsx"

### Create a new Excel Workbook with one empty sheet
$excel = New-Object -ComObject excel.application 
$workbook = $excel.Workbooks.Add(1)
$worksheet = $workbook.worksheets.Item(1)

### Build the QueryTables.Add command
### QueryTables does the same as when clicking "Data » From Text" in Excel
$TxtConnector = ("TEXT;" + $inputCSV)
$Connector = $worksheet.QueryTables.add($TxtConnector,$worksheet.Range("A1"))
$query = $worksheet.QueryTables.item($Connector.name)

### Set the delimiter (, or ;) according to your regional settings
$query.TextFileOtherDelimiter = $Excel.Application.International(5)

### Set the format to delimited and text for every column
### A trick to create an array of 2s is used with the preceding comma
$query.TextFileParseType  = 1
$query.TextFileColumnDataTypes = ,2 * $worksheet.Cells.Columns.Count
$query.AdjustColumnWidth = 1

### Execute & delete the import query
$query.Refresh()
$query.Delete()

### Save & close the Workbook as XLSX. Change the output extension for Excel 2003
$Workbook.SaveAs($outputXLSX,51)
$excel.Quit()