Embed Excel Sheet into VB 2008

Question

Please I need help here...

I have a workbook - called School Project.xlsx in My Document folder.  I want to Embed this Workbook into my Form1 in Visual Basic so that the Worksheet can be edited via my Form1 in Visual Basic 2008 Project.

Please can someone kindly help me with the necessary code...

Answer 1

reading-excel-2007-xlsx-in-vbnet.htm

Not a simple task.......

Also if you want to make an application that reads xlsx files then post here, but if you want to edit xlsx files, it would be done better and more effiecently in exel with the use of its Functions and so on, so rather post here.

---

*Kitty-Cat-Lemon*

Answer 2

Hi Eni4real,

Welcome to the MSDN forum.

What do you mean about “Embed it into Form”? Do you like to open the Excel in the application and you can edit it? If yes, I’m afraid the easiest way is uploading your excel to Skydrive, and using webbrowser to load the specific web page to edit the file.

Another solution is read the Excel into webbrowser directly, but it will limited by the version of IE and Office (under  office 2010 and under IE 10). Parts of them written in C#, you can use the C# to VB.Net convertor to read it:

How to use the WebBrowser control to open an Office document: http://support.microsoft.com/kb/243058

navigate to specific excel sheet with web browser control: http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/55bc26d9-e4df-4899-815d-28cae588dd99

Hope this helps.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi Eni4real,

We haven’t heard from you for several days. I’d like to mark the helpful replies as answer firstly. If you have any additional questions, you also can unmark the replay and post your question here.

Sorry for any inconvenience and have a nice day.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us