Free Support Forum - aspose.com

Column span multiple rows

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

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.


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