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.