question

ElanchezhiyalDhiraviyam-9346 avatar image
0 Votes"
ElanchezhiyalDhiraviyam-9346 asked OlafHelper-2800 edited

Features are disabled in excel while loading data from Sql server table to multiple sheets using C#

I am trying to Load data from table to Excel in multiple sheets. I Can see the features are disabled (Conditional Formatting, Sorting, etc). I am using C# Code for loading data into excel.

dotnet-adonet
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered OlafHelper-2800 edited

I am using C# Code for loading data into excel.

And how exactly do you load the data with C#? VSTO, OpenXML, InterOp, ...?

I Can see the features are disabled (Conditional Formatting, Sorting, etc).

When?
A lot of Excel features/buttons are disabled when you edit a cell content.
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.