{"id":1684,"date":"2023-07-06T14:04:56","date_gmt":"2023-07-06T14:04:56","guid":{"rendered":"https:\/\/www.pyxll.com\/blog\/?p=1684"},"modified":"2023-07-06T18:13:18","modified_gmt":"2023-07-06T18:13:18","slug":"custom-fill-formatter","status":"publish","type":"post","link":"https:\/\/www.pyxll.com\/blog\/custom-fill-formatter\/","title":{"rendered":"Writing a Custom Excel Function Formatter: “Fill Down” Formatting"},"content":{"rendered":"\n

PyXLL makes returning arrays and DataFrames of data from Python to Excel simple. Python functions can return entire tables of data directly into Excel as user defined function (or UDF). All we require to do that is PyXLL’s @xl_func decorator.<\/p>\n\n\n\n

Python Array Functions in Excel: https:\/\/www.pyxll.com\/docs\/userguide\/udfs\/arrayfuncs.html<\/a><\/p>\n\n\n\n

But what if you want to format your data in Excel? Often you will want to return columns in a specific format, as percentages or with date formatting, for example. PyXLL has a solution to that! Use a formatter<\/em> when declaring your worksheet function and PyXLL will format the result when returning Excel.<\/p>\n\n\n\n

Cell Formatting: https:\/\/www.pyxll.com\/docs\/userguide\/formatting\/index.html<\/a><\/p>\n\n\n\n

PyXLL includes several standard formatters for common cases such as formatting DataFrames. Formatters are also composable. Try adding them together if you want to apply multiple formatters at the same time.<\/p>\n\n\n\n

And if none of the standard formatters, or combinations of standard formatters, are capable of doing what you need? Write a custom formatter! In the rest of this article we will explore how to write a custom formatter.<\/p>\n\n\n\n

\n

Table of Contents<\/p>\n