Programming

Navigation:  Interfacing QDV > CRMs and ERPs >

Programming

Previous pageReturn to chapter overviewNext page

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.