A
A
arthurmur2016-07-12 10:28:15
Python
arthurmur, 2016-07-12 10:28:15

Work in conjunction with Excel - Python (?) - 1C?

Hey!
Guys, the initial conditions: there is a table in MS Excel, which indicates the names of counterparties, the number of products delivered and the total amounts, as well as transport services - either at the expense of the counterparty or at our expense (in this case, you need to take into account the fact that the organization - the owner of the transport is also a counterparty). The question is: how can I connect MS Excel and 1C so that information from the Excel table is transferred to the 1C database by creating an operation in 1C (receipt of goods), and also so that the same thing is done with transport (if at our expense)? Is Python suitable for this?
ps I'm a noob in coding, I'm just taking my first steps in Python, I found this problem at work and I want to solve it, but I don't even know where to go. Thank you.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Lebedev, 2016-07-12
@arthurmur

In your case, it's better to do it with 1C forces - it perfectly knows how to hook Excel and suck data out of it. But here you already need a 1C encoder to write processing.
Python is not the best solution here - you will have to write directly to the 1C database (maybe there is some kind of API, but I have not heard about it), and the devil will break his leg in its structure.

A
Anton Fedoryan, 2016-07-12
@AnnTHony

noob at coding

Not the best idea to climb directly into the working base. Deploy a copy on a virtual machine and play around.
Have you heard about processing in 1C? Maybe xml will seem more convenient than Excel.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question