Need Python sample code for open,modify and save the existing excel sheet

[amuven]

Hi All,

I'm new to python I have written very basic and small code and I request to help for the following senario.For my project i want to write a python code which should open an already existing Excel sheet which can contain 2 or 3 datasheets and write data in sheet1(first sheet) alone and should not modify the data in rest of the datasheets and save it.

I have heard that people saying it can be done through pyExcelerator or xlrd or xlwt.Since all these things are new to me .. i really don't know how to do it .. :-(

So, I request you all to help me with sample code which will do the above mentioned task as early as possible.

Thanks,
Amudha

[Elias Alhanatis]

Hi!!

I am not so new in Python , so here is a sample of a script i use to do something like you described:
( Of course you should change all the variables i use and put your own ,
but since i came up with this after some good research ( mainly in the fields of
Visual Basic... ) , i think its a good place for you to start... )

I hope this will help a bit....

from win32com.client import Dispatch

def Create_Analysis_Page(Name,Job,Phone,Month,Analysing_Dict,preview=False):

    xlApp = Dispatch ("Excel.Application")
    xlWb = xlApp.Workbooks.Open ("C:\\Python25\\Misthos.xlsx")
    xlSht = xlWb.Worksheets (1)
        
    xlSht.Cells(1,2).Value=str(Name)
    xlSht.Cells(2,2).Value=str(Job)
    xlSht.Cells(3,2).Value=int(Phone)
    xlSht.Cells(5,2).Value=str(Month)

    try:
        for i in range (9,40):
            xlSht.Cells(i,2).Value=Analysing_Dict[i-8][0]
            xlSht.Cells(i,3).Value=Analysing_Dict[i-8][1]
            xlSht.Cells(i,4).Value=Analysing_Dict[i-8][2]
    except:
        pass
        
    xlSht.Cells(41,4).Value=Analysing_Dict["Totals"][0]
    xlSht.Cells(42,4).Value=Analysing_Dict["Totals"][1]
    xlSht.Cells(43,4).Value=Analysing_Dict["Totals"][2]
    
    #Preview or not....
    if preview:
        xlApp.Visible=1
        xlApp.ActiveWindow.SelectedSheets.PrintPreview()
        
    else:
        #Print The Sheet...
        xlSht.PrintOut()        # This is for printing :)
        xlApp.DisplayAlerts=False   # This is for NOT asking to save changes
        xlApp.Workbooks.Close()
        xlApp.DisplayAlerts=True # This is for bringing back the default behaviour
        xlApp.Quit()

Elias

[amuven]

Hi,
It works .... thank you so much .. sorry for late reply :-)