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 679 by nino.borges, Mon May 4 19:41:49 2020 UTC vs.
Revision 682 by nino.borges, Thu May 7 20:06:07 2020 UTC

#	Line 46 | Line 46 | class ExcelConnection:
46		sht = self.xlBook.Worksheets(sheet)
47		sht.Cells(row,col).NumberFormat = format
48
49	+	def setCellProperties(self, sheet, row, col, font = None, fontSize = None):
50	+	"""A catch all for changing the properties of a cell.  I can keep adding to this to avoid too many methods"""
51	+	sht = self.xlBook.Worksheets(sheet)
52	+	#sht.Cells(1,"A").AutoFilter(Field = 1, VisibleDropDown= False)
53	+	#sht.Range("A1:B1").AutoFilter(Field = 2, VisibleDropDown= False)
54	+	if font:
55	+	pass
56	+	if fontSize:
57	+	sht.Cells(row,col).Font.Size = fontSize
58	+
59		def getRange(self,sheet,row1,col1,row2,col2):
60		"return a 2d array (i.e. tuple of tuples)"
61		sht = self.xlBook.Worksheets(sheet)

Diff Legend

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