Thursday, September 27, 2018

Convert Excel Files to CSV in batch via context menu : Convert Many Excel files to CSV in 1 click

RunDTech.XLStoCSV.ReadMe

Summary: Convert xls and xlsx files to csv via a batch menu
Code: C#


1. Copy this folder to C:\Temp\DTech.XLStoCSV\
2. you should see this in C:\Temp\DTech.XLStoCSV\ http://prntscr.com/kzn325
3. Run reg file RunDTech.XLStoCS.reg
4. Right click on the "C:\Temp\DTech.XLStoCSV\Test" folder (if any issues copy test folder to C:\Temp\Test
5. You should see http://prntscr.com/kzn372
6. Click the XLStoCSV menu.
7. You should see the below output


     C:\Temp\DTech.XLStoCSV>"C:\Temp\DTech.XLStoCSV\RunDTech.XLStoCSV.bat" C:\Temp\Te
     st
      ******* Start DTech.XLStoCSV.64.exe C:\Temp\Test  Thu 09/27/2018 23:55:19.84
     DTech.XLStoCSV START
     START CSV  C:\Temp\Test\1.xlsx
     DONE CSV  C:\Temp\Test\1.xlsx
     START CSV  C:\Temp\Test\2.xls
     DONE CSV  C:\Temp\Test\2.xls
     DTech.XLStoCSV DONE
      ******* Start DTech.XLStoCSV.32.exe C:\Temp\Test  Thu 09/27/2018 23:55:19.93
     DTech.XLStoCSV START
     START CSV  C:\Temp\Test\1.xlsx
     DONE CSV  C:\Temp\Test\1.xlsx
     START CSV  C:\Temp\Test\2.xls
     DONE CSV  C:\Temp\Test\2.xls
     DTech.XLStoCSV DONE
     ****************DONE  Thu 09/27/2018 23:55:19.98 synch
    
     8. If you encounter any error try downloading MS Access Redist kit
https://www.microsoft.com/en-us/download/details.aspx?id=13255

9. I wrote this code in 1 night, tested on over 50 xls and xlsx files


Download Here

No comments:

Post a Comment