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" wrote:
There are products doing Excel calculations without Excel. Here is one of
them:
http://www.spreadsheetgear.com/suppo...alcengine.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" <je*****@discussions.microsoft.comwrote in message
news:25**********************************@microsof t.com...
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?