Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 2005 > C# 2005
| Search | Today's Posts | Mark Forums Read
C# 2005 For discussion of Visual C# 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 3rd, 2008, 01:13 AM
Authorized User
 
Join Date: May 2007
Location: Hyderabad, Andhra Pradesh, India.
Posts: 95
Thanks: 5
Thanked 0 Times in 0 Posts
Default Reading an Excel file

Hi All

I am uploading an excel file using the Upload Control of ASP.NET 2.0. Now how can i read that excel file, so that i can modify it column values and it get stored in database.
How this can be done in C# ?



-- Abhishek

 
Old June 3rd, 2008, 02:01 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Yes, but unless you are dealing with an Excel file stored as XML (Excel 2003/2007) then you'll need Excel installed on the server. There is plenty of code online showing how to manipulate the Excel model. Just search for Excel Automation C#, http://support.microsoft.com/kb/302084 for example.

--

Joe (Microsoft MVP - XML)




Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with PHP file reading XML file for output rydog65 Beginning PHP 0 March 26th, 2008 05:13 PM
reading excel file in java uttam.mca Pro JSP 1 July 14th, 2006 07:29 PM
Reading Excel bhuvanagiri Classic ASP Components 0 May 2nd, 2005 02:24 AM
excel file reading error (adodb) ccc_storage Classic ASP Professional 1 August 22nd, 2004 07:57 PM
reading excel file msrnivas .NET Web Services 0 February 9th, 2004 06:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.