Format Borders

FormatBorders.SK is used to apply table border to the dynamic data.


This function is one of the format functions in SheetKraft. The others are FormatCellContents.SK and FormatAsTable.SK

To access these format functions, go to the more section and then the Format tab. (See figure)

The following guidelines describe how to format data as desired before exporting it.

Step 1:

Select the Borders Button in the Format tab to open this dialogue box.

Step 2:

Choose the range of cells which have the desired border formats to be applied to the data range.

Step 3:

Select the data range to which the borders have to be applied.

The Precedent option is used if some other function has to be calculated before applying this format function.

The Output is shown below

Note: While using Format Borders use a small data set. If the amount of data is large then it’s better to go for FormatAsTable.SK as the runtime would be faster.