Read the data from Excel Sheet and bind it to Gridview in asp.net

Here i will explain how to read the data from Excel sheet and bind that data to gridview in asp.net

1) First take one upload control, one button and one gridview like this

How to Make Some cells Read only in Excel Sheet and other should be editable

In Excel sheet we can make some cells read only and some cells editable by using these following steps

1) First Select whole Excel Sheet by Ctrl+A After that

2) Right Click on excel sheet you will find Format Cells Option that screen look like this