Skip to main content

Posts

Showing posts with the label latex multicolumn table

How to create table in Latex from MS Excel files or other external databases

Latex can be used to create tables from external files such as MS-Excel files saved as comma separated values or similarly many other formats. Recently, I received a comment where a reader suggested that I should post a tutorial on how to create tables in Latex from external files. I searched around and found multiple ways to achieve this. I am going to talk about two of the most popular ways of doing it. First one is using pgfplotstable and the second one is using datatool package. Specifiacally, we are going to learn the following in this tutorial: Using datatool package to load external files Usng MS-Excel files to create tables in Latex Using \DTLloaddb to set keys and use external files Using \DTLforeach to iterate the external file Using \pgfplotstable package Using \booktabs package Using pgfplotstabletypeset Styling each column of table Using style rules from booktabs package The following video tutorial explains both metho...