tag:blogger.com,1999:blog-6067055770591163408.post9137535639408357399..comments2019-12-18T08:47:57.443-08:00Comments on My Blogs!: Powershell Script to convert Excel file to CSVVipin Vasudevanhttp://www.blogger.com/profile/16003693449725876127noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6067055770591163408.post-60232903745033715842019-12-18T08:47:57.443-08:002019-12-18T08:47:57.443-08:00I know Excel has a built in feature to identify cr...I know Excel has a built in feature to identify credit card numbers :( but there's a work-around out there. MaximumTrancehttps://www.blogger.com/profile/11202492720914722551noreply@blogger.comtag:blogger.com,1999:blog-6067055770591163408.post-51818741678881145102019-12-05T02:17:58.127-08:002019-12-05T02:17:58.127-08:00Vipin, I am trying to use your script to convert e...Vipin, I am trying to use your script to convert excel to csv files. I have creditcard numbers and 16 digit is rounding off. Is there a way to work around that please? <br />Thanks in advance. dharmahttps://www.blogger.com/profile/13068064614097976366noreply@blogger.comtag:blogger.com,1999:blog-6067055770591163408.post-31286907334707946302016-12-02T10:31:25.775-08:002016-12-02T10:31:25.775-08:00Oops!!! *late reponseOops!!! *late reponseVipin Vasudevanhttps://www.blogger.com/profile/16003693449725876127noreply@blogger.comtag:blogger.com,1999:blog-6067055770591163408.post-79767871777617462902016-12-02T08:55:10.198-08:002016-12-02T08:55:10.198-08:00Sorry for the later response! But yes we can..
$p...Sorry for the later response! But yes we can..<br /><br />$path = get-childitem -path "Your path"<br /><br />foreach ($file in $path) {<br /><br />$Excelfilename = $file.fullname<br />$CSVfilename = "" + $file.Basename+ "CSV"<br /><br />#Convert Excel file to CSV $xlCSV=6 <br /><br />$Excel = New-Object -comobject Excel.Application <br />$Excel.Visible = $False <br />$Excel.displayalerts=$False <br />$Workbook = $Excel.Workbooks.Open($ExcelFileName) <br />$Workbook.SaveAs($CSVfilename,$xlCSV) <br />$Excel.Quit() <br />If(ps excel){kill -name excel} Vipin Vasudevanhttps://www.blogger.com/profile/16003693449725876127noreply@blogger.comtag:blogger.com,1999:blog-6067055770591163408.post-54759779368654496622016-07-13T04:01:26.994-07:002016-07-13T04:01:26.994-07:00if we have multiple files of .xlxs in same locatio...if we have multiple files of .xlxs in same location, i want to convert all to CSV is it possible with this script? Anonymoushttps://www.blogger.com/profile/08136733452022249371noreply@blogger.comtag:blogger.com,1999:blog-6067055770591163408.post-59678612432022512212015-09-23T12:20:04.275-07:002015-09-23T12:20:04.275-07:00Use for first two lines:
#Convert Excel file to CS...Use for first two lines:<br />#Convert Excel file to CSV <br />$xlCSV=6 Anonymousnoreply@blogger.com