Use Excelsheet in ASP.NET for calculation

  • Thread starter Thread starter jelle79
  • Start date Start date
J

jelle79

Hi,

I want to use a difficult Excelsheet as source for my calculation in a
ASP.NET (C#) page. I have 5 input fields on my ASP.NET page and when I press
the submit button I want to put these values into the sheet in cell A1:A5.
And then in A6 an awnser will appear, this awnser needs to be shown on the
ASP.NET page.

Is this possible? And how? (examples) And what serverside software do I need?
 
Thanks Mark,

Do you know if it's also possible with a Microsoft Office (Serverside)
product?
 
Eliyahu,

I'm not looking for an Excel-Calculation Engine, but a component to open a
XLS-file and use this file in my ASP.NET page for the calculation.

So a user uploads his XLS sheet, specifies what fields are used for input
(A1:A5) en what field show the output after Excel has run a calculation.

So I want something like this:

ExcelObject e = new ExcelObject("C:\Path_to\My_worksheet.xls");
e.setValue("A1", 1000);
e.setValue("A2", 400);
int result = e.getValue("A3"); // Content A3: =(A1/A2)

Response.Write("Result = " + result); // = 2.5







Eliyahu Goldin said:
There are products doing Excel calculations without Excel. Here is one of
them:
http://www.spreadsheetgear.com/support/samples/calcengine.aspx

Google for Excel Calculation Engine for more.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


jelle79 said:
Hi,

I want to use a difficult Excelsheet as source for my calculation in a
ASP.NET (C#) page. I have 5 input fields on my ASP.NET page and when I
press
the submit button I want to put these values into the sheet in cell A1:A5.
And then in A6 an awnser will appear, this awnser needs to be shown on the
ASP.NET page.

Is this possible? And how? (examples) And what serverside software do I
need?
Click to expand...
Click to expand...
 
Back
Top