Programming |
  
|
Programming |
|
Use Cases
The DLL Interface component is used among many other usages to:
▪Compute estimates (either selling price or cost)
▪Export nomenclatures in many different ways
▪Get workbooks exported as objects so that you can adapt them in any way programmatically
▪Build estimate (WBS and Minutes view) from a source estimate
▪Create reports
▪Create Word documents
▪Synchronize with ProMo+.
Program these functions using C# or VB.NET.
License
To deal with Excel workbooks, QDV uses a component from SpreadsheetGear LLC.
The complete API or SpreadsheetGear + QDV7 can be exposed provided the developer (not the end user) owns a SpreadsheetGear license.
If you do NOT have a SpreadsheetGear license code, the QDV DLL Interface component displays a message at run time. Ask your QDV dealer for a specific license code.
If you have purchased a license directly from SpreadsheetGear, send your dealer the proof of purchase and he will provide you with a QDV7 programming code.
If you only deal with Global Variables using the component (Reading or Writing), you do NOT need a license because these functions never call the SpreadsheetGear component.
Click Automation>Macros.
Example
A User interface is available for data clearing or extraction.
1.Run <installation directory>\Test_QDV_Interface.exe (QDV7 does not have to be opened)
2.Initialize the DLL Interface component
3.Select and get the selected source estimate
4.If needed, click the button Empty WBS and Minutes ...; this clears the rows and fills them with "This is a test description"; click the button Save Estimate
5.To extract data, select the relevant tab and select columns
The full source of this application is in the \SDK directory.