Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0 ASP:NET
Its nice to set the width of column in XML for export to Excel using
string builder.
Is it possible to set the border for cell like excel in XML
for export to Excel using string builder.? and How?
Thanks in advance for quick reply.
Posted 18-Dec-12 18:00pm
umesh23670

1 solution

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

Solution 1

If you want to set border in xml format, you must first know the format. Why not first export xml to Excel and then, add cell border in Excel file, that would be more easier. Here you can see how to export xml to excel:
 
Generate Excel from XML and Generate XML from Excel[^]
 
Then set cell border by below code:
sheet.Range["B2"].Borders.LineStyle = LineStyleType.Thick;
        sheet.Range["B2"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
        sheet.Range["B2"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
        sheet.Range["B2"].Borders.Color = Color.Red;
        sheet.AutoFitColumn(2);
  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 470
1 mhegazy94 460
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,135
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,619
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web03 | 2.8.140922.1 | Last Updated 19 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