How to transform an Excel sheet in a latex table using Python

1 min

Sometimes it might be useful to take an excel sheet and transform it into a latex table.

Here is how

# Pandas to read the excel file
import pandas as pd

# We read the excel file as a dataframe
df = pd.read_excel("my_excel_file.xlsx")

# We save the dataframe into a latex table
df.to_latex("my_excel_sheet.tex")

Here you are, you now know how to transform an excel sheet in a latex table using Python.

More on DataFrames

If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :

Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.