User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 363,825 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,490 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser:
Views: 805 | Replies: 14 | Solved
Reply
Join Date: Nov 2007
Location: Jogja
Posts: 2,265
Reputation: Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice 
Rep Power: 9
Solved Threads: 191
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: Export Data from listbox to Excel

  #11  
May 12th, 2008
you means :
Name (col1) | Email (col2) | Mobile (col3)
Jx_Man email 1234 (row1)
Name1 email1 4321 (row2)

MsExcel.Range("A1").Value = txtName.Text -> first Row in First Column (A)
MsExcel.Range("A2").Value = txtName.Text -> Second row in First Column (A)
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Mar 2008
Posts: 115
Reputation: sonia sardana is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
sonia sardana sonia sardana is offline Offline
Junior Poster

Re: Export Data from listbox to Excel

  #12  
May 12th, 2008
I mean --
When data is exported to Excel,it is in the foll. format-

A1 | B1 |C1
Sonia X@Y.com 9881111

in excel Column names are A1,B1,c1.

I want when we click on PRINT buttin,it appears in the foll. format in excel--
Name | Mail | Mobile
Sonia X@Y.com 9811111
Last edited by sonia sardana : May 12th, 2008 at 8:09 am.
Reply With Quote  
Join Date: Nov 2007
Location: Jogja
Posts: 2,265
Reputation: Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice 
Rep Power: 9
Solved Threads: 191
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: Export Data from listbox to Excel

  #13  
May 12th, 2008
MsExcel.Range("A1").Value = "Name"
MsExcel.Range("B1").Value = "Email"
MsExcel.Range("C1").Value = "Mobile"
MsExcel.Range("A2").Value = txtName.Text
MsExcel.Range("B2").Value = txtEmail.Text
MsExcel.Range("C2").Value = txtMobile.Text
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Join Date: Mar 2008
Posts: 115
Reputation: sonia sardana is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
sonia sardana sonia sardana is offline Offline
Junior Poster

Re: Export Data from listbox to Excel

  #14  
May 12th, 2008
THX Very Much again from my heart.
Reply With Quote  
Join Date: Nov 2007
Location: Jogja
Posts: 2,265
Reputation: Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice Jx_Man is just really nice 
Rep Power: 9
Solved Threads: 191
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Nearly a Posting Maven

Re: Export Data from listbox to Excel

  #15  
May 12th, 2008
you're welcome
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb VB.NET Marketplace
Thread Tools Display Modes

Other Threads in the VB.NET Forum

All times are GMT -4. The time now is 11:57 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC