column name 'nwt wt' already belongs to this datatable error

R.D Ip

5y690.NET

I am working on c#

I am saving a excel sheet

but I am facing an error

but my requirement is same column name in multiple time in excelsheet

below is my original requirement

what i am doing:

datatable data assign to the column

see below code:

I am trying to add bxc status and fx status but how?

please help

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

R.D Ip5y ago
but it is possible to add dynamic because i want to add also bxc status and fx status
R.D Ip5y ago
hello jignesh

but my requirement is column name is not unique

that is the main issue
Jignesh Kumar5y ago
Hi,

You have added same column name twice, your column name should be unique,
private void AddStatExcelSheet(DataTable pDT, ExcelWorksheet excelWorksheet)
{
    DataTable dtCust = new DataTable();
    dtCust.Columns.Add("NetWt", typeof(double));
    dtCust.Columns.Add("sx", typeof(int));
    dtCust.Columns.Add("sd", typeof(double));
    dtCust.Columns.Add("fNetWt", typeof(double));
    dtCust.Columns.Add("fsx", typeof(int));
    dtCust.Columns.Add("fsd", typeof(double));
    foreach (DataRow Drow in dt.Rows)
    {
        DataRow DRowDetailSubDet =   dtCust.NewRow();
        dtCust["NetWt"] = Drow["snweight"];
        dtCust["sx"] = Drow["sqty"];
        dtCust["sd"] = Drow["sdweight"];
        dtCust["fNetWt"] = Drow["fnetwt"];
        dtCust["fsx"] = Drow["fsx"];
        dtCust["fsd"] = Drow["fsd"];
        dtCust.Rows.Add(DRowDetailSubDet);
    }
}
Sachin Singh5y ago
There is no way to add a duplicate column in a datatable, instead, try a different approach like repeat rows horizontally while generating excel.