Just purchased the Cells package.
Im building a spreadsheet from a SqlDataReader, I know how many columns there will be in the
After I add all rows and columns how do I set the columns To AutoFilter ?
For instance Setting AutoFilter is done by a strongrepresentation of a range like "A1:B1".
I cant get this to work..
How do I set the entire sheet to AutoFilter (all columns added).?
A nice way would be to write AutoFilter.SetRange(Row,FirstColumn,LastColumn)