21-11-2019, 05:30 AM
Note : I am using VB Express 2010
Display Excel sheet in VB.NET form
you cannot edit/format - just view it
Steps
1. Load excel file
2. convert it in to html file
3. Display the html file using web browser control
set up the form like this
![[Image: excel%2Bin%2Bvb%2Bform.PNG]](https://1.bp.blogspot.com/-kb2ZhIB38o0/XdT7ccotNtI/AAAAAAAAAjk/aHH4JK5SBCQVQo0LSv96r5cjJbPeDK7UgCLcBGAsYHQ/s1600/excel%2Bin%2Bvb%2Bform.PNG)
the out put will look like some thing in below image
![[Image: display%2Bexcel%2Bin%2Bvb.JPG]](https://1.bp.blogspot.com/-dGPDEIPbAsI/XdT7dpH90pI/AAAAAAAAAjo/Y_hCIMtlhzAg895Ofq4KGj5yveye3ZxBACLcBGAsYHQ/s1600/display%2Bexcel%2Bin%2Bvb.JPG)
code for Form.vb
Form1.vb.txt (Size: 2.13 KB / Downloads: 69)
Display Excel sheet in VB.NET form
you cannot edit/format - just view it
Steps
1. Load excel file
2. convert it in to html file
3. Display the html file using web browser control
set up the form like this
the out put will look like some thing in below image
code for Form.vb
Form1.vb.txt (Size: 2.13 KB / Downloads: 69)