Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Wed Jan 19, 2011 7:36 am

I want to import data into Excel, I want to use the header row with merged cells. I wonder how to do it?

Finalsky
 
Posts: 13
Joined: Wed Dec 22, 2010 1:12 am

Wed Jan 19, 2011 9:11 am

Thank you for your inquiry.
You can use the sheet.Range[].Merge() method to merge the cells. Such as: sheet.Range["A1:B1"].Merge(); It merges "A1" and "B1" cells.
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS