Fixed value in new column of all rows

Aspose.Cells Product Family
1

Hi Team,

I copied the data from one sheet other sheet (Specific two cloumns), I need to add one more column in destination sheet and need to update fixed value for all rows of that column (Based on the number of rows available in the copied columns.). Please help me in this.

Regards,
Bharat.v

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Could you please clarify your requirement using sample xls/xlsx file which you can create manually using Ms-Excel 2010 and attach here?

Also, you can iteratively add values in an entire column.

e.g

C#


//insert values from D1 till D100

for (int i = 0; i < 100; i++)

{

worksheet.Cells[i, 3].PutValue("Your Value: " + i);

}