Prices from: $ 979.02

Aspose.Cells for .NET Forum

Aspose.Cells ali_webster [United Kingdom] 07-Mar-2008 16:32:22

I'm just trying out the free version of aspose.cells software to see if it does what I want before purchasing. I tried a simple test to have a prebuilt excel doc containing formulas that depend on input values. I wanted to be able to programmatically write the input values into the excel doc then read off the calculated values: -

Example

In the document Test.xls in cell A2 is a formula: =A1*2. I want to be able to set the value into A1 and then read the calculated value from cell A2 which should equal twice the value I entered, however it returns 0 as if no value in A1 has been set. Perhaps I am missing something - is this possible using Aspose.Cells ?

Heres my simple code

ltlOutput.Text = "";
int inputValue = System.Convert.ToInt32(txtInputValue.Text);
Workbook wb = new Workbook();
wb.LoadData("c:\\temp\\Test.xls");
Worksheet ws = wb.Worksheets["Sheet1"];
ws.Cells["A1"].PutValue(inputValue);
ltlOutput.Text = ws.Cells["A2"].Value.ToString();

Thanks for your help.

Alistair
Reply


Aspose.Cells keith [United Kingdom] 15-Nov-2007 11:08:36

Using Aspose Cells and MS VS2005 C#, having problems with long partnumbers displaying as exponent numbers in Excel instead of strings though I am setting the style number to 49 which the documentation says is text. I can bodge it by shoving a ' in front of the string but doesnt look very elegant. Excel version is 2003.

Best regards

Keith
Reply


Back to Aspose.Cells for .NET

Official Supplier

As official and authorized distributors, we supply you with legitimate licenses directly from 300+ software publishers.

See all our Brands.

24/5 Customer Service

Need help to find the right software license, upgrade or renewal?

Call, Email or Live Chat with our experts.

Trusted for 20 Years

Over 580,000 licenses delivered to Developers, SysAdmins, Corporations, Governments & Resellers, worldwide.

Read more about us.