OWC 11 interop - formula translation

A

Abi

Hello there,

I'm using OWC11 interop to extract values from an excel file. First I'm
converting Excel to a XML spreadsheet and then getting the values by ranges.

Here's the code to get the value for a particular cell.
//sp is spreadsheet object
Range rg = sp.get_Range("B2","D14");
string val = rg.get_Item(1,1).Text;

It works fine for normal text values (un-formatted values). But in some
cases, the cell contains really complex formulas. In this particular
situation, when I run the above code, I get a "#REF!". I don't get the
actual value stored in the excel sheet (for e.g.the value in excel cell is
32000). I want to get the value that excel displays, not the formula.

Is there any way to do this. Please help me.

Thanks a lot in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
OWC 11 Spreadsheet with VB .NET - Install 0
OWC 11 0
error with Insert a new row in OWC spreadsheet 1
NumberFormat code no longer works in OWC 11 on Windows Server 2003 0
Need help with Excel Formula for calculating sum of products depending on criteria 3
OWC 10 - #n/a, #name, #value detection 3
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1

Top