Create an excel by using c# coding internally give an issue in the performance of the application process. This is especially when deal with large data. There are several way to increase the performance of your application. Here we suggest to you the most simple way to increase your application.

//Increase performance
            SpreadsheetForm.Visible = false;
            //Insert your coding process here
            SpreadsheetForm.Visible = true;

 

Description

  1. The above coding used to increase your c# application when deal with excel
  2. When you run your application with showing the process, excel will refresh each of the data one by one but when you run your application without showing the process, this thing will reduce time taken to refresh one by one data. Excel will refresh just one time.
  3. Method to used it,  just add visibility of the spreadsheet before and after your coding.

Leave a Reply