title: Powershell script to convert excel files to csv files with card numbers with 16 digits
body: <p>I have this excel sheets and I want to have the same format for csv files. Could some one help me with a automation script please (to convert multiple excel sheets to csv files)??</p>
  <p>I tried this script, but the 16th digit of the card number is turning to be zero as excel can read only 15 digits right. Can we modify this code to convert multiple excel sheets to csv files?</p>
  <p>Could someone help me with this.</p>
  <h1>Convert Excel file to CSV</h1>
  <pre><code>$xlCSV=6
  $Excelfilename = “C:\Temp\file.xlsx”
  $CSVfilename = “C:\Temp\file.csv”
  $Excel = New-Object -comobject Excel.Application
  $Excel.Visible = $False
  $Excel.displayalerts=$False
  $Workbook = $Excel.Workbooks.Open($ExcelFileName)
  $Workbook.SaveAs($CSVfilename,$xlCSV)
  </code></pre>
  <p>$Excel.Quit()
  If(ps excel){kill -name excel}</p>