Adressing excell cellars from Navision Financials

Philip_Depuydt
Philip_Depuydt Member Posts: 2
edited 2000-02-14 in Navision Financials
I would like to read some information from a particular cellar in excel into NF 2.0D. I think this should be possible by using "automation controller". Can anyone send me an exemple of how locating a cellar in excel and recuperate the data in Navision.

Thanks for any information.

Comments

  • fredh
    fredh Member Posts: 10
    C/AL Variables :
    1. ExcelApplication - Automation - 'Microsoft Excel 9.0 Object Library'.Application
    2. ExcelSheet - Automation - 'Microsoft Excel 9.0 Object Library'.Sheets
    3. ExcelWorkSheet - Automation - 'Microsoft Excel 9.0 Object Library'.Worksheet

    1 Excel file saved as File1.xls. Following code opens the file and gets the value of the C8 cellar back :

    CLEARALL;
    CREATE(ExcelApplication,TRUE);
    ExcelApplication.Visible := FALSE;

    ExcelApplication.Workbooks.Open('E:\FILE1.XLS');
    ExcelSheet :=ExcelApplication.ActiveWorkbook.Worksheets;
    ExcelWorkSheet := ExcelSheet.Item('Sheet1');
    MESSAGE(FORMAT(ExcelWorkSheet.Range('C8').Value));
    fhh
    fhh

Categories