I am using EPPlus package in my code for working with excel so I supposed to remove excel Address column from excel sheet and save the excel sheet without saving that column.
So I tried this following way
Code to remove column from excel
We are getting idx =1 means its finding that column, Later on the next line I am facing this issue.. System.ArgumentException:'Invalid Address format _DAT1
Can anyone provide the solution on this.
Expecting that Address column would be deleted with all row data and with header for particular column and download file without exception.