range.putValue

Aspose.Cells Product Family
1

I’m currently evaluating Aspose.Cells by porting an excel automation solution …

I have this code working but don’t see how to implement this using Aspose.Cells

Private Sub pasteValues(ByRef rng As excel.range)
If Not IsNothing(rng) Then
rng.Value = rng.Value
End If
End Sub



i’m trying to remove formulas

do i have to pass an Aspose.cells.range and iterate over each cell?

2

Please check Aspose.Cells and our demos source code for more information.

For this case, it's very easy.

//Put value to Cell A1

workbook.Worksheets[0].Cells["A1"].PutValue("hello");

// or

workbook.Worksheets[0].Cells[0, 0].PutValue("hello");

//Put values to range A1:B2

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

for(int j = 0; j < 2; j ++)

workbook.Worksheets[0].Cells[i, j].PutValue(i);

3

yeah - it’s pretty easy to iterate - but it’s even easier to just set something for the range.

I have the same issue for setting the background color etc.
Maybe it’s a nice feature enhancement to add the interation to a range put_Value and style properties…

Thanks for the quick response!

Brad

4

Hi Brad,

Thank you for this suggestion. I will consider it.

For Style properties issue, we already provide a Range.Style property.