Hello People,
I have used xlwt and python to create a workbook and four sheets in it. I'm done with editing the first sheet, Now I would like to open the sheet 2 that I have created in beginning and would like to edit it. I'm taking an input from user in beginning to choose which sheet he wants to open if he enters 2, sheet 2 should open and editing should be done on it instead of any other sheet same for 3 and 4. Kindly confirm how can i do it. I'm attaching a code that I have used but this isnt working at all.
Lastly i'll really appreciate if you can let me know how can I print a cell on the python GUI screen.
Below is the code I used for opening sheet 2 if user inputs 2
elif sheetChosen == 2:
* * worksheet2 = wb.get_sheet(2)
* * worksheet2.writ e(1, 1, 'Welcome to Worksheet 2')
I have used xlwt and python to create a workbook and four sheets in it. I'm done with editing the first sheet, Now I would like to open the sheet 2 that I have created in beginning and would like to edit it. I'm taking an input from user in beginning to choose which sheet he wants to open if he enters 2, sheet 2 should open and editing should be done on it instead of any other sheet same for 3 and 4. Kindly confirm how can i do it. I'm attaching a code that I have used but this isnt working at all.
Lastly i'll really appreciate if you can let me know how can I print a cell on the python GUI screen.
Below is the code I used for opening sheet 2 if user inputs 2
elif sheetChosen == 2:
* * worksheet2 = wb.get_sheet(2)
* * worksheet2.writ e(1, 1, 'Welcome to Worksheet 2')