473,396 Members | 1,997 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,396 software developers and data experts.

Read/Write from Excel using ASP.Net

Hi,
I've got an Excel file that calculates various engineering formulas,
and uses VBA to perform certain tasks essential to the calculations,
and I now need to make an ASP.Net page that allows someone to input
data into a web form, and be inputted into cells in excel, then return
the overall result to a web page (whether the same page or not I do
not believe matters). I know a little bit of C# and have a reasonable
level of understanding of VB, but cannot think of a way to make Excel
interface with ASP.Net.

Any help would be much appreciated.
Mar 25 '08 #1
5 1898
"DaveBinM" <Br*********@gmail.comwrote in message
news:54**********************************@i12g2000 prf.googlegroups.com...
I've got an Excel file that calculates various engineering formulas,
and uses VBA to perform certain tasks essential to the calculations,
and I now need to make an ASP.Net page that allows someone to input
data into a web form, and be input into cells in excel, then return
the overall result to a web page (whether the same page or not I do
not believe matters). I know a little bit of C# and have a reasonable
level of understanding of VB, but cannot think of a way to make Excel
interface with ASP.Net.
http://www.aspose.com/categories/fil...a/default.aspx

Don't even consider server-side Office automation:
http://support.microsoft.com/default...US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Mar 25 '08 #2
"DaveBinM" <Br*********@gmail.comwrote in message
news:f6**********************************@d21g2000 prf.googlegroups.com...
I'm not sure if that would affect the stability given the small number of
users,
and I doubt there would be more than one user at a time.
If you're referring to server-side Office automation, the number of
(concurrent) users is irrelevant - that's not what makes it unstable...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Mar 25 '08 #3
On Mar 25, 4:11*pm, "Mark Rae [MVP]" <m...@markNOSPAMrae.netwrote:
"DaveBinM" <Brydo.Sk...@gmail.comwrote in message

news:f6**********************************@d21g2000 prf.googlegroups.com...
I'm not sure if that would affect the stability given the small number of
users,
and I doubt there would be more than one user at a time.

If you're referring to server-side Office automation, the number of
(concurrent) users is irrelevant - that's not what makes it unstable...

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net
Okay, I will endeavour to find an alternative solution to my problem,
thank you very much for your help.
Mar 25 '08 #4
"DaveBinM" <Br*********@gmail.comwrote in message
news:7b**********************************@s19g2000 prg.googlegroups.com...
Okay, I will endeavour to find an alternative solution to my problem,
thank you very much for your help.
I've already provided you with an alternative solution:
http://www.aspose.com/categories/fil...a/default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Mar 25 '08 #5
On Mar 25, 4:44*pm, "Mark Rae [MVP]" <m...@markNOSPAMrae.netwrote:
"DaveBinM" <Brydo.Sk...@gmail.comwrote in message

news:7b**********************************@s19g2000 prg.googlegroups.com...
Okay, I will endeavour to find an alternative solution to my problem,
thank you very much for your help.

I've already provided you with an alternative solution:http://www.aspose.com/categories/fil.../aspose.cells-...

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net
Oh, yes, thank you for that.
Mar 25 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: see_mun_lee | last post by:
I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). <META...
2
by: newtophp2000 | last post by:
I created a system DSN for an Excel file and I have been using it for a while. I can read from it as well as update it. (The Excel file includes weekly updates to some records.) Then I tried...
10
by: QQ | last post by:
I am trying to read data from Excel files I use the following codes, however, it didn't work Can anyone tell me what the format excel files have, what I should do to read it from C? Thanks a...
4
by: Hardy Wang | last post by:
Hi all, I have following code to read Excel content into a DataSet string connection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=\"Excel...
2
by: Scott M. Lyon | last post by:
I currently am working on a VB.NET application that imports data from an Excel spreadsheet that the customer filled in. I used the following code to use ODBC to read the data from the...
4
by: Seok Bee | last post by:
Dear Experts, I have created a script to extract the Event Logs from the system into an excel sheet. The logs are separated into 2 worksheets (Application Log and System Log). After this excel...
1
by: ashok0866 | last post by:
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel. The issue...
1
by: prmukkundi | last post by:
hi friends, I am Purushottam, a mechanical engineer.I am trying to write a C++ programme to know the characteristics of control valve(i.e cv,coefficient of valve). Before calculating cv, i need...
6
by: =?Utf-8?B?LnBhdWwu?= | last post by:
how can i write to an excel .xls file using odbc? i've read in several places that its possible but i can't find an example. i have managed to read an excel file using odbc
0
by: mohaaron | last post by:
I am finding that when a GridView is export to Excel by changing the ContentType of the page the Excel file is not readable by OleDb or SQL Server DTS. I also tried using a Excel Reader that I...
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: 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: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...

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.