Well, you may use InsertRow, InsertRows and InsertRange methods of Aspose.Cells.Cells class for inserting your additional headers rows/cell ranges at your specified locations. For inserting data to the worksheet cells you may use Cell.PutValue() method and for formatting cells you may use Style object attributes.
Please check Aspose.Cells wiki docs:
Especially the following links which might be your requirement:
and for formatting please check: "Working with Data Formatting" section on the wiki docs.
Moreover, you may check the source code of our featured demos:
( the demos are automatically installed when you install the component using its msi installer, so you may open the demo projects into VS.NET and check the source)
Thank you.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.