Exporting to Excel in ASP.Net

Michael

I need to be able to export data from a web form into MS Excel. I know
you can do it with a VB.net windows application, but how can you do it
with an asp.net application using vb.net? Any help would be
appreciated!

Michael

Nov 18 '05 #1

Subscribe Post Reply

1740

Steve C. Orr [MVP, MCSD]

There are many different ways you can go about exporting web form data to
Excel.
This article discusses the topic in detail:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Michael" <cm********@yahoo.com> wrote in message
news:7e************************@posting.google.com ...

I need to be able to export data from a web form into MS Excel. I know
you can do it with a VB.net windows application, but how can you do it
with an asp.net application using vb.net? Any help would be
appreciated!

Michael

Nov 18 '05 #2

Rick Spiewak

Interesting article, but I wouldn't use Excel directly from ASP.NET.
Instead, if you have your data in an HTML table (a datagrid, for example)
you can download to Excel with this:

Response.ContentType = "application/vnd.ms-excel"
Response.Charset = String.Empty

Also, set .EnableViewState = False for your datagrid.

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:Ow*************@tk2msftngp13.phx.gbl...

There are many different ways you can go about exporting web form data to
Excel.
This article discusses the topic in detail:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Michael" <cm********@yahoo.com> wrote in message
news:7e************************@posting.google.com ...
I need to be able to export data from a web form into MS Excel. I know
you can do it with a VB.net windows application, but how can you do it
with an asp.net application using vb.net? Any help would be
appreciated!

Michael

Nov 18 '05 #3

by: sridevi | last post by:

Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...

.NET Framework

Exporting Years to Excel Problem

by: D | last post by:

I've created a report with many subreports of aggregate data. I want my client to be able to export this data to Excel to make her charts, etc. Only one problem: one of the fields is a "SchoolYear"...

Microsoft Access / VBA

Missing data when exporting to excel

by: G | last post by:

When I export data from access to excel by with "export" or "Analyze with" I seem to loose parts of some fields (long text strings). Is there a way to export it all to excel? Thanks G

Microsoft Access / VBA

Limitations in exporting to Excel?

by: Kenneth | last post by:

How do I remove the limitation in Access that deny me from exporting 24000 rows and 17 columns (in a query) into Excel? Kenneth

Microsoft Access / VBA

Exporting DataGrid to Excel

by: Neil | last post by:

Hi I'm currently exporting my datagrid to excel, taking advantage of the fact that excel can render html, the problem is that when i click the button to export it opens in browser, I want the button...

ASP.NET

exporting crystal report to Excel

by: Mustufa Baig | last post by:

Hi everybody, I have an ASP.NET website where clients can view their monthly billings by selecting different options. One of the option is the way they want to see the report i.e. whether they...

ASP.NET

CrystalReport.NET exporting to Excel Problem

by: Mustufa Baig | last post by:

I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream...

ASP.NET

Exporting ALL data into Excel file with Page Navigation in ASP.NET

by: bienwell | last post by:

Hi, I have a question about exporting data from datagrid control into Excel file in ASP.NET. On my Web page, I have a linkbutton "Export data". This link will call a Sub Function to perform...

ASP.NET

Standard Method for Importing/Exporting to DB

by: Snozz | last post by:

The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...

Visual Basic .NET

gridview not exporting to excel

by: Tom | last post by:

I have a gridview on all of my web pages in my web app and they all export to excel. I have one page where the gridview is binding to a datatable that i created and only the first column is...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Exporting to Excel in ASP.Net

Similar topics