Change Cells Alignment and Keep Existing Formatting

Possible Usage Scenarios

Sometimes, you want to change the alignment of multiple cells but also want to keep existing formatting. Aspose.Cells for Python via .NET allows you to do it using the StyleFlag.alignments property. If you set it to true, changes in alignment will take place; otherwise, they will not. Please note that the StyleFlag object is passed as a parameter to the Range.apply_style() method, which actually applies the formatting to a range of cells.

Change Cells Alignment and Keep Existing Formatting

The following sample code loads the sample Excel file, creates the range, and center‑aligns it horizontally and vertically while keeping the existing formatting intact. The screenshot below compares the sample Excel file with the output Excel file and shows that all existing formatting of the cells remains the same, except that the cells are now center‑aligned horizontally and vertically.

Sample Code