Click here to Skip to main content
14,774,347 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a command for DOS nbtstat -a Comp_name
Comp_name should be the one connected in LAN.
Now the MAC address displayed should be transfered to excel sheet automatically from DOS
Posted
Updated 10-Feb-11 5:40am
v2
Comments
Steve Maier 10-Feb-11 10:41am
   
Cleaned up the text speak.

1 solution

Well you can't transfer DOS output to Excel directly, but you can do

nbtstat -a Comp_name > output.csv

that will send all the output to a file named output.csv. Then you can try to open that file in Excel. I said try, becuase the output of nbtstat is not all formatted text.
   
Comments
Rajesh R Subramanian 11-Feb-11 9:24am
   
The .csv extension is case is not of relevance. The commandline will write the output data to the file as plain text even if you specify the extension as .csv
Yusuf 11-Feb-11 10:20am
   
I know that, it is plain text. But I made a conscious decision to tell him to use .csv because, I have no idea about his familiarity with importing to excel. Both .txt and .csv file can be imported to excel. If the extention is .csv excel will attempt to take a crack on it, but if it is .txt file, you have to tell it. If you read my last sentence there was a hint towards that.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900