How to save 1s in excel. It is not possible to save the document form (invoice) in Excel format - the “Save” and “Save as” buttons are not available. What is the reason? Create a new Excel workbook with a list

I'm sorry:

• Organize a file selection on the form (txt file format)
• Save the file with data
• Well, save it naturally (if the file contains data, then ask to rewrite it).

How can you earn money?

We organize the form of a commercial client 1C

It is clear that the butt has been given the same shape as the outer finish. We create an external layout, add a form, and add a field with the type row without border to the form.

For the given field, you need to enable the select button.

Dodamo obrobnik natiskanya.

Please note that the module now has two functions - one by pressing the “Viconati” button, which was automatically added to the processing form upon creation. Insha - we have added a compiler.

We organize the form of the 1C thin client

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

We add the details to the obrobka - unbound row (so dovzhina = 0).

Carefully add the props onto the form. To reveal its power, click on the pulled-out details with the right mouse button.

Power Select button set So.

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

On the Commands tab, add a new command and click on the magnifying glass to add a description.

Also drag the given command onto the form (left-handed).

The modules also have two functions - one is the function of pressing the “Record” button, which we have added. Otherwise, we will provide you with a sample book at the time of your choice.

Programmable selection of [name and recording location] file

Windows allows you to open a dialog and select a file.

With 1C you have access to manage this dialogue. And this is why there is a special object “Dialog to Select File”.

Dialog = New DialogSelectFile(ModeDialogSelectFile.Saving);

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

Dialogue.MultipleVibir = Nonsense;

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

//Wikk the dialogue on the screen

YakshtoDialog.Select()Todi

//Let's go here lishe yakscho koristuvach pressing OK

//Saving the selected file name (alternate name, means including the path to the next one)

NameFile = Dialogue.OpenImFile;

KinetsYakscho;

If you want to be able to choose a number of file extensions, for example, txt and rtf, then you need to write like this:

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

Programmable recording of a file to disk

To record text files, 1C has the “Record Text” object.

Working with him is very simple.

Axle butt code for our vipadku:

File = New Post text (file name);
File.WriteLine("Hello!");
File.WriteString("How did you do it?");
File.Close();

Vandalize the ready-made butt

You can take advantage of the ready-made butt of such a piece for implantation.

Many office workers often have to use 1C and Excel programs. They have to export data from one application to another. Today we will look at how to upgrade from 1C to Excel.

Vivantage data from 1C to Excel

Vivantage of data from 1C to Microsoft Excel is a process that requires cumbersome actions. For this purpose there are enough funds purchased from the program. There are a number of ways to export data.

We vivantize a great number of data

In the open document, right-click and select “View List”. After this, all elements are displayed as the original text. You can copy and paste it into a MS Excel document, or simply open the “File” menu and go to the “Save as” section.

You will no longer have to select the file format and save it.

We vivantize the different forms of documents

How to insert a list into an Excel workbook

To move the list, you can quickly do this in the following way:

• The required list is displayed in the 1C program. Then you need to use the right mouse button to click on “All events”, and then “Show list”.

• Show up on the list. The “Display from” field has the “Spreadsheet document” option.
• Below you can select the stoppers that will be transferred.

Please! Do not change anything in this window if you plan to transfer the document directly.

1. After completing this process, display a list on the screen in the table view. You need to see and copy everything.
2. Then a new Excel document is created and the data is inserted into the new one using “CTRL + V”.

Create a new Excel workbook with a list

You don’t have to bother for a long time and just enter the list from 1C in Excel:

1. It’s important to remember that the previous method has not yet formed a list. Then you need to go to the menu, open the “File” section and select “Save.”

Visnovok

Now you know a number of ways to visualize a 1C table in Excel. The procedure is easy, and any professional can handle it. Please, please read our instructions, choose the appropriate method and carefully follow the instructions. It would be easier to look at the inserted screenshots.

The need to save the Excel file from 1C arises among accountants and other professionals who work with both programs. It takes too long to transfer data manually by copying or manually entering it from the keyboard, which is due to the use of modern methods. Retailers have encouraged this and have come up with sophisticated ways of copying data in both directions. All that is needed for a kistuvach is to know these methods.

Yak vivantazhuvati file z 1C

The best option for transferring information from 1C is vivantage. For those who do not need to copy data via the clipboard, everything is simpler:

Koristuvach opens the file in the 1C program;

You will not be able to select the desired location on your computer or the private disk where the file will be sent, and the format of the file. When food is supplied and saved in Excel, the XLSL format is selected.

This option doesn’t take too much time and helps you programmatically transfer large Excel files.

If you need to work directly at the gateway, download Excel files from the 1C system, you need to work in two directions.

How to upload files from Excel in 1C manually

One of the manual methods is copying via the clipboard. The data is displayed in the Excel document and the main entries Ctrl+C – Ctrl+V are transferred to the 1C database. It is important to ensure that the formatting is not lost at the time of transfer and that all data is dissipated in the right place.

Another way is fascination, voracious rozvantazhenya. The user again goes to the “File” menu in the 1C system and selects the “Enter” function, after which the file is located on the computer. Searching takes about an hour, maybe a few seconds, or longer for larger files. It is strongly recommended to check the format for errors and corrections, so that the smells do not disappear from the original base and do not become the cause of confusion.

How to upload Excel files to 1C automatically

Copying information from a 1C 77 Excel document rarely needs to be copied. There are no delays if it is necessary to deconstruct the sound and give the authorities and contractors the invoices. The portal for collecting data from Excel in 1C is wider, which is why it is not necessary to collect and organize data.

In order not to do everything manually and not waste time, the company can arrange a special contract, in addition to which data must be obtained and processed without the participation of the staff. Zavantazhuvach is not a complex software product, but the problem is that it needs to be customized to suit the needs of a particular company. Therefore, it is impossible to obtain free access to the Internet, and you will need the help of a specialized company to develop the access and implement it for the company.

Before you begin to indulge in such a vantage, it is important to check three points.

How correctly it transmits data. It turns out that the program works with corrections, in this situation it is better to immediately identify and make adjustments, but also to deal with a lot of inaccurate numbers. After checking the stability of the program, the developer is responsible, and the company personnel are responsible for checking the correctness of the transferred product until it is clear that everything is in order.

All devices have a vantage device installed. The transfer of other computers and computers that work on them is unacceptable when forming a carbon base, since they themselves can cause a flow of both information and business costs. The rise of automation for businesses is always introducing complexity.

Before uploading copies of data from Excel to 1C, great respect should be given to the new filling in the middle of Excel. In cases where it happens, spivrobitniki confuse the order of the middles, enter data from two into one and do not follow the rules very soon, serious problems may appear in the 1C database. The manager of the enterprise and the chief accountant can carry out serious work with computer security specialists before introducing business automation using the additional 1C. Compliance with all the rules for filling out data and maintaining a database will help to eliminate a lot of confusion and inaccurate data, speed up your business and bring it to a new level, outperforming your competitors.

For further work with data extracted in a spreadsheet document from the 1C system of any version, it can be saved in xls(x) format.

Everything would be fine, but when you open it in Excel, you immediately understand that the table is not the same, well, there are no labels in the book. %)

This was the case in the 7th version of 1C and migrated to the 8th, so progress in the 8th can be saved in the format xlsx, the standard format for other versions of Excel.

To complete the task, there are a lot of awkward manipulations, first of all, what comes to mind is to save the table in a different format, otherwise there is no desired result, then we begin to copy-paste the new book Excel.
Another option, for those who have stuck their heads in, is to go into adjustments Excel and in the Dodatkovo section, check the “Show sheet labels” checkbox. It is correct, but also routine, to lightly frequently process data, extract it from 1C in a flat table and further analyze the data in a table and other ways of submitting data to Excel.

Getting ready to run around ticking boxes and having lost my mind, having scoured the vastness of the Internet, for example, and having marveled at other developments, I decided to implement an awkward (for whom it’s not a button, who cares the police, however, they don’t shy away from relish) mechanism m automation of the most common problems with displaying labels arkushiv.

All you need to do is to use the two powers of the Excel window:

DisplayWorkbookTabs // sign of displaying the bookmarks of the workbook tabs TabRatio // matching the width of the workbook bookmarks area to the width of the horizontal line of the scrolling window (as a number between 0 (zero) and 1, value behind 0.6)

TabDocument.Write(OutsideFile, TabularDocumentFileType.XLS); Excel = New COMObject("Excel.Application"); Excel.WorkBooks.Open (Outside File Name); Excel.Visible = 0; Excel.ActiveWindow.DisplayWorkbookTabs = 1; Excel.ActiveWindow.TabRatio = 0.6; FullName = Excel.ActiveWorkbook.FullName; Excel.DisplayAlerts = false; Excel.ActiveWorkbook.SaveAs(FullName, 18); // 18 - xls 97-2003; 51 - xlsx 2007-2013 // Excel.Visible = 1; // what needs to be done with the book
//Excel.Application.Quit() // it's easy to see

TabDocument.Write(OpenImFile, "XLS"); Excel = Create Object("Excel.Application"); Excel.WorkBooks.Open (Outside File Name); Excel.Visible = 0; Excel.ActiveWindow.DisplayWorkbookTabs = 1; Excel.ActiveWindow.TabRatio = 0.6; FullName = Excel.ActiveWorkbook.FullName; Excel.DisplayAlerts = false; Excel.ActiveWorkbook.SaveAs(FullName, 18); // 18 - xls 97-2003; 51 - xlsx 2007-2013 // Excel.Visible = 1; // what needs to be done with the book
//Excel.Application.Quit() // it's easy to see

It’s no secret that among office workers, especially those employed in the industrial and financial spheres, Excel and 1C programs are especially popular. Therefore, it is often necessary to exchange data between these two supplements. Alas, it’s a pity that not all wealthy people know how to earn money. Let's understand how to visualize data from a 1C Excel document.

Since the acquisition of data from Excel in 1C is a complex procedure, it can be automated only with the help of third-party solutions, a reverse process, and the acquisition itself from 1C in Excel is a simple set of actions. This can be easily achieved by using the new tools of knowledge programs, and it can be done in a number of ways, depending on what you need to transfer. Let's take a look at what's wrong with specific butts in the 1C version 8.3 .

Method 1: copy instead of copy

One unit of data is available in 1C. They can be transferred to Excel using the basic copy method.

Excel will be inserted instead of 1C.

Method 2: inserting a list into your main Excel workbook

However, this method of fortune-telling is only suitable in cases where it is necessary to transfer data from one middle. If you need to transfer an entire list, you can do it quickly in another way, even copying one element at a time can take up to an hour.

List of document insertions.

Method 3: create a new Excel workbook with a list

The same list of 1C programs can be immediately output to a new Excel file.

The entire list will be preserved in a book.

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

There are exceptions if it is necessary to transfer not the entire list, but only a row or range of data. This option can be implemented entirely with the help of purchased tools.

Method 5: Saving documents in Excel format

In Excel, sometimes you need to save not only lists, but documents created in 1C (sheets, invoices, etc.). This is due to the fact that many developers find it easier to edit a document in Excel. In addition, in Excel you can view filled-in data by unzipping the document and using it 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 a matter of fact, the use of information from 1C in the Excel format does not create any problems. It is necessary to know the algorithm of action, because, unfortunately, not all traders are intuitively intelligent. With the help of the installed 1C and Excel tools, you can copy in the middle, lists and ranges from one program to another, and also save lists and documents outside the book. There are plenty of saving options, and in order for homeowners to find the right one for their situation, there is no need to go into third-party software or set up simple combinations. ій.