Python

Python RSS

Excel sheet background color

Thread Solved

•

Join Date: Feb 2008

Posts: 198

Reputation: dinilkarun is an unknown quantity at this point

Solved Threads: 0

dinilkarun dinilkarun is offline

Offline

Junior Poster

Excel sheet background color

Jun 29th, 2009

Hi All,

I am using the following code to write data into an excel sheet:

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
# Open the Output Spreadsheet
objExcel = win32com.client.Dispatch("Excel.Application")
 
# Creating object to write to Spreadsheet    
        self.xlApp =Dispatch("Excel.Application")
 
        # Creating Workbook
        self.Wkbk = self.xlApp.Workbooks.Add()
 
        # Get sheet count
        intShtCnt=self.Wkbk.Worksheets.Count
 
        # Creating worksheets
        wsObjReport = self.Wkbk.Worksheets.Add()
 
        # Setting names to the sheets
        wsObjReport.Name="Report"
 
        # Alignment Variables
        xlLeft, xlRight, xlCenter = -4131, -4152, -4108
 
        # Loop to remove extra sheets(created by default)
        for intiLoopIndex in range(1,intShtCnt+1):
            self.Wkbk.Worksheets("Sheet"+str(intiLoopIndex)).Delete()        
 
        # Setting active sheet
        sheets = self.Wkbk.Sheets
        sheets("Report").Activate()
# Open the Output Spreadsheet
objExcel = win32com.client.Dispatch("Excel.Application")

# Creating object to write to Spreadsheet    
        self.xlApp =Dispatch("Excel.Application")
                    
        # Creating Workbook
        self.Wkbk = self.xlApp.Workbooks.Add()

        # Get sheet count
        intShtCnt=self.Wkbk.Worksheets.Count

        # Creating worksheets
        wsObjReport = self.Wkbk.Worksheets.Add()

        # Setting names to the sheets
        wsObjReport.Name="Report"
                   
        # Alignment Variables
        xlLeft, xlRight, xlCenter = -4131, -4152, -4108

        # Loop to remove extra sheets(created by default)
        for intiLoopIndex in range(1,intShtCnt+1):
            self.Wkbk.Worksheets("Sheet"+str(intiLoopIndex)).Delete()        

        # Setting active sheet
        sheets = self.Wkbk.Sheets
        sheets("Report").Activate()

I am able to change the default sheet name to "Report". I want to change the color of the excel sheet from WHITE to YELLOW. How can I do it?...
Any help is much appreciated.

Regards,
Dinil