Skip to Main Content
Extending Excel with Python and R
book

Extending Excel with Python and R

by Steven Sanderson, David Kun
April 2024
Beginner to intermediate content levelBeginner to intermediate
344 pages
7h 56m
English
Packt Publishing
Content preview from Extending Excel with Python and R

5

Formatting Your Excel Sheet

In this chapter, we are going to go over two different libraries in R and various libraries in Python that can be used to format tables and data in an Excel worksheet.

There are several packages in R that we will be discussing, including the following:

  • styledTables
  • basictabler

We are going to create some fictitious data along with using one of R’s built-in datasets, Iris, and then we are going to apply styling to it from the aforementioned packages. Each package will have its methods to apply this styling, so it’s good to go over them and see which type of workflow you prefer.

In the Python section of this chapter, we will explore the advanced options available in pandas and openpyxl to create beautiful tables ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Visualization with Python and JavaScript, 2nd Edition

Data Visualization with Python and JavaScript, 2nd Edition

Kyran Dale
Python for Excel

Python for Excel

Felix Zumstein

Publisher Resources

ISBN: 9781804610695Supplemental Content