Hi guys,

i would like to ask that is there anyway to embedded an excel file into a vb.net project? i know the way to read an excel file from vb.net, but i would wanna know is there anyway i can include the excel file inside the vb.net program. This means i dun need another excel file beside the exe file. any replied would be appreciated. =) thanks in advance.

Re: Excel for VB.net 80 80

>is there anyway to embedded an excel file into a vb.net project?
Yes. Add -> Existing Item -> then selecting the .xls file. Then edit the properties of file BuildAction with embedded resource.

Re: Excel for VB.net 80 80

yes i have successfully add the xls file into the program, but how i access to the data inside the xls file, for e.g if the xls is not embedded, i be able to use streamreader to access the data, but is there any other way for this method? thanks once again.

Re: Excel for VB.net 80 80

>is there any other way for this method?

Use Assembly.GetManifestResourceStream() method.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.