NOTE: This page has been translated automatically from Russian to English. Original page.
[MXL to XLS]
Solves two problems existing 1C: Enterprise:
* Slow saving spreadsheet documents in Microsoft Excel format.
* Substandard saving spreadsheet documents in Microsoft Excel format.
* Slow saving spreadsheet documents in Microsoft Excel format.
* Substandard saving spreadsheet documents in Microsoft Excel format.
Problem 1: Slow saving.
=================================
The point is that the time needed to store 1C, increases sharply with increasing volume of the stored document. If small documents up to 1-2 thousand. 1C lines still retains a reasonable time, the volume of documents more than 10 thousand. Strings may persist for several hours (or even days).
Problem 2: Poor quality preservation.
======================================
Staff converter 1C does not differ high quality. For example, the converter does not support the text in cells longer than 255 characters when you save a longer text will be truncated. It is also not supported by the cell with the rotation of the text of the cell with a multiline text have a height in a single row, often not transferred multi-cell combination of both. More details can be found on this page: http://yoksel.net.ru/ProblemyStandartnogoMxl2Xls
This process solves these problems.
Speed characteristics.
==========================
The report "Analysis of sales", 18 thousand lines:. 4.46 sec.
The report "Analysis of sales", 78 thousand lines:. 17.23 sec.
The report "Analysis of sales", 184 thousand lines:. 24.44 sec.
(For tables volume of more than 65536 lines stored only 65,536 lines - so the difference between the time of 78 thousand and 184 thousand lines of small..)
Test Pattern 10 thousand rows x 256 columns (2.5 million cells.). 57.32 sec.
Advantages compared with other solutions program
================================================== =====
To speed up the store frequently used solution, known as "patch Romiksa". The decision is due to a modification of the code 1C (patch).
From here follow the main solution to the problem:
- Problems with the release change of 1C - changing release a patch may not work or even lead to unstable operation 1C (CRASH, and the possibility of data loss).
- Potential unreliability: as 1C the source code in the public domain is not present, and there is no absolute certainty in the correctness of the modifications made.
Used in the processing exterior component Yoksel not produce any modification of the executable code 1C, so there are no problems mentioned above.
Another patch problem - "still slow." In the case of tabular documents with complex formatting preservation still performed sufficiently slowly. Component Yoksel keeps tables with complex formatting quickly.
To solve the problems of poor save in Excel spreadsheet documents often use a variety of treatments that works with Excel for OLE-Automation technology and either operate completely independently convert the document, or the document is first converted to standard converter, and then correct the error committed by the converter.
The main drawback of such a solution: slowly. Treatments are written in 1C: Enterprise and therefore are slow because code is interpreted. Further, the brake makes use of OLE-Automation - the technology was never intended for the exchange of large amounts of data.
Another drawback: the need for the availability of Excel. Due to the tightening of the situation of unlicensed software, enterprises often refuse to use Microsoft Office and switch to free software (OpenOffice). Therefore, Excel can not be removed. Also, there are situations when the presence of the computer Excel undesirable - for example, in the case of a terminal server.
Component Yoksel Excel does not require, therefore, can be used where no Excel. Also Yoksel written in a compiled language - so it works fast.
setting
=========
To install the following:
1) If you have not yet installed or Formex 1C ++ version 2.0, copy the component Formex (file FormEx.dll) into the directory with the program files 1C (for example, to C: / Program Files / 1Cv77 / BIN).
2) If you have not yet installed Yoksel component, copy the file "SpreadSheet.dll" in the program files directory with 1C (for example, to C: / Program Files / 1Cv77 / BIN).
(If you can not place external components in the program files directory, you can place the component in the directory information base)
3) Copy the file "Fast Save mxl in xls.ert" subdirectory "ExtForms" directory information base.
4) In the "Configurator" add on any toolbar button to the following:
- Subject: "Task".
- Team: "Zadacha.Vypolnit".
- Tip and a short hint: "Save the Excel table"
- Options - Formula "OtkrytFormu (the" Report ",, KatalogIB () +" ExtForms / Quick save mxl in xls.ert ")"
Using
=============
Switch to the document table 1C, which you want to save to Excel, and click the Create button in the Configurator. On the form, specify where you want to save the spreadsheet document and click "Save".
=================================
The point is that the time needed to store 1C, increases sharply with increasing volume of the stored document. If small documents up to 1-2 thousand. 1C lines still retains a reasonable time, the volume of documents more than 10 thousand. Strings may persist for several hours (or even days).
Problem 2: Poor quality preservation.
======================================
Staff converter 1C does not differ high quality. For example, the converter does not support the text in cells longer than 255 characters when you save a longer text will be truncated. It is also not supported by the cell with the rotation of the text of the cell with a multiline text have a height in a single row, often not transferred multi-cell combination of both. More details can be found on this page: http://yoksel.net.ru/ProblemyStandartnogoMxl2Xls
This process solves these problems.
Speed characteristics.
==========================
The report "Analysis of sales", 18 thousand lines:. 4.46 sec.
The report "Analysis of sales", 78 thousand lines:. 17.23 sec.
The report "Analysis of sales", 184 thousand lines:. 24.44 sec.
(For tables volume of more than 65536 lines stored only 65,536 lines - so the difference between the time of 78 thousand and 184 thousand lines of small..)
Test Pattern 10 thousand rows x 256 columns (2.5 million cells.). 57.32 sec.
Advantages compared with other solutions program
================================================== =====
To speed up the store frequently used solution, known as "patch Romiksa". The decision is due to a modification of the code 1C (patch).
From here follow the main solution to the problem:
- Problems with the release change of 1C - changing release a patch may not work or even lead to unstable operation 1C (CRASH, and the possibility of data loss).
- Potential unreliability: as 1C the source code in the public domain is not present, and there is no absolute certainty in the correctness of the modifications made.
Used in the processing exterior component Yoksel not produce any modification of the executable code 1C, so there are no problems mentioned above.
Another patch problem - "still slow." In the case of tabular documents with complex formatting preservation still performed sufficiently slowly. Component Yoksel keeps tables with complex formatting quickly.
To solve the problems of poor save in Excel spreadsheet documents often use a variety of treatments that works with Excel for OLE-Automation technology and either operate completely independently convert the document, or the document is first converted to standard converter, and then correct the error committed by the converter.
The main drawback of such a solution: slowly. Treatments are written in 1C: Enterprise and therefore are slow because code is interpreted. Further, the brake makes use of OLE-Automation - the technology was never intended for the exchange of large amounts of data.
Another drawback: the need for the availability of Excel. Due to the tightening of the situation of unlicensed software, enterprises often refuse to use Microsoft Office and switch to free software (OpenOffice). Therefore, Excel can not be removed. Also, there are situations when the presence of the computer Excel undesirable - for example, in the case of a terminal server.
Component Yoksel Excel does not require, therefore, can be used where no Excel. Also Yoksel written in a compiled language - so it works fast.
setting
=========
To install the following:
1) If you have not yet installed or Formex 1C ++ version 2.0, copy the component Formex (file FormEx.dll) into the directory with the program files 1C (for example, to C: / Program Files / 1Cv77 / BIN).
2) If you have not yet installed Yoksel component, copy the file "SpreadSheet.dll" in the program files directory with 1C (for example, to C: / Program Files / 1Cv77 / BIN).
(If you can not place external components in the program files directory, you can place the component in the directory information base)
3) Copy the file "Fast Save mxl in xls.ert" subdirectory "ExtForms" directory information base.
4) In the "Configurator" add on any toolbar button to the following:
- Subject: "Task".
- Team: "Zadacha.Vypolnit".
- Tip and a short hint: "Save the Excel table"
- Options - Formula "OtkrytFormu (the" Report ",, KatalogIB () +" ExtForms / Quick save mxl in xls.ert ")"
Using
=============
Switch to the document table 1C, which you want to save to Excel, and click the Create button in the Configurator. On the form, specify where you want to save the spreadsheet document and click "Save".