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.
Jump to Post>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.
>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.
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.
>is there any other way for this method?
Use Assembly.GetManifestResourceStream() method.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.