C # using NPOI how to delete a column in the excel, thank you

CodePudding user response:

Try sheet. GroupColumn (startColumn endColumn)

CodePudding user response:

Groupcolumn hides in group, help to see again? thank you

CodePudding user response:

Please help to look at, thank you

CodePudding user response:

Did you find a solution? I also want to know npoi can delete columns

CodePudding user response:

Not yet, how do I check in online to write

CodePudding user response:

If no method of removing columns, can consider to traverse line, to delete/shift to the left of the cell,

The individual feels EPPLUS better than NPOI

CodePudding user response:

I want to know so delete a column of VBA is

Open it literally recorded a VBA macros,

 Columns (" B: "B"). Select 
Selection. Delete Shift:=xlToLeft 

Microsoft says, to do so, I am good,
You can now go to NPOI document, and see what he and methods corresponding to the

Doesn't matter EPPLUS, since be office, the first idea is all manufacturers, can be compatible with VBA is compatible with VBA,

Who is my personal choice, of course, who support target template I'll use, if there is no target templates, so who is better for VBA compatible, who I use