AutoFilter

Mar 23, 2012 at 7:08 AM

hi all,

im trying to write an excel with worksheet.Cells.AutoFilter = True. File is saved without errors but excel shows error while opening file and removes the filter feature.

any work around in EPPPlus?

 

thanks

Coordinator
Apr 2, 2012 at 5:31 AM

Specify the range in the indexer...

worksheet.Cells[worksheet.Dimension.Address].AutoFilter=true;

...for the entire worksheet.

Jan