View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kaustav Kaustav is offline
external usenet poster
 
Posts: 5
Default Using axSpreadsheet

Hello,

I am using a axSpreadsheet component in my Winforms application. How do I
fetch data from cells which the user has entered at runtime? For ex - I had
programatically inserted data in cell A1 as -

axSpreadsheet1.ActiveCell.get_Range("A1", "A1").Value2 = "Some Content";

On a button click I have the following code which gets me the data of cell
A1 -

axSpreadsheet1.ActiveCell.get_Range("A1", "A1").Text.ToString()

However, if the user had entered some content in B1 at runtime, then

axSpreadsheet1.ActiveCell.get_Range("B1", "B1").Text.ToString() returns me
an empty string. How can I get the new/updated/modified data?

Thanks.