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

Question

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: private void AddStatExcelSheet(DataTable pDT, ExcelWorksheet excelWorksheet) { DataTable dtCust = new DataTable(); dtCust.Columns.Add( "Net Wt" , typeof ( double )); dtCust.Columns.Add( "sx" , typeof ( int )); dtCust.Columns.Add( "sd" , typeof ( double )); dtCust.Columns.Add( "Net Wt" , typeof ( double )); dtCust.Columns.Add( "sx" , typeof ( int )); dtCust.Columns.Add( "sd" , typeof ( double )); DataTable dt = dr.CopyToDataTable(); foreach (DataRow Drow in dt.Rows) { DataRow DRowDetailSubDet = dtCust.NewRow(); dtCust[ "Net Wt" ] = Drow[ "snweight" ]; dtCust[ "sx" ] = Drow[ "sqty" ]; dtCust[ "sd" ] = Drow[ "sdweight" ]; dtCust[ "Net Wt" ] = Drow[ "fnetwt" ]; dtCust[ "sx" ] = Drow[ "fsx" ]; dtCust[ "sd" ] = Drow[ "fsd" ]; dtCust.Rows.Add(DRowDetailSubDet); } } I am trying to add bxc status and fx status but how? please help

Sachin Singh · Answer

There is no way to add a duplicate column in a datatable, instead, try a different approach like repeat rows horizontally while generating excel.

R.D Ip · Answer

but it is possible to add dynamic because i want to add also bxc status and fx status

R.D Ip · Answer

hello jignesh but my requirement is column name is not unique that is the main issue

Jignesh Kumar · Answer

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); } }