Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
Hi
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
good
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
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 6,532
1 OriginalGriff 5,976
2 CPallini 2,473
3 Richard MacCutchan 1,687
4 Abhinav S 1,550


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 8 Dec 2012
Copyright © CodeProject, 1999-2014
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