Skip to Content (Press Enter)
UserImage.jpg
Eruthia Raj
34Views
2Comments
Solved
How to implement cell VAlign and HAlign in new EPPlus Excel Package
Question
Component
Forge

Hi members,

Previously I was used old EPPlus  Excel Package which contain cell alignment properties in CellRangeFormat action.

I have update the Excel Package to new version which doesn't contain CellRangeFormat anymore. I'm trying to replace CellRangeFormat with Cell_FormatRange. But the new once doesn't support VAlign and HAlign. 

Any idea how to implement it in Cell_FormatRange? Below are the screenshots of old and new actions.

Old way:

 New way:

Thanks,

Raj

0
0
25 May 2021
Copy Link
2021-11-18 18-03-41
AJ.
Solution

Hello @Eruthia Raj,

I encountered the same issue as you but fortunately had the option to switch to Advanced Excel which also uses EPPlus under the hood and allows for horizontal / vertical alignment options as shown below:


Hope this helps,

Regards,

AJ


1
0
27 May 2021
Copy Link
UserImage.jpg
Eruthia Raj

Hi AJ,

Thanks for the reply and clean explanation with an example. Let me try this. 

Regards,

Raj

1
0
27 May 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.