Reading Excel file data and executing it into command prompt and agin writting into excel usin .net

Question

0.00/5 (No votes)

See more:

Dear All,

Hi. I want to create 1 application in which first i want to read data from excel file. Then want to execute data using "Command prompt". whatever output i will get in the command prompt execution i want to capture into excel file again.

Does anyone help in the this application.
Please help me.
And thanks in advance.

Ranjeet Waje

Posted 8-Apr-12 20:28pm

ranjeet.waje

Add a Solution

Comments

ajit_machhe 9-Apr-12 2:33am

execute data using command prompt ??

I guess i can help but you have to provide more info.

ranjeet.waje 10-Apr-12 3:16am

Hey ajit,

In my window app, I hav one excel sheet. On button click I want take data from excel sheet row by row and run into the command prompt and then whatever output i will get from that want to export into the excel sheet again.

hey thank for support and please help.

Ranjeet waje

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)

ajit_machhe · Answer 1 · 2012-04-10T06:02:00

Hi Ranjeet,

Here is solution for taking output of executed command

C#

private void button1_Click(object sender, RoutedEventArgs e)
        {
            System.Diagnostics.ProcessStartInfo processstart = new          System.Diagnostics.ProcessStartInfo("cmd", "/c " + "dir");
            processstart.RedirectStandardOutput = true;
            processstart.Argument ="";
            processstart.UseShellExecute = false;
            processstart.CreateNoWindow = true;
            System.Diagnostics.Process proc = new System.Diagnostics.Process();
            proc.StartInfo = processstart;
            proc.Start();
            textBlock1.Text  = proc.StandardOutput.ReadToEnd();

        }

here i have chosen "dir"(simple dos command)and took output to textBlock

you can have string here for take a out put.

you can send parameter to command using processstart.Argument = "//here will be parameter";

do let me know if it works for you

i guess you can read from excel file...

else i will update that also.