将excel转换为csv和csv使用Powershell excel。

Convert csv to excel:<\/u><\/strong><\/p>

Step 1: Use \"Tbox Start Program\" to open powershell.exe<\/p>

Step 2: In the argument section, give the command:-\u00a0<\/p>

$xl = new-object -comobject excel.application<\/strong>
$Workbook = $xl.workbooks.open('{CP[File_Path]}')<\/strong>
$Worksheets = $Workbooks.worksheets<\/strong>
$Workbook.SaveAs('{CP[Excel_Path]}',-4143)<\/strong>
$Workbook.Saved = $True<\/strong>
$xl.Quit()<\/strong><\/p>

Here, FilePath: you can provide the path of your csv file.<\/p>

Excel_Path: you can provide the path where you want to save your excel file. The format should be\u00a0\"Excel_Path.xls\"<\/strong><\/p>

Step 3: Just check in your machine if it getting converted.<\/p>

Convert excel to csv:<\/strong><\/u><\/p>

- You just need to replace the code in argument as:<\/p>

$xl = new-object -comobject excel.application
$Workbook = $xl.workbooks.open('C:\\bin\\CSV & EXCEL\\Dummy.xls<\/strong>')
$Worksheets = $Workbooks.worksheets
$Workbook.SaveAs('C:\\bin\\CSV & EXCEL\\Dummy.csv<\/strong>',1<\/strong>)
$Workbook.Saved = $True
$xl.Quit()<\/p>","quoteUsername":"Community Administrator","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote & Reply","Share":"Share"}}}">

• 就像
• 报价和回复
• 分享