Data extraction to Excel in ASP.Net C# Webform

Jason Huang

Hi,

Would someone show me how to do the data extraction to Excel in ASP.Net
using C# web form?
I am not familiar with VB, so I am asking someone to help me out!
Any help will be appreciated.

Jason

Nov 17 '05 #1

Subscribe Reply

2961

Rahul Anand

"Jason Huang" wrote:

Hi,

Would someone show me how to do the data extraction to Excel in ASP.Net
using C# web form?
I am not familiar with VB, so I am asking someone to help me out!
Any help will be appreciated.

Jason

I have suggested the possible solution under another thread "from datagrid
to excel table". I hope it will help.

For more information check:
http://www.codeproject.com/aspnet/DA...ortToExcel.asp

--
Cheers,
Rahul Anand

Nov 17 '05 #2

Jason Huang

Thanks Rahul,

I've done the exporting DataGrid to Excel part. Thanks for your advice.
Actually, the Microsoft Enterprise Library took me a while for "using
Microsoft.Practices.EnterpriseLibrary.Data".
But I'm thinking is it possble to do the data extraction directly from the
dataset, not firstly stored in the datagrid?
Thanks for help.

Jason
"Rahul Anand" <Ra********@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:C9********************************* *@microsoft.com...

"Jason Huang" wrote:
Hi,

Would someone show me how to do the data extraction to Excel in ASP.Net
using C# web form?
I am not familiar with VB, so I am asking someone to help me out!
Any help will be appreciated.

Jason

I have suggested the possible solution under another thread "from datagrid
to excel table". I hope it will help.

For more information check:
http://www.codeproject.com/aspnet/DA...ortToExcel.asp

--
Cheers,
Rahul Anand

Nov 17 '05 #3

Similar topics

3154

STPT - An ASCII data parsing tool

by: Glenn Gomes | last post by:

STPT is an invaluable tool if you need to import or extract data from any text (ASCII) file. STPT data makes dealing with ASCII data easy and efficient through a graphical user interface where...

Visual Basic 4 / 5 / 6

4261

passing form data to an email address/Excel sheet on a local computer

by: sifar | last post by:

Hi, I am right now learning PHP & want to know if there is a way to send web form data to an Excel sheet located on a network. My windows xp PC doesnot have a copy of Excel. Also i am not...

PHP

3374

about asp.net excel and clipboard

by: Ê¹ÃûÑï | last post by:

hi: purpose: clone the firest sheet in Excel.xls into excel2.xls here is my code it well done in winform£º ------------------------------- string SubFile=@"D:\Excel2.xls"; string...

C# / C Sharp

1422

Passing asp.net form data to a new browser window.

by: Souri Challa | last post by:

Hi all, Is there any way to pass a large amount of data from an asp.net form to another browser window opened through client script ? (i.e without using sessions ). Here is my scenario.I've a...

ASP.NET

1944

Data extraction from MS Word file

by: madhukp | last post by:

Hello Everybody, I am fairly new to ASP.Net. I have a requirement to extract data from a number of similar word files and put it into database. Eventhough I could do it with VB.Net, I am not...

ASP.NET

403

Export to Excel

by: Diego | last post by:

Hi, I have a ASP.NET application and i'm interested in reporting in excel format. I read a good artile written by Steve C. Orr that gave me info about exporting to excel. ...

ASP.NET

1896

vb.net webform on 2000 returns "Bad variable type" for Excel

by: David Reynolds | last post by:

Hi Everybody, I have a vb.net webform where I create the Excel application/workbook/worksheet. On Windows 2000 server for some reason, I keep getting an error("Bad variable type") when trying...

ASP.NET

1035

Excel based query for SQL-data extraction to excel

by: Tbell | last post by:

Hi, Im looking at an excel spreadsheet with about 3500 rows in it, and in each row there is an id number, i would like to create a query that takes each of these rows and compares it to the...

Microsoft SQL Server

3017

I lose data, when I try to save a loaded DataTable on the click ofanother button in an asp.net webform

by: chike_oji | last post by:

Please can someone help me. I am writing a web application, that allows for the upload of an excel sheet into the database. I have an upload button and a save button. The upload button allows...

C# / C Sharp

7054

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7057

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7102

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6756

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7003

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5357

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4798

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA

4495

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

1310

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp