In the attached spreadsheet, if you look at the Noth America Interests, my problem is that for a person, the number of interests could vary. If there is a lot of them, it would go into the Outside North America interests. Using Aspose Cells, how can I approach this problem where I can dynamically insert as many North America Interests as there are, and still remain within the range bounded by the thick borders, i.e. not go into the Outside North America interests.
The cells "North America" and "Outside North America" are in the designer workbook, and rest of the data is going to be populated dynamically.
I have checked your template excel file. Aspose.Cells provides certain APIs for your desired tasks and you may utilize these easy to use APIs for your scenario. You may use InsertRows, InsertRow and InsertColumn methods of Cells class for inserting new rows and columns dynamically for your need at your required location within your file. For insrting data, you may use Cell.PutValue()method to insert any type of data at runtime into the cells. For formatting cells (number formats, borders, cell colors, font attributes, text orientaion, text alignment etc.), you may use certain Properties and methods of the Style class.
I paste a few wiki links, you may check them for your need:
If you have any problem, feel free to contact us any time and we will be happy to guide you.