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.