 # 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: