Jump to content

Valter

Members
 View Profile  See their activity

  • Content Count

    2

  • Joined

  • Last visited

Posts posted by Valter

  2. Posted

    Hello everybody.

    I wrote a management software with Delphi 10 Seattle and recently I was asked to automate the updating of an Excel file after issuing an invoice.

    I access the file, find the first blank line and fill in the fields.

    Since this is the only operation required, I don't use any add-ons.

    This is part of the cleaned up code: 

    ExcelApplication := CreateOleObject('Excel.Application');
ExcelWorkbook := ExcelApplication.Workbooks.Open(ExcelFileName);
ExcelWorksheet := ExcelWorkbook.WorkSheets[1];
ExcelWorksheet.Select;
ExcelWorksheet.Cells[i,2] := cod;
ExcelWorksheet.Cells[i+1,2].Select; // Undeclared identifier 'Select'
ExcelWorkbook.Save;

    The customer requests that the cell following the one inserted is selected when opening the Excel file.

    Despite the undeclared identifier error, the code compiles and the application works correctly.

    I specify that in typing this code I have no self-completion by the IDE.

    Is it possible that some units are missing? I searched the net but couldn't find any suggestions.

     

×