ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using axSpreadsheet (https://www.excelbanter.com/excel-programming/374787-using-axspreadsheet.html)

Kaustav

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.


moon[_7_]

Using axSpreadsheet
 

"Kaustav" schreef in bericht
...
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.



Hello,

Better post this question in a .NET newsgroup. It's easier to find someone
over there who knows about Excel than finding an Exceller here who knows
about .NET
However, I think it's a matter of refreshing data after editting.

Hans




All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com