How to make automatic unloading from 1C to Excel?

Question

Fintech

The holding has 1C file databases for each individual company. Now the reporting is collected as follows:
1) a financial department specialist enters each database and collects the necessary information on cash flow, account card 20,25,26
2) copies the information into Excel
3) processes it manually in a single template in Excel to see consolidated information on the group of companies.
As you want to do: press a button in Excel and receive data from 1C automatically.
Bases 1C not on SQL, and with normal file access.
1C: Consolidation has not been tried, but it requires a very long setup, because the types of business are different and different accounting policies for organizations.

Answer 1

By the button "Upload to Excel" create a SpreadsheetDocument and fill it with the necessary data. Then call its Write method and specify the path to save and the format in which you want to save in the parameters.
For a reasonable price, I will do this task for you.

Answer 2

I would write a processing that itself generates excel files, and sends them to some kind of htpp (ftp) server.

Answer 3

The easiest option is to set up a report and save the report in Excel.

Answer 4

Option 1 - if the accounting version is 3.0 - set up periodic distribution of reports with saving from 1s to an EXCEL file (example for Trade goo.gl / Y45e8J - for BP 3 is similar) and loading related tables via import into Excel office-guru.ru/excel/ import-dannyh-v-excel-2010-iz...
Option 2 - use VBA macros in Excel to get data through COM objects from 1C infostart.ru/public/382391

Answer 5

Colleagues, Here is an example that will help automate uploads from 1C:
Business Intelligence in Excel