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

Nachiasp...

Hi,

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.

Mudassar

0 5

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

Nachiasp...

0 6

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.

dharmend...

0 7

You can use Office interop library.

Refer below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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