Tricks for saving a spreadsheet document in Excel for further work with it. Cannot save the document form (invoice) in Excel format - the "Save" and "Save As" buttons are not available

It is no secret that Excel and 1C programs are especially popular among office workers, in particular those employed in the accounting and financial sectors. Therefore, quite often it is necessary to exchange data between these applications. But, unfortunately, not all users know how to quickly do this. Let's find out how to upload data from 1C to an Excel document.

If loading data from Excel into 1C is a rather complicated procedure, which can only be automated using third-party solutions, then the reverse process, namely uploading from 1C to Excel, is a relatively simple set of actions. It can be easily done using the built-in tools of the above programs, and this can be done in several ways, depending on what exactly the user needs to transfer. Let's look at how to do this using specific examples in the 1C version 8.3 .

Method 1: Copy cell contents

One unit of data is contained in cell 1C. It can be transferred to Excel using the usual copy method.


The contents of cell 1C will be inserted into Excel.

Method 2: Paste a list into an existing Excel workbook

But the above method is only suitable if you need to transfer data from one cell. When you need to transfer an entire list, you should use another method, because copying one element at a time will take a lot of time.


The list is inserted into the document.

Method 3: Create a new Excel workbook with a list

Also, the list from the 1C program can be immediately output to a new Excel file.


The entire list will be saved as a separate book.

Method 4: copying a range from the 1C list to Excel

There are times when you need to transfer not the entire list, but only individual rows or a range of data. This option is also quite feasible using built-in tools.


Method 5: Saving documents in Excel format

In Excel, sometimes you need to save not only lists, but also documents created in 1C (invoices, invoices, etc.). This is due to the fact that for many users it is easier to edit a document in Excel. In addition, in Excel you can delete the completed data and, after printing the document, use it, if necessary, as a form for manual filling.


The document will be saved in Excel format. This file can now be opened in this program and further processed in it.

As you can see, uploading information from 1C to Excel format is not difficult. You only need to know the algorithm of actions, since, unfortunately, it is not intuitive for all users. Using the built-in 1C and Excel tools, you can copy the contents of cells, lists and ranges from the first application to the second, as well as save lists and documents in separate books. There are quite a lot of saving options and in order for the user to find the one that suits his situation, there is no need to resort to using third-party software or use complex combinations of actions.

If, when saving a printed form of a document or report, the "Save" and "Save As" buttons of the "File" menu are inactive, this means that the table protection flag is set. To disable it, you should disable the "Prohibit editing tables" checkbox (menu "Tools" - "Setting configuration parameters" - tab "Auxiliary"). After this, you need to regenerate the printed form of the invoice - saving to a file will be available.

Prohibition of editing tables is used to exclude the possibility of personnel falsifying the data of primary documents, since it does not allow disabling the “View Only” mode, as well as copying the table or saving it in a file. Therefore, in a typical configuration, only an employee with “Administrator” or “Manager” rights can remove the ban on editing tables.


They find us: how to save reports in excel in 1 from 8 3, how to configure in the 1s 8 3 program find the save as button, how to save an invoice from 1c in excel, 1c is not available to save as, 1c 7 7 is not available to save as, how to save invoices from 1c in excel so that the pillars do not go astray, as in 1s 8 2 save documents in excel format, 1s 7 7 does not save report in excel, how to save a delivery note from 1s, in 1s 8 2 the functions of printing and saving printed forms are not available, the printer icon is inactive

Send this article to my email

The procedure for transferring data from 1C (list of directory or document elements, tabular part of a document, etc.) to Excel format is a very convenient 1C function, because allows you to save almost any data in Excel for further analysis.

1c enterprise version 8.2:

For example, we want to download data from the Nomenclature directory; to do this, open the Nomenclature directory, display the necessary data (use selections, open the desired group):

And click OK.

After this, an Excel file with the necessary data from 1C will be created in the specified path.

But, you don’t have to save the data to a file, but simply (after you have displayed the list) select the data, then save it to the clipboard (right-click - Copy), open the Excel program and paste the data from the clipboard into a blank sheet (right mouse button - Paste).

In the same way, you can save lists of documents and tabular parts in them.

If you want to save the report in Excel, then create a new report, and in order to upload it to Excel, you no longer need to display it in the list, but simply click in the main menu "File" - "Save a copy" and then according to the scheme described above . Or simply copy it via the clipboard.

1c enterprise version 8.3:

On the 1C platform version 8.3, the technology for saving data in Excel is slightly different from version 8.2.

Here, if you right-click on the list, you will no longer see the “Display list...” item; instead, you need to click on the “All actions” menu and select the already familiar “Display list...” item:

In the same way, you mark the required columns with checkboxes, but there is also a wonderful “Only selected” flag; when you set it, only the selected rows are displayed in the table. To select several lines in the list of the nomenclature directory, click on the lines with the mouse while holding down the "Ctrl" key, you will get something like this (selected lines are highlighted in blue):

In the end, it should look something like this:

Next, you can save this table in Excel via the clipboard (as I wrote above), or save it directly to an Excel file. To do this, in 1c (in the displayed list), click on the special main menu button (with the down arrow) and select the item “File” - “Save as...”, then a standard file saving window opens, in it you specify the file name and type “Excel Sheet” and click “Save”.

To save the report to a file, do the same as I wrote just above:

Simple task:

  • Organize file selection on the form (txt file format)
  • Fill the file with data
  • Well, save it naturally (if the file contains data, then ask whether to overwrite it or not).

How to do it?

Organizing the 1C thick client form

Let's complete this task using the example of an external processing form. We create external processing, add a form, and add a field of type string with no length limit to the form.

The field we added needs to have a selection button enabled.

Let's add a click handler.

Please note that we now have two functions in the module - one is a handler for clicking the “Run” button, which was automatically added to the processing form when it was created. The other is the handler we added.

Organizing the 1C thin client form

An example of the same form organization on a 1C thin client.

We add a prop to processing - an unlimited string (i.e. length = 0).

We drag out the newly added props onto the form. To open its properties, right-click on the pulled out attribute.

Set the Select Button property to Yes.

The thin client does not automatically add the button. Therefore, we need to add a Record button to the processing form ourselves.

On the Commands tab, add a new command and click the magnifying glass in its properties to add a handler.

Also drag the added command onto the form (to the left).

In the module we also have two functions - one is a handler for clicking the “Record” button, which we added. The other is the selection event handler we added.

Programming the choice of [name and recording location] file

Windows has a standard file selection dialog.

From 1C you have access to manage this dialogue. For this purpose, there is a special object “File Selection Dialog”.

Dialog = New FileSelectionDialog(FileSelectionDialogMode.Save);

Dialog.Title = "Select a file name to save";

Dialogue.MultipleChoice = False;

Dialog.Filter = "Text file(*.txt)|*.txt";

//Call the actual dialogue on the screen

If Dialog.Select() Then

//We will get here only if the user clicked OK

//Saving the selected file name (full name, that means including the path to it)

FileName = Dialog.FullFileName;

endIf;

If you want to give the opportunity to select several file extensions, for example txt and rtf, then you need to write this:

Dialog.Filter = "Microsoft Word Document (*.txt)|*.txt|"
+ "Microsoft Excell document (*.rtf)|*.rtf|";

Programming a file to be written to disk

To record text files in 1C there is a “Text Record” object.

Working with it is very simple.

Here is a code example for our case:

File = NewTextRecord(FileName);
File.WriteString("Hello!");
File.WriteString("How are you?");
File.Close();

Download ready-made example

You can download a ready-made example of such processing for study.

Very often you need to obtain data from 1C 8.3 and save the information to an external file, in other words, download it from 1C enterprise. The task is almost always possible without the involvement of 1C programmers.

Let's look at a number of useful tips with which you can upload data from 1C to an external information system.

In 1C there are several methods by which you can obtain information without the involvement of specialists:

  • Uploading the entire database from 1C 8.3 - for subsequent loading on another computer
  • Save reports and printables in Excel, Word or PDF
  • Uploading tables from 1C
  • Retrieving Information Using the Query Console

More details about them:

How to download the entire database from 1C 8.3 (to a .dt file)

To do this, you will need to go to the configurator mode, then in the main menu select “Administration” - “Upload information base”:

Then you only need to indicate the name of the future file and its location on the disk.

To subsequently upload to another database, click on the “Load information base” button and select the previously uploaded file.

Uploading reports and printed forms from 1C to Excel

This method is universal and very simple. To do this, it is enough to open a printed form or report.

For example, open the TORG 12 printable form, press ctrl+S (or in the File menu - Save As) and select the file type and its name:

The same system applies - the report is downloaded in two clicks:

Get 267 video lessons on 1C for free:

Saving in the main formats is available - excel, word, pdf, html, txt, etc.

Uploading tables from 1C 8.3

Often there are such trivial tasks as “get a list of payments for the current year”, “unload a book of purchases or sales” or “unload goods from invoice No. 256”. Solving such problems is quite simple.

For example, I need to receive all receipts from the counterparty “Vector” with an amount greater than 1000. Let’s open the list form and set the necessary selections in the list:

The system will offer an output option - to a spreadsheet document or a text document, select tabular. The 1C program will display the information in the following spreadsheet document, which, like reports, can be saved in the format we need:

Similar actions can be performed for almost any tabular part in 1C 8.2. For example, we needed to unload a list of goods from receipt No. MSK00003, no problem. This is done very simply - open the document, call the context menu and after a couple of clicks we get the desired upload in the required format:


Uploading a journal of transactions from 1C to Excel:

Retrieving Information Using the Query Console

However, not all information can be found in the simple tabular part of 1C 8.2. Sometimes you need to collect data from several data sources and connect them using some fields.

This method is suitable for technically savvy people who know the basics of query language. It consists in obtaining the result of the request using and saving it in the format we need.

For example, you need to get all supplier counterparties and their phone number. To do this, we will write the following query:

The resulting table can also be downloaded into the desired file format:

You can load the received data into another 1C database using “ “. Watch the video instructions using the nomenclature as an example:



 

It might be useful to read: