How to rename column names from the csv file using C#

Question

1.00/5 (1 vote)

See more:

I have three csv file all having different header name i want change header name how i want code should be written in generic,please help me how to write generic code to change column names from the csv file

example:
File1:column name
input :Server, date,Average license
output rename to: Server details,Period,Avg. license usage

File2:column name
input :Department,detailUSage,overUsage
output Rename to : Dept,Detail Usage, License over usage
below code can change only one file header but i harcoded the header name that should be generic all the csv file column

What I have tried:

public void ExtractDataToCSV(DataTable dtDataTable, string strFilePath)
      {
          StreamWriter sw = new StreamWriter(strFilePath, false);
          //headers
          dtDataTable.Columns.Add("No.", typeof(int));
          dtDataTable.Columns["No."].SetOrdinal(0);
          for (int count = 0; count < dtDataTable.Rows.Count; count++)
          {
              dtDataTable.Rows[count]["No."] = count + 1;
          }
          for (int i = 0; i < dtDataTable.Columns.Count; i++)
          {
              string[] columnames = new string[] { "No.", "Server", "Period", "Dept ", "Alloted License", "Avg.License used" };
              sw.Write(columnames[i].ToString());
              sw.Write(dtDataTable.Columns[i]);
              sw.Write(',');
          }
          sw.Write(sw.NewLine);
          foreach (DataRow dr in dtDataTable.Rows)
          {
              for (int i = 0; i < dtDataTable.Columns.Count; i++)
              {
                  sw.Write(dr[i].ToString());
                  sw.Write(",");
              }
              sw.Write(sw.NewLine);
          }
          sw.Close();
      }

Posted 18-Mar-21 18:44pm

Member 15088142

Updated 18-Mar-21 21:51pm

Add a Solution

Comments

Richard MacCutchan 19-Mar-21 6:00am

sw.Write(columnames[i].ToString());

You have declared (and initialised) columnames as an aray of strings, so why do you think you need to call ToString on them?

Member 15088142 19-Mar-21 7:03am

yes ur right tostring not required

Member 15088142 19-Mar-21 7:03am

any other method is there to rename column names by writing generic code

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)

Maciej Los · Answer 1 · 2021-03-18T21:51:00

Solution 1

Take a look here: I want to rename my column name[^]

Posted 18-Mar-21 21:51pm

Maciej Los

Comments

Member 15088142 19-Mar-21 7:02am

any other method to do that i tried
foreach (DataColumn column in dtDataTable.Columns)
{
switch (column.ColumnName)
{
//LicenceAvgData
case "AllotedLicense":
column.ColumnName = "Alloted License";
break;
case "AllotedDate":
column.ColumnName = "Period";
break;
case "AvglicenseUsed":
column.ColumnName = "Avg. License used";
break;
}
}
sw.Write(column.ColumnName);
sw.Write(',');
in this also i am getting but i need other good approach to do

Maciej Los 19-Mar-21 7:22am

Not like this. Use Dictionary object (solution #2) under the link.