Equivalent for Col,Row ,Col2 and Row2 in Dot Net spread,

Equivalent for Col,Row ,Col2 and Row2 in Dot Net spread,

Posted by: adarshab039 on 11 September 2018, 2:11 am EST

• 

  adarshab039

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 September 2018, 2:11 am EST

  what is the replacement of COM Col,Row , Col2 and Row2 in Dot Net spread. Please find the code for COM spread, looking equivalent for Dot Net spread,.

  sprSpread.Col = 1
  
  sprSpread.Row = 1
  
  sprSpread.Col2 = sprSpread.MaxCols

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 11 September 2018, 8:37 pm EST

  Hello,

  The Spread .NET equivalent code for getting and settings the cell value is :

  FpSpread1.ActiveSheet.Cells(RowIndex, ColumnIndex).Text= “Test”
  
  FpSpread1.ActiveSheet.Cells(0, 0).Text= “Test”

  Row and Column index in Spread .NET are 0 based unlike Spread COM where it is 1 based.

  To set the text for a range of cells you can use:

  FpSpread1.ActiveSheet.Cells(RowIndex, ColumnIndex, RowCount, ColumnCount).Text= “Test”

  I would suggest you to go through the documentation to understand Spread NET here:
  
  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#spwin-devguide.html

  Thanks,
  
  Deepak Sharma