Read/Write from Excel using ASP.Net

[DaveBinM]

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.

[Mark Rae [MVP]]

Re: Read/Write from Excel using ASP.Net

"DaveBinM" <Brydo.Sk8er@gm ail.comwrote in message
news:546588c1-2d31-4762-a2a3-4d68aad6b9ac@i1 2g2000prf.googl egroups.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/file-format-components/aspose.cells-for-.net-and-java/default.aspx

Don't even consider server-side Office automation:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

http://support.microsoft.com/default.aspx/kb/288367

--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Mark Rae [MVP]]

Re: Read/Write from Excel using ASP.Net

"DaveBinM" <Brydo.Sk8er@gm ail.comwrote in message
news:f6ae5a40-d61b-4a8a-acd2-964ad7aa2e6e@d2 1g2000prf.googl egroups.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

[DaveBinM]

Re: Read/Write from Excel using ASP.Net

On Mar 25, 4:11 pm, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"DaveBinM" <Brydo.Sk...@gm ail.comwrote in message
>
news:f6ae5a40-d61b-4a8a-acd2-964ad7aa2e6e@d2 1g2000prf.googl egroups.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.

[Mark Rae [MVP]]

Re: Read/Write from Excel using ASP.Net

"DaveBinM" <Brydo.Sk8er@gm ail.comwrote in message
news:7b0487ae-1bae-4e83-8b90-1f4d1c84a562@s1 9g2000prg.googl egroups.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/file-format-components/aspose.cells-for-.net-and-java/default.aspx

--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[DaveBinM]

Re: Read/Write from Excel using ASP.Net

On Mar 25, 4:44 pm, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"DaveBinM" <Brydo.Sk...@gm ail.comwrote in message
>
news:7b0487ae-1bae-4e83-8b90-1f4d1c84a562@s1 9g2000prg.googl egroups.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.