Uniface passing data to Excel

Author: sbpatel48@gmail.com (Sandip)

Hi,

Does anyone know how i can transfer data from a uniface component (grib) to excel. Then ideally when it's updated in the spreadsheet, it should be updated/refreshed in the application.

This kind of functionality is available on in MS Team Foundation, where the query results can be outputted to excel. Any changes can then be published to update MS TFS again.

Any help is greatly appricated.

Sandip

3 Comments

  1. If have never tried this myself, but it could just work for you.

    You could try to set up your excel sheet as an ODBC data source, and access it with the Uniface ODBC database driver.


    Author: Dennis van Duijn (dennis.van.duijn@sogeti.com)
  2. The uniface part of this is unusually well documented in the help.

    Import EXCEL as a com component signature (/sti {/verbose} /mwr=com PathToTypeLibrary )

    Not so well documented but spend some time in the MSDN excel object reference http://msdn.microsoft.com/en-us/library/bb149081(v=office.12).aspx

    With the operations you now have exposed in the signature you have total control over EXCEL

    I use this all the time (also for WORD & OUTLOOK) - works very well,


    Author: AyeJayUU (awilkins1@btinternet.com)
  3. Hi there I think it is difficult to do that with out an Excel Processing SDK.There are many advanced component used to edit Excel files and implement page level processing. It can easily add, insert or delete Microsoft Excel worksheets. You can also sort order of your Excel document sheets/pages in C#.NET. Merging or splitting Excel files will not be difficult with this Excel SDK. It also enables you to add image on specified position of an Excel document page or extract page(s) from an Excel file. All these functions can be achieved independently from any third party assembly. You can have a try


    Author: Nana111 (donnaklinton@yahoo.com)