Displaying alphabets above each datagrid columns in windows c#

Question

0.00/5 (No votes)

See more:

I am reading the datas from excel and binding with datagridview.
In the datagridview, datas are displayed as in excel.
But the header of datagrid is displaying like F1,F2,F3..... above each datagrid columns.

Now i want to diplay the alphabets A,B,C,D as in excel in my datagrid view.
Also i want the row numbers 1,2,3 in my datagridview as we see in excel.

I want the row and column format of excel??
How can i do that with .net windows c#?
Can anyone help me in this??

Thanks in Advance!

Mohana

Posted 27-May-12 21:11pm

Mohanapriya Ranganathan

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)

**Zoltán Zörgő** · Answer 1 · 2012-05-27T22:03:00

You can freeze columns and rows in DataGridView (see MSND: columns[^], rows[^]).
You can fill the first frozen column with numbers, first row (header) with letters. Think about the letter numbering as if if were a special number system of 26 digits (see some methods here: here[^]).

Update: here you have a sample, assuming that dataGridView1 is your gridview.

C#

public static string ExcelColumnFromNumber(int column)
        {
            string columnString = "";
            decimal columnNumber = column;
            while (columnNumber > 0)
            {
                decimal currentLetterNumber = (columnNumber - 1) % 26;
                char currentLetter = (char)(currentLetterNumber + 65);
                columnString = currentLetter + columnString;
                columnNumber = (columnNumber - (currentLetterNumber + 1)) / 26;
            }
            return columnString;
        }

        private void prepareGrid(DataGridView grid, int rows, int cols)
        {
            grid.ColumnCount = cols;
            grid.RowCount = rows;
            grid.RowHeadersVisible = true;
            grid.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
            for (int i = 0; i < rows; i++)
            {
                grid.Rows[i].HeaderCell.Value = (i+1).ToString();
            }
            for (int i = 0; i < cols; i++)
            {
                grid.Columns[i].HeaderCell.Value = ExcelColumnFromNumber(i+1);
            }
        }


        private void Form1_Shown(object sender, EventArgs e)
        {
            prepareGrid(dataGridView1, 100, 100);
        }

Auto-growing the grid is an other topic.