How to automatically upload indicators from 1C to excel?

M

Marchello_P2021-03-14 22:03:34

Fintech

Marchello_P, 2021-03-14 22:03:34

It is necessary to upload certain indicators from 1C to excel so that every month they are automatically loaded into fixed excel cells. What is the best way to do it? Maybe macros or bat file? 1C Enterprise 10.3

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

V

VitalyChaikin, 2021-03-15
@VitalyChaikin

The most healthy option is to write processing, which from 1C once a month (or more often if necessary) will be launched by the user (the one who is interested in this data);
The same processing can be started from cmd (bat)
Here srv-1c-01\Database01 = Server\Database
Username = Username from this database 1C
UsernamePassword = Password of this user

"C:\Program Files\1cv8\common\1cestart.exe" ENTERPRISE /S"srv-1c-01\Database01" /N"Username" /P"UsernamePassword" /Execute "C:\Sbis1C\RobotSBIS_UF.epf"

K

Konstantin Nagibovich, 2021-03-14
@nki

You can upload data through a scheduled task. 1C can work directly with excel via COM. There are plenty of examples on the Internet.

K

Konstantin, 2021-03-15
@fosihas

What is the best way to do it? Maybe macros or bat file? 1C Enterprise 10.3

any to choose from, 1C-on will cope with any. There are already your or the developer's abilities.
https://infostart.ru/public/564876/
https://infostart.ru/public/382391/
https://infostart.ru/1c/articles/980692/