slimz 0.0.3

utils for python

pyutils

pip3 install --upgrade slimz

Color

from slimz.color import Color

cl = new Color()
color = Color()
print(cl.red('I am red!'))
print(cl.green('I am gree!'))
print(cl.yellow('I am yellow!'))
print(cl.blue('I am blue!'))
print(cl.magenta('I am magenta!'))
print(cl.cyan('I am cyan!'))
print(cl.white('I am white!'))
print(cl.white_green('I am white green!'))

Book1

Book1 is just for reading specified cell data

from slimz.book import Book1
sheet = b1.sheet(0)
print(sheet.cell_value(0,0))
print(sheet.cell_value(0,1))
print(sheet.cell_value(0,2))
print(sheet.cell_value(1,2))
print(sheet.cell_value(4,0))

Book2

Book2 used for writing data with existing sheet template

from slimz.book import font,style,Book2,borders,alignment_center,alignment_left,alignment_right
style1 = style(font("Arial",10),borders,alignment_center)

b2 = Book2("/Users/scottxiong/Desktop/test.xlsx","/Users/scottxiong/Desktop/test1.xls")
sheet = b2.copy(0,0)
sheet.write(5,1,"hello world")
sheet.write(5,2,1111)
sheet.write(5,3,"2020/03/02")
b2.save()