Column span multiple rows

Aspose.Cells Product Family
1

Hi,

I have multiple values to display in a column, which I would like to display in multiple rows... that means other columns will have only one value. Is this possible to acheive using Aspose Cells

This message was posted using Banckle Live Chat 2 Forum
2

Hi,

I am not sure about your need.

If you need to wrap text in a cell of the column, see the document (check “Wrapping Text” sub-topic):
https://docs.aspose.com/display/cellsnet/Configuring+Alignment+Settings

If you need to merge cells, see the document for your reference:
https://docs.aspose.com/display/cellsnet/Merge+and+Unmerge+Cells

If you still have any confusion or issue, kindly give me a sample Excel file (manually created in Ms Excel) to show your requirement, we will guide you through how to implement it (we may refer some documents or API).

thank you.


3

Hi,


What I understand from your scenario is that you need to use Merge Cells in your worksheet to achieve your goal. Please go through the following links for technical articles on the subject and feel free to write back.

JAVA
https://docs.aspose.com/display/cellsjava/Merging+and+Unmerging+Cells

.NET
https://docs.aspose.com/display/cellsnet/Merge+and+Unmerge+Cells