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
No comments:
Post a Comment