C# and ExcelLibrary How to Right Align cells

c# excel excellibrary
Anthony Abouhassan picture Anthony Abouhassan · Mar 20, 2014 · Viewed 13.4k times · Source

Does anybody know how to make it so that the content passed to the sheet will right align?

Answer

Costas Vrahimis picture Costas Vrahimis · Mar 20, 2014

If you want to align one cell use

worksheet.Cells[y, x].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;

If you want to align more than one

worksheet.get_Range("A1", "A30").Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;

If you can not use Microsoft.Office.Interop.Excel then I am not really sure but you can try to use ExcelCellStyle

ExcelCellStyle titleStyle = workbook.Styles.AddStyle("WorksheetTitleStyle");
// align the text
titleStyle.Alignment.HorizontalAlignment = ExcelCellHorizontalAlignmentType.right;
titleStyle.Alignment.VerticalAlignment = ExcelCellVerticalAlignmentType.Center;

you might find more here: http://www.winnovative-software.com/ExcelLibDemo/RangesAndCells.aspx

Related questions

Can't open excel file generated with excelLibrary

I'm using excelLibrary to programatically create excel files but I get a file format error when I try to open the generated files in Microsoft Office Excel. I've seen this has been reported but there's still no answer about it. …

Read More
How to set column width of excel sheet

I am using ExcelLibrary for creating excel sheet. I need to increase width of some columns. Is there any way to achieve this? var ObjWorkBook = new Workbook(); var ObjWorkSheet = new Worksheet(ObjDataTable.TableName); ObjWorksheet.Cells[0, 0] = new Cell("FirstName"); ObjWorksheet.Cells[0, 1] = …

Read More
Output to Excel using ExcelLibrary in c#

The following code outputs to a csv file using controller.file. I want to change it to input to an excel sheet (.xls) instead of a csv file. I a using this library from here to do this.. http://code.…

Read More