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

Elanchezhiyal Elangovan 1 Reputation point
2022-07-26T10:35:14.04+00:00

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.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,264 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 40,156 Reputation points
    2022-07-26T10:42:24.223+00:00

    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.

    0 comments No comments