Alignment in Export to Excel

HCL Domino Domino Forum
1

Hi,

I have a Export to Excel button in a view. On click of that all documents in the view will be exported to excel. Thats working fine, but some of the values in the columns are not aligned properly. I want to have all values in all columns in the excel to be right justified.

Can anyone let me know how to go about this.

Thanks in advance.

2

Subject: Alignment in Export to Excel

Are you creating Excel document on Fly… or you are using this as template… to populate the values…

3

Subject: RE: Alignment in Export to Excel

From a notes view on click of a button i am having this export done. I am creating the excel object in the code.

4

Subject: Alignment in Export to Excel

Try this

xlApp.Range(“A1:A5”).Select

With xlApp.Selection

.HorizontalAlignment = xlRight

.font.name="Arial"

.font.size=12

.font.bold=True

End With