Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
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
-
iceblue support
-
- Posts: 240
- Joined: Tue Dec 21, 2010 2:56 am