Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 131,795 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,547 people online right now. Registration is fast and FREE... Join Now!




Write to an excel file with vb .net

 
Reply to this topicStart new topic

Write to an excel file with vb .net

avolel
post 12 May, 2006 - 08:32 AM
Post #1


New D.I.C Head

*
Joined: 24 Aug, 2005
Posts: 38



Thanked 1 times
My Contributions


Hi there

Does anyone know how to write data to an excel file. I've tried using StreamWriter but to no avail. When I write to the file all data ends up in the first column. Your help is greatly appreciated.
Thank You
User is offlineProfile CardPM

Go to the top of the page

Amadeus
post 12 May, 2006 - 10:14 AM
Post #2


g++ -o drink whiskey.cpp

Group Icon
Joined: 12 Jul, 2002
Posts: 12,165



Thanked 32 times

Dream Kudos: 25
My Contributions


Are you specifying the cells in which you want to write? See example here:
http://www.ragingsmurf.com/code.aspx?key=3JBXWMQ30V
If you post the code you're using, we may be better able to guide you....
User is offlineProfile CardPM

Go to the top of the page

avolel
post 12 May, 2006 - 10:41 AM
Post #3


New D.I.C Head

*
Joined: 24 Aug, 2005
Posts: 38



Thanked 1 times
My Contributions


I see how to write to an excel file but I do not have the classes that are used.

I already have "Imports System.IO and Imports System.Runtime.InteropServices" imported but the classes I need are not present, so this will not work:

Dim e As New Excel.Application()

Can you tell me where I can find those classes or a VS 2005 update that incorporates the necessary classes need to write to and read from an excel file.

Thank You
User is offlineProfile CardPM

Go to the top of the page

manju
post 9 Mar, 2007 - 01:59 AM
Post #4


New D.I.C Head

*
Joined: 9 Mar, 2007
Posts: 1


My Contributions


QUOTE(Amadeus @ 12 May, 2006 - 11:14 AM) *

Are you specifying the cells in which you want to write? See example here:
http://www.ragingsmurf.com/code.aspx?key=3JBXWMQ30V
If you post the code you're using, we may be better able to guide you....


Try

http://www.c-sharpcorner.com/UploadFile/mg...Viewin.NET.aspx
User is offlineProfile CardPM

Go to the top of the page

gever
post 26 Aug, 2008 - 12:39 AM
Post #5


New D.I.C Head

*
Joined: 19 Jun, 2008
Posts: 16

check the follwoing link on step by step help to create an excel file

http://vb.net-informations.com/excel-2007/...create_file.htm

User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/20/08 04:59PM

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month