How to Insert a Row Object into a Worksheet

Aspose.Cells Product Family
1

We are trying to create an Aspose Row Object and Populated it’s Cells:
Dim xlsRow as Aspose.Cells.Row
Once that is done, then
How can we now simply Insert That ENTIRE ROW of Data into a Worksheet?
We were hoping for something like: xlsSheet.Cells.AddRow(xlsRow)

2

@jeanjunker1,

You may copy row/column for your needs, see the document with example code for your reference:
Copying Rows and Columns

3

OK, Thanks I see that.

BUT, That requires a worksheet (or two) to copy/paste into.

We want to just create ROW Objects, store them say into a Collection and then create the Worksheets from them later. It seems that this is not possible. My read on your suggestion implies to me that the “Row” Object (or class) does not actually persist or hold any data and that a Sheet Object is require to do that. Correct?

4

@jeanjunker1,

Aspose.Cells provides number of data importing options. For example, you may store data using variety of .NET objects, e.g DataTable, Arrays, ArrayList, CustomObjects, JSON, etc. Now use relevant Worksheet.Cells.ImportXXXX method to import data into the worksheet cells. See the document on how to import data into worksheet with examples for your reference.

Let us know if you still have any confusion or issue.