VB.Net: ListView to Excel

Posted on 2012-04-09
Last Modified: 2012-04-15
Hi Experts,

I need to export the data in a ListView to be exported to an Excel.

Thanks in advance.
Question by:baabaa_nl
  • 2
  • 2

Assisted Solution

rtay earned 200 total points
ID: 37823905
An easy way would be to create a SSRS report (embeded or not) based on the same query and use the report export function to save to Excell.

Author Comment

ID: 37823999
Could you please give me a code or the link for the SSRS report.
Thanks in advance.

Assisted Solution

rtay earned 200 total points
ID: 37824039
In Visual Studio, right click on your project in the solution explorer.
Add new item
create a test report using the wizard.
Once you create the report, go add a new windows form to your project and from the tool box, under reporting add a Microsoft report viewer to the form.  using the tag in the report viewer item, point to the report you just created.  

Create a link to that new form from your list view form.  

Here is more information on SSRS reports.
LVL 83

Accepted Solution

CodeCruiser earned 300 total points
ID: 37832975

Author Comment

ID: 37846365
Hi CodeCruiser,

The link you give me is for exporting data to excel from the Dataset.

But I need to export data to excel from a ListView

Thanks in advance.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DataGridview Currency Formating? 22 52
Round up to 100% in .NET 10 80
Duplicating a tab page content to another in TabControl control 11 40
Exit the loop 4 31
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now