ViewVC Help

View File | Revision Log | Show Annotations | View Changeset | Root Listing

root/ns_dev/Python/NinoCode/Tool_Box/ExcelLib.py

Comparing Python/NinoCode/Tool_Box/ExcelLib.py (file contents):
Revision 686 by nino.borges, Thu May 7 20:59:05 2020 UTC vs.
Revision 690 by nino.borges, Wed May 13 15:29:53 2020 UTC

#	Line 13 | Line 13 | class ExcelConnection:
13
14		def __init__(self,fileName = None):
15		self.xlApp = Dispatch('Excel.Application')
16	+	#self.xlApp.Visible = True
17		if fileName:
18		self.fileName = fileName
19		self.xlBook = self.xlApp.Workbooks.Open(fileName)
#	Line 123 | Line 124 | class ExcelConnection:
124		sht = self.xlBook.Worksheets(sheet)
125		for c in range(colStart,colEnd+1):
126		sht.Cells(1).AutoFilter(Field = c, VisibleDropDown= False)
127	+
128		#sht.Range("A1:B1").AutoFilter(Field = 2, VisibleDropDown= False)
129
130		def forceAutoFitRow(self, sheet, colStart, colEnd):

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines (old)
>	Changed lines (new)