excel connector for LabVIEW

[EngrStudent]

There are some analytic software that adds connections to Excel.  JMP comes to mind - it allows 2-way data transfer, and allows excel to run some of JMP's analysis routines.  Those packaged routines are vetted by phd's and can't be quickly damaged by a tired user. 

This details how JP morgan lost a few billion dollars because they were using Excel for hard math, and someone had an error in an equation.

Excel is likely more common than both Javascript or SQL for use in the planet. 

It might be very powerful to be able to import an excel spreadsheet, specify inputs, specify outputs, and get it translated to "g".  This could allow it to run thousands of times faster, and the visual language would allow a technical vetting that can be very hard for humans to do on hundreds and hundreds of pages of tables of numbers or formulas. 

This would be a motive for banks like JP Morgan (or their peers) and their multi-billion dollar business units to use LabVIEW.  Stunning speed, optimization, and scale.  Stunning accessibility to error correction.  Packages that, once wrapped, stay wrapped, but can plug in where they need to.

Other add-in or connectors for Excel:

• http://www.thespreadsheetguru.com/blog/popular-excel-addins <- nice graphs, analysis, excel visual transformation tools.  VBA security
• http://opensolver.org/ <-- Several, non-trivial, solvers.  (COIN, CBC, others)  Large problem solutions (not throttled).  Visualizer.  Alternative user interfaces, sometimes more valuable

It is unlike the TDM-importer in that it sends data to LabVIEW, the data is transformed or processed, and a numeric, text, or image result is returned to Excel.

[crossrulz]

You can make your own Excel interfaces using ActiveX and .NET.  There are plenty of threads floating around with examples.  NI is busy enough with other stuff.  This is something that is better left to the community.

[Darren]

Any idea that has not received any kudos within a year after posting will be automatically declined.