Add AutoFilter to Format-Cell about psexcel HOT 7 OPEN

Have the code written for this, but it only works in one direction (setting to true).

Will check on whether I'm doing it wrong, or whether a bug should be submitted for the EPPlus library.

from psexcel.

How about this: Spreadsheet1.ActiveSheet.AutoFilterMode = $false ?
source: https://msdn.microsoft.com/en-us/library/aa199191(v=office.10).aspx

from psexcel.

But only one direction is fine ;) Can I test it?

from psexcel.

sure, just committed the change!

from psexcel.

thank you

I am missing something ;( it is not working for me

On Fri, Oct 9, 2015 at 12:03 AM Warren F. [email protected] wrote:

sure, just committed the change!

—
Reply to this email directly or view it on GitHub
#20 (comment)
.

from psexcel.

Hi!

A few steps that might help:

• Re-download PSExcel from GitHub (PowerShellGallery is now behind)
• Import-Module \Path\To\PSExcel -Force # or open a new session and import without Force
• Format-Cell -AutoFilter $True # Using bool, to allow setting back to false at some point

If you open Format-Cell.ps1, you should see that parameter in the param() block:

Thanks!

from psexcel.

done. it is working like charm
have you seen this?
https://msdn.microsoft.com/en-us/library/aa199191(v=office.10).aspx

from psexcel.