Python | Тригонометрические операции в файле Excel с использованием openpyxl

Опубликовано: 24 Марта, 2022

Предварительное условие: настройка строк и столбцов листа Excel с помощью openpyxl.

Openpyxl is a Python library using which one can perform multiple operations on excel files like reading, writing, mathematicaloperations and plotting graphs. Let’s see how to perform different Trigonometric operations using openpyxl.

Простые тригонометрические функции:

Code #1 : Using simple trigonometric functions in the program.

=SIN(Number) : Returns the sine of an angle. Number is the angle in radians for which you want the sine.
=COS(Number) : Returns the cosine of an angle.
=TAN(Number) : Returns the tangent of an angle.
=CSC(Number) : Returns the cosecant of an angle.
=SEC(Number) : Returns the secant of an angle.
=COT(Number) : Returns the cotangent of an angle.

# import openpyxl module
import openpyxl
   
# Call a Workbook() function of openpyxl 
# to create a new blank Workbook object
wb = openpyxl.Workbook()
   
# Get workbook active sheet  
# from the active attribute.
sheet = wb.active
  
# set the width of the column
sheet.column_dimensions["A"].width = 20
sheet.column_dimensions["B"].width = 30
sheet.column_dimensions["C"].width = 20
  
# writing to the cell of an excel sheet
sheet["A1"] = "angles in radian"
sheet["A2"] = 0.1
sheet["A3"] = 0.2
sheet["A4"] = 0.3
sheet["A5"] = 0.4
sheet["A6"] = 0.5
sheet["A7"] = 0.6
  
# mention performing trigonometric operations
sheet["B1"] = "Applying trigonometric function"
sheet["B2"] = "Sine"
sheet["B3"] = "Cosine"
sheet["B4"] = "Tangent"
sheet["B5"] = "Cosecant"
sheet["B6"] = "Secant"
sheet["B7"] = "Cotangent"
  
# The value in cell C1 to C7 is set to a formula 
# that calculates values for particular radian.
sheet["C1"] = "corresponding values"
sheet["C2"] = "= SIN(0.1)"
sheet["C3"] = "= COS(0.2)"
sheet["C4"] = "= TAN(0.3)"
sheet["C5"] = "= CSC(0.4)"
sheet["C6"] = "= SEC(0.5)"
sheet["C7"] = "= COT(0.6)"
  
# save the file
wb.save("simple_trigonometric.xlsx")

Выход:

Code #2 : Using hyperbolic trigonometric functions in the program.

=SINH(Number) : Returns the hyperbolic sine of a Number.
=COSH(Number) : Returns the hyperbolic cosine of a Number.
=TANH(number) : Returns the hyperbolic tangent of a Number.
=CSCH(Number) : Returns the hyperbolic cosecant of a Number.
=SECH(Number) : Returns the hyperbolic secant of a Number.
=COTH(Number) : Returns the hyperbolic cotangent of a Number.

# import openpyxl module
import openpyxl
   
# Call a Workbook() function of openpyxl 
# to create a new blank Workbook object
wb = openpyxl.Workbook()
   
# Get workbook active sheet  
# from the active attribute.
sheet = wb.active
  
# set the width of the column
sheet.column_dimensions["A"].width = 20
sheet.column_dimensions["B"].width = 30
sheet.column_dimensions["C"].width = 20
  
# writing to the cell of an excel sheet
sheet["A1"] = "angles in radian"
sheet["A2"] = 0.1
sheet["A3"] = 0.2
sheet["A4"] = 0.3
sheet["A5"] = 0.4
sheet["A6"] = 0.5
sheet["A7"] = 0.6
  
# mention performing trigonometric operations
sheet["B1"] = "Applying trigonometric function"
sheet["B2"] = "Hyperbolic Sine"
sheet["B3"] = "Hyperbolic Cosine"
sheet["B4"] = "Hyperbolic Tangent"
sheet["B5"] = "Hyperbolic Cosecant"
sheet["B6"] = "Hyperbolic Secant"
sheet["B7"] = "Hyperbolic Cotangent"
  
# The value in cell C1 to C7 is set to a formula 
# that calculates values for particular radian.
sheet["C1"] = "corresponding values"
sheet["C2"] = "= SINH(0.1)"
sheet["C3"] = "= COSH(0.2)"
sheet["C4"] = "= TANH(0.3)"
sheet["C5"] = "= CSCH(0.4)"
sheet["C6"] = "= SECH(0.5)"
sheet["C7"] = "= COTH(0.6)"
  
# save the file
wb.save("Hyperbolic_trigonometric.xlsx")

Выход:

Внимание компьютерщик! Укрепите свои основы с помощью базового курса программирования Python и изучите основы.

Для начала подготовьтесь к собеседованию. Расширьте свои концепции структур данных с помощью курса Python DS. А чтобы начать свое путешествие по машинному обучению, присоединяйтесь к курсу Машинное обучение - базовый уровень.

Python

Python | Тригонометрические операции в файле Excel с использованием openpyxl

РЕКОМЕНДУЕМЫЕ СТАТЬИ