How to show excel data sum in C# label.

Question

1.00/5 (1 vote)

See more:

Hello all,
i want show Excel column Sum in C#. i use this code

but got error...

The best overloaded method match for 'int.Parse(string)' has some invalid argument

please help...

What I have tried:

private void TodaysIncomeExpense()
        {
            string strFilename;
            strFilename = lblSelectedDatabase.Text;
            Microsoft.Office.Interop.Excel.Application xlApp;
            Microsoft.Office.Interop.Excel.Workbook xlWorkbook;
            Microsoft.Office.Interop.Excel.Worksheet xlWorksheet;
            Microsoft.Office.Interop.Excel.Range xlRange;

            xlApp = new Microsoft.Office.Interop.Excel.Application();
            xlWorkbook = xlApp.Workbooks.Open(strFilename);
            xlWorksheet = xlWorkbook.Worksheets["Sheet1"];
            xlRange = xlWorksheet.UsedRange;
            try
            {
                rowCount = xlRange.Rows.Count;
                for (index=2; index < rowCount;)
                {
                    int val = Int32.Parse(xlWorksheet.Cells[index, 5]);
                    val += val;
                    index++;
                    lblTotalIncome.Text = val.ToString();
                }
            }
            catch
            {
                //MessageBox.Show("GOT SOME ERROR");
            }
        }

Posted 15-Jul-20 2:03am

manish kr. chaturvedi

Updated 15-Jul-20 2:30am

v3

Add a Solution

Comments

Richard MacCutchan 15-Jul-20 8:06am

"but got error"
You need to explain what error. We cannot guess, or see your screen. Also, do not code try/catch blocks and then ignore any caught exceptions.

manish kr. chaturvedi 15-Jul-20 8:23am

Error is:
The best overloaded method match for 'int.Parse(string)' has some invalid argument.

2 solutions

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)

Patrice T · Answer 1 · 2020-07-15T02:30:00

Solution 2

Quote:
but got error...

When you ask for hep, it is a good idea to give details on the error.
Try/Catch structure exist to hide errors, it is a bad idea to use them while debugging your code. Error system normally tells you the reason and position of error, it is a great help.

You need to know that an excel cell is an object, not a string or a number.
Try:

C#

int val = xlWorksheet.Cells[index, 5].Value;

Posted 15-Jul-20 2:30am

Patrice T

Comments

manish kr. chaturvedi 15-Jul-20 8:39am

thanks but i now i have a different error:
cannot implicitly convert type 'decimal' to 'int'. An explicit conversion exits (are you missing a cost?)

Patrice T 15-Jul-20 9:15am

Use Improve question to update your question.
So that everyone can pay attention to this information.
And update your code.

Member 12901943 · Answer 2 · 2020-07-15T02:22:00

Solution 1

Without the error it's hard to say, but:

lblTotalIncome.Text

looks wrong - for a standard label control it should be:

lblTotalIncome.Caption

Check the properties of the label control you are using, make sure you're writing to the right one.

Posted 15-Jul-20 2:22am

Member 12901943

Updated 15-Jul-20 2:26am

v3

Comments

manish kr. chaturvedi 15-Jul-20 8:26am

its a C# Window Application....
I got error in Below line
int val = Int32.Parse(xlWorksheet.Cells[index, 5]);