Transfer documents from (MS Excel To 1C)

1C:Enterprise platform integration capabilities and techniques

People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jul 29, 2015
Company: Tarz Yazılım

I need to export the MS Excel document in 1C. I have to do this manually in certain periods. Could you give an example or idea on the subject?

Good work

Edited: Samet Gökdaş - Jul 10, 2017 01:17 AM
People who like this:0Yes/0No
Timofey Bugaevsky


Hello, Samet Gökdaş!

You can create a data processor that will read this Excel file and import into the application. The built-in SpreadsheetDocument object supports opening Microsoft Excel files. Please, see following examples:
Show SpreadSheet from custom line
Show SpreadsheetDocument on a form
On Windows you can use COM object as an alternative.
Import Data from Microsoft Office Excel
The third option is using ExternalDataSource and Microsoft Excel Driver in the connection string.

Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.