Delphi Import Excel File

1. Excel Import Csv File

Thank you svanels. I was aware of FAQ 102-1562. It was one of the examples I’ve tried to adapt to my situation and couldn’t get to work. It seems to me that there must be a simpler way than the introduction of VBA into the mix. The code included here has been adapted from the Deborah Pate website.

Specifically Pate’s example of how to open an Excel file subheading, Late Binding. The code below lists my adaptation of Pate’s lead. VarMyXLWorkbook,MyXLWorksheet: OleVariant;BeginMyXLApplication.Connect;// The OleVariants are empty!MyXLWorkbook.ConnectTo(MyXLApplication.ActiveWorkbook); Ominous.

Excel Import Csv File

Some very weird problem in the TLB Delphi used to generate the components.Please, drop an Excel application, workbook and worksheet in a clean project, add my code, try to compile it and tell me what you get (remember your 'Open' param list may vary).buho (A).RE: Delphi Open and Read Excel files (Programmer).