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.

Edition

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.