would be better if you check out the code, using openxml method and i have 2 problems only:
1- cant click button second time to save again the datagridview, reason it uses the datatable somehow and not release it
2- cant manage it to make it to record what is showed in datagridview.