**Question description:**

*This user has given permission to use the problem statement for this
blog.*

how can i apply excel formula to list data in c#.Net console application.
I need to apply the excel formula to entire column to calculate the data.

Solved by K. L. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
18/07/2018 - 01:43

Hi

Excelchat Expert
18/07/2018 - 01:43

Welcome to Got it Pro

User
18/07/2018 - 01:43

Hello

Excelchat Expert
18/07/2018 - 01:43

Please tell more about the requirement so that i can help you better

User
18/07/2018 - 01:43

i have data in excel

User
18/07/2018 - 01:43

working in C# console application

User
18/07/2018 - 01:44

i took that data into list

User
18/07/2018 - 01:44

now i need to apply some excel formula to the list

User
18/07/2018 - 01:44

to calculate

Excelchat Expert
18/07/2018 - 01:45

I can help you with formulas in excel..if you have list of data in excel then i can help you with formulas on it

Excelchat Expert
18/07/2018 - 01:45

Not sure how formula works on other applications

User
18/07/2018 - 01:45

i have colum a, b, c

Excelchat Expert
18/07/2018 - 01:46

Please write the data on spreadsheet on the right

User
18/07/2018 - 01:46

i need the addition of abc in colum e

User
18/07/2018 - 01:46

ok

User
18/07/2018 - 01:46

=CONCATENATE(F17," ",$W$1)

User
18/07/2018 - 01:46

my excel formula

User
18/07/2018 - 01:47

for colum x

User
18/07/2018 - 01:47

how can i write in C#.Net

Excelchat Expert
18/07/2018 - 01:47

Please write the data on spreadsheet on the screen so that i can help you out

Excelchat Expert
18/07/2018 - 01:48

https://docs.microsoft.com/en-us/dotnet/csharp/how-to/concatenate-multiple-strings

Excelchat Expert
18/07/2018 - 01:49

Please refer this and let me know if this helps

Excelchat Expert
18/07/2018 - 01:49

This platform is designed for formulas in excel. Not sure about other domains

User
18/07/2018 - 01:50

no

User
18/07/2018 - 01:50

i checked this already

User
18/07/2018 - 01:50

how can past my data in your excel

User
18/07/2018 - 01:50

i am not able to paste

Excelchat Expert
18/07/2018 - 01:50

If you need help in excel i can help you out..not sure about other domains

User
18/07/2018 - 01:51

you know .Net?

Excelchat Expert
18/07/2018 - 01:51

not much. This platform is not meant for .net

User
18/07/2018 - 01:51

ok

Excelchat Expert
18/07/2018 - 01:51

This portal is for excel

Excelchat Expert
18/07/2018 - 01:51

=CONCATENATE(A1:C1)

User
18/07/2018 - 01:51

yes

User
18/07/2018 - 01:51

but excel with .Net

Excelchat Expert
18/07/2018 - 01:51

This is the formula we use for concatenation in excel

User
18/07/2018 - 01:52

working on automation of excel work

User
18/07/2018 - 01:52

yes

User
18/07/2018 - 01:52

i want to autmate the excel formula using .Net

User
18/07/2018 - 01:52

insted of applying this formula in each cell

Excelchat Expert
18/07/2018 - 01:53

using System;
class Program
{
static void Main()
{
// ... Create a new string reference.
// It points to the literal.
string s1 = "string2";
// ... Add another string to the start.
string s2 = "string1" + s1;
Console.WriteLine(s2);
}
}

User
18/07/2018 - 01:53

will automate

Excelchat Expert
18/07/2018 - 01:53

Please see this below link

Excelchat Expert
18/07/2018 - 01:53

https://www.dotnetperls.com/string-concat

Excelchat Expert
18/07/2018 - 01:53

This should help you out

User
18/07/2018 - 01:54

no

Excelchat Expert
18/07/2018 - 01:54

This is the best i can help you with

User
18/07/2018 - 01:54

ok

Excelchat Expert
18/07/2018 - 01:54

IF you have anything in excel please let me know

Excelchat Expert
18/07/2018 - 01:54

I will be happy to help you out

User
18/07/2018 - 01:54

thank you

Excelchat Expert
18/07/2018 - 01:54

Welcome

Excelchat Expert
18/07/2018 - 01:54

Have a great day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*