473,657 Members | 3,041 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel data manipulation in ASP.NET

1 New Member
how can i open excel file using(asp.net20 05) with C#(web application) ? then how can i open each sheet in theis file(note that excel file may contains any number of sheets )? after open sheet select any column from the sheet to make calculations (min,max,averag e,count,...etc. )?

Important Note: i want to know all (DLL) files i want to run this application

and if you can send a full project to me as soon as possible .
my email : [REMOVED]

thanx alot
Feb 10 '08 #1
2 1394
shweta123
692 Recognized Expert Contributor
Hi,

Please refer following links

Link1

Link2


how can i open excel file using(asp.net20 05) with C#(web application) ? then how can i open each sheet in theis file(note that excel file may contains any number of sheets )? after open sheet select any column from the sheet to make calculations (min,max,averag e,count,...etc. )?

Important Note: i want to know all (DLL) files i want to run this application

and if you can send a full project to me as soon as possible .
my email : black_side25@ya hoo.com

thanx alot
Feb 10 '08 #2
JamieHowarth0
533 Recognized Expert Contributor
Hi zarora,

Your email address has been removed from your post, as this is a breach in our Posting Guidelines for protecting our member's privacy.

In response to your question, no-one on The Scripts' Developer Network will write code for you, especially not an entire project.
Our experts dedicated their time and expertise to people who are making a concerted effort to program/write computer code - normally to assist in the debugging process, or to discuss general "proof of concept" and theory for computer systems.
For users like yourself to ask for an entire project to be written for you is completely unacceptable and, if repeat offences occur, will result in a ban against your account.

I suggest you try posting in our Jobs forum if you want this work done for you.
If you are a "programmer " that cannot write your own code then I also suggest you find another job that you are actually suited to.

medicineworker
Moderator and Expert (ASP Forum), TSDN
Feb 11 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

8
8349
by: Ilan | last post by:
Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though the records are sorted by row numbers. (I had to split the fields to different sheets because Excel has a limit of 256 fields in each sheet) My sheets are quite large (~55,000 rows and 200 columns each) and I'll have to repeat this action many...
9
6598
by: [Yosi] | last post by:
Can I make an Excel file without having Excel in my PC ? I want to create Excel files from my C# application , then open those files later in another PC who have Excel installed . As we can open and read from Access files in C# application without having Access in this PC in this case we install MDAC , Is there any thing similar to MDAC for Excel ? if yes where can I download it ? what is the name of the file ?
9
3144
by: Nathan | last post by:
A couple of months ago, I went looking for a .NET grid component with what I thought was pretty simple criteria - I wanted an interface that provided my users with Excel-like data entry capability. My users (mostly scientists) use Excel for just about everything and like how quick and easy it is to manipulte tabular data in Excel. For example, a partial list of data-entry features provided by Excel: - Copy/paste from one cell to many -...
2
2308
by: Jim S | last post by:
To my surprise and chagrin, newer versions of Access have disabled the functionality that lets users change the data in linked tables that point to a range in an Excel workbook. This is "because of legal issues..." according to Office Support. I have other issues, specifically a couple of applications that do things such as calculate price updates in Access and read them back by means of update queries into the spreadsheets our marketing...
3
6935
by: fkulaga | last post by:
Hi all, I have a problem with the issue in the subject, i have all data in one big excel file, in a denormalized form, and on the other side, i have mysql database with many tables, which is already in production, and it is of course in the 3rd NF. How do i go about importing that excel file , is there any good tool i could use to handle prim/foreign key issues for me? Any advice appreciated!
1
7676
by: Tom from Oakwood | last post by:
I'm writing VBA code in Excel 2000. I execute code which opens, one at a time, 10 Excel workbooks. It opens one, which does some manipulation of its own via a macro that executes upon opening, including copy / paste, then closes it and then saves it. Then it opens the next one, and so on. This process used to work fine until I modified the manipulation being done in each file to include a significant copy/paste task. Now when the file closes, I...
1
1341
by: martin DH | last post by:
Hello, I've hit a mental roadblock and could use some design ideas if anyone is willing. Access 2003, Windows XP Pro In my database is a form (HOME) that is filled with command buttons that run queries and macros. For example, a button will ask the parameters of a query to produce filtered data and the macro runs to Export the data to an Excel spreadsheet in a central location (Z:\liveReport\Export.xls). The point of this process is that...
0
1019
by: jayce | last post by:
Hi I am using an ADODB connection to link up an Access database to my core spreadsheet tool. I have created a loop to repeatedly: - download data from Access - analyse it in Excel, with data manipulation in Excel - upload the new data into Access This is working perfectly well for the first 15 iterations or so, after which I get this error message: Data file: 'C:\JC\JC dev.mdb' not found
16
5171
by: Phil Stanton | last post by:
I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub Storage_Click() On Error GoTo Err_Storage_Click
15
17373
by: pakerly | last post by:
How would i do this, convert a test file to excel? Lets say my text file has fields like this: NUMBER NAME ADDRESS PHONE 11002 Test1 TestAddress1 111-2222 lets say the number field is 10 characters long, there is a space and Name field is 15 characters long, there is a space, address can be 25 characters long, there is a space and phone is 10 characters long I want to...
0
8384
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8820
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8601
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7314
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5630
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
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 we have to send another system
2
1601
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.