Source: Example of several different ways to work with Excel files from 1C application:

• OLE
  
• External data sources
  
• SpreadsheetDocument
  

You can Download*.dt file to develop your own application.
Also, you can study the instructions for developing this example from scratch using 1C:Enterprise platform.