Questions tagged [rtd]

RTD (Real Time Data) is a feature introduced with Excel 2002 to display data provided by an RTD server. For questions regarding real-time data outside Excel choose the tag 'real-time-data'.

RTD (Real Time Data) is a feature that has been introduced with Excel 2002. It provides the ability to display data in real time within the sheet. The data is provided by a so-called RTD server (not to be confused with a hardware server), which is an external program that binds through an IRTD interface that's based on COM interaction.

124 questions
1
vote
1 answer

Run a macro based on change in a cell caused by incoming Real-Time server data

I want to run the bellow macro whenever cell F3 increases. I need this to happen without manual intervention because F3 is increasing due to incoming RTD server data. As it stands, unless I manually update something in my sheet the macro does not…
user3705100
  • 45
  • 1
  • 6
1
vote
0 answers

ExcelDNA RTD not updating new values unless changed manually

I am using the cookie-cutter excelDNA solution named TestRTD.dna in ...\Dsitrbution\Samples\RTD\. I augmented GetEurOnd() to: public static object getTestObject(String arg){ return GetTestItem(arg); } Where GetTestItem() is unchanged. My…
jason m
  • 6,519
  • 20
  • 69
  • 122
1
vote
1 answer

How does Excel RTD invoke IRtdServer.DisconnectData()?

It's easy enough to invoke ConnectData() with =RTD() in Excel. But there's also a function DisconnectData(). Is there some Excel function that will cause DisconnectData() to be called? What is this method for, really?
Grant Birchmeier
  • 17,809
  • 11
  • 63
  • 98
1
vote
0 answers

Read The Docs Not Building Project Documentation After Creation via Web Interface

I am using Read The Docs to build the documentation for my project. I followed the documentation to install the software, and after trying to import documentation from a project using these instructions, no build job ran. I checked the log file for…
FearlessFuture
  • 2,250
  • 4
  • 19
  • 25
1
vote
0 answers

What is the correct way to handle an unknown topic in a RTD server written in C++?

I'm writing an RTD server for Excel in C++. I've implemented my server and for the most part it works. The issue I have is when a cell has a call to RTD with a topic which isn't valid. For instance, I might have a call which looks…
bpeikes
  • 3,495
  • 9
  • 42
  • 80
1
vote
0 answers

How to show rectangle around each segments..and measure x and y coordinates of image

I want to count no. of segments in rtd images and have to draw rectangle around each of object .Also i have to measure x and y coordinates in c#
Rashmi Sargar
  • 61
  • 2
  • 8
1
vote
0 answers

Macro run on RTD updates

My problem is as follows: I am running a real-time data server with a count-down from 900 to 0. Once the countdown hits 5 i want excel to copy range(B2 to B61) in sheet(RTD_NEWS) and paste it into a new worksheet as values. The problem is that my…
1
vote
1 answer

Java to Excel - dynamic updates

I need to display some dynamic data - an array of constantly updating values - from a java server onto an excel sheet. I have been looking at xlloop but this seems to be more a request/reply infrastructure - i.e. have to press F9 to poll for the…
1
vote
0 answers

RTD Server : how to read RTD server data in C#

I have developed an application to read data from excel spreadsheet which get data from RTD server. So whenever spreadsheet get updated I can write that data to database using C#. But my concern is that I don't want to rely on that spreadsheet as an…
dnyan86
  • 107
  • 2
  • 2
  • 8
1
vote
2 answers

RTD Server C#: Getting "N/A" in deployment

I have created Excel RTD Server, after all implementation completion in debug mode, I am able to run RTD and it is working fine. But when I get the dll in release mode and take it to another system, and register using "regasm.exe" and also provided…
user1537891
  • 11
  • 1
  • 2
1
vote
0 answers

Reading calculated data from a formula cell with formula RTD in Excel 2007 form Java application

I am trying to evaluate the cell value of a formula cell [Formula being RTD] in Excel 2007 from my Java code. I have used HSSFFormulaEvaluator class and evaluate() method, the standard way in short. Add, subtract and other simple functions are…
Oscar Orcas
  • 117
  • 2
  • 4
  • 17
1
vote
2 answers

.NET RTD/COM Excel Interop errors on one user's machine?

We built a .NET COM/Excel RTD Server (.NET Assembly) which has been in use for many years, on a variety of machines (i.e. we know it works, and our standard method for installing it works). We have a user who installed this RTD component on a…
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
0
votes
1 answer

RTD Client with 3rd party RTD Server : C#

I am trying to connect custom RTD client, written in C# with 3rd party RTD server. Type rtd; Object rtdServer = null; rtd = Type.GetTypeFromProgID("ProgId","WS001"); rtdServer = Activator.CreateInstance(rtd); where WS001 is my machine name, and…
Max
  • 1,528
  • 21
  • 33
0
votes
0 answers

Excel RTD server deployment

I am trying to develop a RTD server similiar to this example in C#. The RTD server requires another .NET dll which uses a native C-dll. The .NET dll calls the native C dll via Interop. So far I have copied both DLLs into the same directory as the…
weismat
  • 7,195
  • 3
  • 43
  • 58
0
votes
1 answer

Add-in Express RTD refresh issue

Excel AddIn using Add-In express, VS2010, cometd.net talks to cometd server and Tom cat In RTDInitialize event handler, I log in Tom Cat and connect to cometd server, I use an instance of class credential to remember it is loggedOn(set IsLoggedOn to…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
1 2 3
8 9