| 116 |
|
"""Deletes multiple columns or colume ranges wiht a list""" |
| 117 |
|
## Example sheet.Range("D:E, H:H, J:K").EntireColumn.Delete |
| 118 |
|
## Above gives an error, so I'm resorting to using python to loop |
| 119 |
< |
pass |
| 119 |
> |
pass |
| 120 |
> |
|
| 121 |
> |
def removeHeaderFilterArrows(self, sheet, row, colStart, colEnd): |
| 122 |
> |
"""Removes those filter arrows for all cells in a specified row.""" |
| 123 |
> |
sht = self.xlBook.Worksheets(sheet) |
| 124 |
> |
for c in range(colStart,colEnd+1): |
| 125 |
> |
sht.Cells(1).AutoFilter(Field = c, VisibleDropDown= False) |
| 126 |
> |
#sht.Range("A1:B1").AutoFilter(Field = 2, VisibleDropDown= False) |
| 127 |
> |
|
| 128 |
> |
def forceAutoFitRow(self, sheet, colStart, colEnd): |
| 129 |
> |
"""Takes a colstart and colend and then performs an autofit on those columns.""" |
| 130 |
> |
sht = self.xlBook.Worksheets(sheet) |
| 131 |
> |
sht.Columns("%s:%s"%(colStart, colEnd)).AutoFit() |
