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

Nachiaspac
 
on Dec 14, 2017 10:27 AM
4073 Views

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.

Download FREE API for Word, Excel and PDF in ASP.Net: Download
Mudassar
 
on Dec 15, 2017 06:09 AM

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

Nachiaspac
 
on Dec 15, 2017 06:44 AM
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.

dharmendr
 
on Dec 15, 2017 07:02 AM

You can use Office interop library.

Refer below link.

Generate excel sheet from DataBase and save file to path using C# in ASP.Net