HOW TO ADD CREATE EXCEL SHEET..FROM AN APLLICATION..

Question

1.00/5 (1 vote)

See more:

I am reading rgb values of each pixel in an application and storing it in an excel sheet.
when i select the file and run the application/..i get a message..that application is running at the bottom of screen...but actual excel sheet is filled with data..and even if i refresh it...it is not getting loaded(i mean the size does not change..)...the code is given below...plz chk
///some code

  using (FileStream fs = File.Create("DEST.XLS"))
                    {
                        using (TextWriter w = new StreamWriter(fs))
                        {
                            Bitmap bm = new Bitmap(textBox1.Text);
//textbox siginifes the file we are selcting for reading pixel data
                            for (i = 0; i < bm.Width; i++)
                            {
                                for (j = 0; j < bm.Height; j++)
                                {
                                    Color pixelColor = bm.GetPixel(i, j);
                                    b = pixelColor.R;
                                    w.Write(b + " ");
                                    c = pixelColor.G;
                                    w.Write(c + " ");
                                    d = pixelColor.B;
                                    w.Write(d + " ");
                                    w.Write("\r\n");
                                }
                            }
                            w.Close();
                        }
                    }

//DATA.XLS...GETS CREATED FROM WHERE WE SELECTE THE IMAGE.

//IS THE FORMAT WHICH I HAVE WRITTEN FOR EXCEL FILE CORRECT..BECAUSE A MSG COMES..IT IS NOT IN CORRECT FORMAT...BUT I AM ABLE TO OPEN IT

Posted 24-Feb-13 12:51pm

luckycode

Updated 24-Feb-13 13:37pm

Mike Meinz

v3

Add a Solution

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)

Mike Meinz · Accepted Answer · 2013-02-24T13:44:00

I made a few changes to your code and tested the following code. It creates a comma-separated values (CSV) file that will be loaded into Excel when you double-click the DEST.CSV filename in File Explorer. It works fine for smaller image files. For larger image files, it creates a file that is too big (too many rows) for Excel to load.

Changes I made:
1. Renamed file to DEST.CSV
2. Put commas between R and G values and between G and B values
3. Declared all variables

using System.Diagnostics;

...

        private void button1_Click(object sender, EventArgs e)
        {
            using (FileStream fs = File.Create("DEST.CSV"))
            {
                using (TextWriter w = new StreamWriter(fs))
                {
                    int i;
                    int j;
                    int b;
                    int c;
                    int d
                    Bitmap bm = new Bitmap(textBox1.Text);
                    //textbox signifies the file we are selecting for reading pixel data
                    for (i = 0; i < bm.Width; i++)
                    {
                        for (j = 0; j < bm.Height; j++)
                        {
                            Color pixelColor = bm.GetPixel(i, j);
                            b = pixelColor.R;
                            w.Write(b + ",");
                            c = pixelColor.G;
                            w.Write(c + ",");
                            d = pixelColor.B;
                            w.Write(d);
                            w.Write("\r\n");
                            
                        }
                    }
                    w.Close();
                    //
                    // Load DEST.CSV into Excel
                    Process myProcess = new Process();
                    try
                    {
                        myProcess.StartInfo.UseShellExecute = true;
                        myProcess.StartInfo.FileName = "DEST.CSV";
                        myProcess.StartInfo.CreateNoWindow = true;
                        myProcess.Start();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }