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

## Shop Learn programming in R: courses

\$ Best Python online courses for 2022

\$ Best laptop for Fortnite

\$ Best laptop for Excel

\$ Best laptop for Solidworks

\$ Best laptop for Roblox

\$ Best computer for crypto mining

\$ Best laptop for Sims 4

\$

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

NUMPYNUMPY

How to convert Nonetype to int or string?

NUMPYNUMPY

How to specify multiple return types using type-hints

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

## Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method