Last updated column check

[Mayur_Pawar]

hey guys,
I wanna check my last updated column in excel how can i check that ?

thanks
Cheers

[pattyricarte (Patty Boy)]

hmmm maybe you can save the previous excel before you update it and check the previous and present excel @Mayur_Pawar

cheers

Happy learning

[Manish540 (Manish Shettigar)]

You can do like this,
ColumnNames(DataColumnCollection type) = dt.Columns.
then use a for each to display the column names.

[ParasTripathi]

@Mayur_Pawar
Use this query to get changes in datatable:

changeTable =table.GetChanges(DataRowState.Deleted)

Hope it will work!!!
Chhers @Mayur_Pawar

[Mayur_Pawar]

@Manish540

ColumnNames(DataColumnCollection type) = dt.Columns.

i have excel i’m writing data in new column so while adding data into new column i want to check whether previous column has a data or not and column name is dynamic.