473,386 Members | 1,698 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Read Data From an Excel File (.xls/html/.xlsx) in ASP.NET

Manikgisl
HI

We need to open the excel document which may contian different versions

.xls
.html format
.xlsx
.csv

The problem:

we are developing online test application...For that the we prepare questions and answers thru import d excel and load into database


While creating a fresh question for fresh test for No problem...the format will be .xls
if we had already questions for that test ......we usually export to excel and allow to enduser to add the questions and answers...

While exporting to excel it get exported as html format.


pls help me out.......
Either opening excel document for reading (.xls/html/.xlsx)

Either while export it will get export to normal excel document


The Application is not working in asp.net

we searched but we code for export to excel in the html format



Thanks in advance


Regards,


Mani
Mar 26 '10 #1
1 2379
SammyB
807 Expert 512MB
Googling Excel ASP.NET gives several examples of these sort of operations. Have you tried these examples?
Mar 26 '10 #2

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

Similar topics

0
by: Daniel Chartier | last post by:
Hello, all. I found a bit of code that lets me read an Excel file from and to a specifi range. See the code below. But what if I only want to specify the STARTING position and simply want it...
3
by: tvn007 | last post by:
I wrote the code below to read data from file into structure using C. However, I would like to convert it to C++. Could someone please give me some hints. I am not that famaliar with C++ Thanks...
10
by: sarunnio | last post by:
How do I read an excel file to display the worksheet on the web. Can I make use of some excel automation to programmatically manipulate the excel file via the web browser. Thanks in advance. ...
4
by: Reny J Joseph Thuthikattu | last post by:
Hi, Can any one guide me to read an excel file using vb.net? Reagrds Reny --- Outgoing mail is certified Virus Free.
1
by: Ultima | last post by:
I have searched the group and it seems this question has been asked and answered before, yet I still can't fix it after applying the answers I found. Basically, when I open an existing Excel...
3
by: rohitkumar | last post by:
i have to read a excel file in fornt end essentially in asp/c#.net. the row column value from the excel file has to be assigned to c# variable for further processing. i wanna know how to open...
1
by: mzmishra | last post by:
Hi, Can anybody send me the code sample to read one excel file and write the content of the excel file to database.It is very urgent . Please help me on the same.
2
by: justin | last post by:
Hi , I have the following code which reads the first line of the Excel file and comes out of the loop. The test.xls file conmatains two columns in which first column has numerical data and...
5
by: minhtran | last post by:
Hello everyone! I have a project as to read the Excel file and load into mySQL database, but my coding is to read only 100 first rows, how can we read all rows from .XLS sheet. Please, anyone can...
7
by: dillipkumar | last post by:
Hi, Can anybody tell me how to read an excel file. I have written a script, it is not working with multi sheets. And also i want to print all workshet present in the excel file. use...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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$) { } ...
0
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...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...

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.