Click here to Skip to main content
15,867,308 members
Home / Discussions / C#
   

C#

 
AnswerRe: Best way to store/access data? Pin
RobertSF26-Jan-22 7:56
professionalRobertSF26-Jan-22 7:56 
AnswerRe: Best way to store/access data? Pin
Mycroft Holmes26-Jan-22 11:39
professionalMycroft Holmes26-Jan-22 11:39 
AnswerRe: Best way to store/access data? Pin
jschell30-Jan-22 6:59
jschell30-Jan-22 6:59 
QuestionI need some help Pin
Member 1551267725-Jan-22 12:09
Member 1551267725-Jan-22 12:09 
AnswerRe: I need some help Pin
Luc Pattyn25-Jan-22 14:34
sitebuilderLuc Pattyn25-Jan-22 14:34 
AnswerRe: I need some help Pin
RobertSF25-Jan-22 17:15
professionalRobertSF25-Jan-22 17:15 
AnswerRe: I need some help Pin
OriginalGriff25-Jan-22 20:01
mveOriginalGriff25-Jan-22 20:01 
QuestionC# EPPlus How to hide range of columns Pin
Mou_kol24-Jan-22 2:01
Mou_kol24-Jan-22 2:01 
I am working with EPPlus which generate excel file. now i have to hide range of columns. this code i used to hide range of columns in one go.

C#
var rangecol = ws.Cells["M1:P1"];
var hiddenColumns = rangecol
.Select(cell => cell.Start.Column)
.Distinct()
.Select(rangecol.Worksheet.Column)
.ToList();

foreach (var column in hiddenColumns)
{
    column.Hidden = true;
}


the above code is working and hiding columns but if there are 4 columns in range then it is hiding 4 columns individually not hide in one block. i want 4 columns should be hide in one block instead of 4 blocks.

please tell me what mistake is there in my code for which groups of columns are not getting hidden in one block. Thanks
AnswerRe: C# EPPlus How to hide range of columns Pin
Richard Deeming24-Jan-22 2:58
mveRichard Deeming24-Jan-22 2:58 
AnswerRe: C# EPPlus How to hide range of columns Pin
Victor Nijegorodov24-Jan-22 3:50
Victor Nijegorodov24-Jan-22 3:50 
QuestionHow would you describe what an IEnumerable is to a bright student of C# Pin
BillWoodruff22-Jan-22 2:34
professionalBillWoodruff22-Jan-22 2:34 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
jschell23-Jan-22 7:25
jschell23-Jan-22 7:25 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Richard Deeming23-Jan-22 21:59
mveRichard Deeming23-Jan-22 21:59 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
BillWoodruff25-Jan-22 3:23
professionalBillWoodruff25-Jan-22 3:23 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
jschell30-Jan-22 6:37
jschell30-Jan-22 6:37 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
#realJSOP24-Jan-22 23:44
mve#realJSOP24-Jan-22 23:44 
AnswerRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk26-Jan-22 5:31
endo funk26-Jan-22 5:31 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz26-Jan-22 6:13
mveGerry Schmitz26-Jan-22 6:13 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk26-Jan-22 9:40
endo funk26-Jan-22 9:40 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz27-Jan-22 16:58
mveGerry Schmitz27-Jan-22 16:58 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk27-Jan-22 19:35
endo funk27-Jan-22 19:35 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz28-Jan-22 5:50
mveGerry Schmitz28-Jan-22 5:50 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk28-Jan-22 6:40
endo funk28-Jan-22 6:40 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
Gerry Schmitz28-Jan-22 7:29
mveGerry Schmitz28-Jan-22 7:29 
GeneralRe: How would you describe what an IEnumerable is to a bright student of C# Pin
endo funk28-Jan-22 8:46
endo funk28-Jan-22 8:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.