Export Pivot Table

Bronze Certified

Custom Activity

0 reviews

6

Export Pivot Table

Bronze Certified

Custom Activity

0 reviews

6


Summary

This activity helps to export your pivot table directly to HTML or as an image, so can be later used in email bodies or presentations.

carouselImage0

Overview

Now, to include a pivot table directly in a mail body will be a difficult task, we need to find the range where the pivot table lies, then read it and create a table from codes, and it will be again more difficult if you need to preserve the original formatting (colors or others) of the original pivot table in the Excel file.

Export Pivot Table activity helps to embed the pivot table directly to your mail body or you can get the pivot table as an image, which can be used in the presentations or PPT's.

The inputs required will be:
  • Path of the Excel file
  • Sheet Name
  • Pivot Table Name

Benefits

  • Export pivot tables by preserving the format.
  • Embed directly to mail body.
  • Easy to use.
  • Faster execution.

Published: 11 Jan 2022 | Updated: 11 Jan 2022

Anas Pv
RPA Pre-Sales Engineer

License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

Windows Legacy (.Net Framework 4.6.1)


Tags

excel
pivot
table

Compatibility

Studio: 21.4+


Dependencies

CoreHtmlToImage


Similar Listings