Hide or Disable the outside border (draggable) in Excel file when exporting using ClosedXml (OpenXml) in C#

Last Reply one year ago By dharmendr

Posted one year ago

Hi,

I tried this link https://www.aspsnippets.com/Articles/Export-DataTable-to-Excel-using-OpenXml-in-Windows-Forms-WinForms-Applications-using-C-and-VBNet.aspx

But I face one issue I did not able to hide or disable the outside border (draggable).

Rest export is working fine. 

Please see the bottom right corner, you can see blue draggable icon, if you drag it sample columns are inserting in excel.

Please guide me how to do this.

Posted one year ago

That cannot be controlled. As ClosedXML just exports to Excel.


Posted one year ago
Mudassar says:

That cannot be controlled. As ClosedXML just exports to Excel.

Thanks for your swift response. May be I may spelled wrong, what is the name of term which I refers.

Any other 3rd party plugins like closed xml is available, which export to excel based on datatable without any formatting.

Please provide any other solution if there apart plugin like closed xml.