Format Borders


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)

img1


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

Step 1:

Select the Borders Button in the Formattab to open this dialogue box.

img2


Step 2:

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

img3


Step 3:

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

img4


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

The Output is shown below

img5


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.