How to change the default number of rows and columns in SpreadSheet Control

[kenny Niu]

hello:

 

          How to change the default number of rows and columns in SpreadSheet Control?

 

            Thanks in advance

            

              Kenny

[Saravanan M]

Hi Kenny,
             

You can achieve your requirement by setting default row and column count like below code snippet.

Code Snippet[C#]:

spreadsheet.ExcelProperties.DefaultRowCount = 50;

spreadsheet.ExcelProperties.DefaultColumnCount = 50;

Please let us know if you have any queries.

Thanks&Regards,

M.Saravanan.