Solved: UnicodeEncodeError: 'charmap' codec can't encode characters

Below are code to solve this error.

Code:

import xlsxwriter 

  

workbook = xlsxwriter.Workbook('skill.csv') 

  

# By default worksheet names in the spreadsheet will be  

# Sheet1, Sheet2 etc., but we can also specify a name. 

worksheet = workbook.add_worksheet("skill") 

  

# Some data we want to write to the worksheet. 

details = ( 

    ['SN', 'Name','Contribution'], 

    [1, "Linus Torvalds", "Linux Kernel"], 

    [2, "Tim Berners-Lee", "World Wide Web"], 

    [3, "Guido van Rossum", "Python Programming"],

    [4, "吴刚", "中文"],

 ) 

# Start from the first cell. Rows and 

# columns are zero indexed. 

row = 0

col = 0

  

# Iterate over the data and write it out row by row. 

for SN, Name , Contribution in (details): 

    worksheet.write(row, col, SN) 

    worksheet.write(row, col + 1, Name)

    worksheet.write(row, col + 2, Contribution)

    row += 1

  

workbook.close() 

python - table generation in pdf using python

First need to install module reportlab. Then create table using code below:

Output pdf:

Code:

from reportlab.lib import colors   #import module
from reportlab.lib.pagesizes import letter, inch
from reportlab.platypus import SimpleDocTemplate, Table, TableStyle

doc = SimpleDocTemplate("simple_table_grid.pdf", pagesize=letter)   #define pdf document name
# container for the 'Flowable' objects
elements = []   #define the data

data= [['00', '01', '02', '03', '04'],
       ['10', '11', '12', '13', '14'],
       ['20', '21', '22', '23', '24'],
       ['30', '31', '32', '33', '34']]
t=Table(data,5*[0.8*inch], 4*[0.8*inch])     #define the table format width and legth
t.setStyle(TableStyle([('ALIGN',(1,1),(-2,-2),'RIGHT'),
                       ('TEXTCOLOR',(1,1),(-2,-2),colors.red),
                       ('VALIGN',(0,0),(0,-1),'TOP'),
                       ('TEXTCOLOR',(0,0),(0,-1),colors.blue),
                       ('ALIGN',(0,-1),(-1,-1),'CENTER'),
                       ('VALIGN',(0,-1),(-1,-1),'MIDDLE'),
                       ('TEXTCOLOR',(0,-1),(-1,-1),colors.green),
                       ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),
                       ('BOX', (0,0), (-1,-1), 0.25, colors.black),
                       ]))

elements.append(t)        #then write the data
# write the document to disk

doc.build(elements)

Python tkinter - textbox

Here is the code for python gui textbox.

Python code:

from tkinter import *

root=Tk()

name=StringVar()

a=Entry(root,textvariable=name)
a.pack()

def enter():
    print(name.get())

    print("the text we get"+name.get())


b=Button(root,text="enter",command=enter)
b.pack()

root.mainloop()