Remove the header of a column from a data table

[CristianYanpiar (Csuazoa)]

uso la expresión extracDtaOrdenes.AsEnumerable().Skip(1).CopyToDataTable().DefaultView.ToTable(False, “Column-8”) para extraer la columna 8 evitar el elemento de la primera fila ,pero ahora ademas quiero remover the header of a column , extracDtaOrdenes es un data table

[Vikas_M]

Hola @CristianYanpiar ,
Por favor consulte este hilo a continuación.

Remove headers from Data table

@atishaarav , Is this the Text format of the Datatable that you are pasting in SAP ? If so, we would require to First remove the First Line and Take all the other lines. We can do so in the below way : DT_Text = String.Join(Environment.NewLine,Split(DT_Text,Environment.NewLine).Skip(1).ToArray) Where DT_Text is the Datatable in Text format

[Shiva_Nikhil]

@CristianYanpiar

dt.AsEnumerable.Select(Function(x) x(“Column8”).ToString).Skip(1).ToArray

para eliminar el encabezado de la columna, debe mencionar el nombre de la columna primero y luego usar omitir

[neha.upase]

Hi,

You can try this,

extracDtaOrdenes.AsEnumerable().Skip(1).CopyToDataTable().DefaultView.ToTable(False, “Column-8”).Columns(0).ColumnName = “”

This expression first extracts column 8 excluding the first row, and then it assigns an empty string as the column name, effectively removing the header of the extracted column.