Click here to Skip to main content
12,551,121 members (50,713 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
I Use DCOM Excel component for export my data to Excel . but I face to 2 problems:
1- How can I set align of a text in a cell ? set it to right , left or center. For example worksheet.cell[1,2].align = “right”;
2- Suppose Contains of a cell is a number . I wants to separate it’s digits by separator (3 digits by 3 digits) for example : 34567898 to 34,567,898
Thanks very much
Posted 7-Dec-12 19:54pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

worksheet.Cells[1, 2].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;

and I think the answer to the 2nd bit is

worksheet.Cells[1, 2].Style = "Comma" - if not then try the CellFormat.NumberFormat property on the cell

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.161021.1 | Last Updated 8 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100