transfer data from DOS to excel sheet

Question

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 10-Feb-11 4:38am

kalyanivin

Updated 10-Feb-11 4:40am

Steve Maier

v2

Add a Solution

Comments

Steve Maier 10-Feb-11 10:41am

Cleaned up the text speak.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Yusuf · Answer 1 · 2011-02-10T05:29:00

Solution 1

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.

Posted 10-Feb-11 5:29am

Yusuf

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.