0

I have been trying to convert an .xls file to a .txt file. My file has Japanese characters so I need to convert into a unicode but have not found luck.

I have used the following code as of now :

Sample DELOIP.BAT :

REM INTERNAL USE ONLY 
mkdir c:\temp 
cd c:\temp 
cd "C:\Users\Public\Documents" 
REM Opening employee master
cmd /u /c type DSS_employee_master.xls>DSS_employee_master.txt
exit
cd c:\temp

But this does not work.

Any help in this is welcome.

Thanks

Amith
  • 6,818
  • 6
  • 34
  • 45
user2106410
  • 69
  • 1
  • 2
  • 6
  • 1
    I'm pretty sure you're going to have to save the file in Excel as text first to be able to do this. `CMD` can't read a binary file like an .xls file. You can use some VBScript to do that. – Matt Williamson Mar 31 '14 at 13:20

1 Answers1

0

There are scripts for doing this on superuser. See here for one example. There are others.

Another herer Convert XLS to CSV on command line

Community
  • 1
  • 1
Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129