Python | Trigonometric operations in an excel file using openpyxl



Openpyxl — it is a Python library with which you can perform several operations on Excel files like writing , math operations and plotting . Let`s see how to perform various trigonometric operations using openpyxl.

Simple trigonometric functions:

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

  • = SIN (Number): Returns the sine of an angle. The number — this is the angle in radians for which you want the sine.
  • = COS (Number): returns the cosine of the angle.
  • = TAN (Number ): Returns the tangent of an angle.
  • = CSC (number): Returns the cosecant at an angle.
  • = SEC (Number) : returns the cutting angle.
  • = COT (Number): returns the cotangent of the angle.

# import openpyxl module

import openpyxl

 
# Calling the Workbook () function from openpyxl
# create a new blank Workbook object

wb = openpyxl.Workbook ()

  
# Get worksheet of active sheet
# from active attribute.

sheet = wb.active

 
# set column width

sheet. column_dimensions [ `A` ]. width = 20

sheet.column_dimensions [ `B` ]. width = 30

sheet.column_dimensions [ `C` ]. width = 20

  
# write to Excel sheet cell

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" < / code>

sheet [ `B5` ] = "Cosecant"

sheet [ `B6` ] = "Secant"

sheet [ `B7` ] = "Cotangent"

 
# The value in cells C1 to C7 is set by the formula
#, which calculates values ​​for a specific 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 file

wb.save ( "simple_trigonometric.xlsx" )

Exit:

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 gives the hyperbolic cotangent of a number.

# import openpyxl module

import openpyxl

 
# Calling the Workbook () function from openpyxl
# create a new empty Workbook object

wb = openpyxl.Workbook ()

 
# Get the worksheet of the active sheet
# from the active attribute.

sheet = wb.active

 
# set column width  

sheet.column_dimensions [ `A` ]. width = 20

sheet.column_dimensions [ `B` ]. width = 30

sheet.column_dimensions [ ` C` ]. width = 20

 
# writing to an Excel sheet cell

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 cells C1 to C7 is set by the formula
# that calculates values ​​for a specific 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 file

wb.save ( "Hyperbolic_trigonometric.xlsx" )

Output: