Click here to Skip to main content
Rate this: bad
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 19:00pm

1 solution

Rate this: bad
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;

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 531
1 OriginalGriff 315
2 Maciej Los 295
3 Peter Leow 260
4 CPallini 180
0 Sergey Alexandrovich Kryukov 7,138
1 OriginalGriff 5,577
2 Peter Leow 4,097
3 Mika Wendelius 2,850
4 CHill60 2,818

Advertise | Privacy | Mobile
Web04 | 2.8.150224.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2015
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