1

Topic: Whether there is a fast method of a program spelling of reports Excel?

It would be desirable to draw, for example, title, to issue it according to design, text layout, fonts,  etc., and then at one stroke to generate the code for  that program it to create.
I draw title program, it is necessary to consider all nuances of the text, join of cells, orientation of the fonts, already the second hour, it not a variant.

2

Re: Whether there is a fast method of a program spelling of reports Excel?

I began with template creation in  with the necessary ranges which are already formatted.
It is necessary to fill ranges with the data only.

3

Re: Whether there is a fast method of a program spelling of reports Excel?

wadman wrote:

I began with template creation in  with the necessary ranges which are already formatted.
It is necessary to fill ranges with the data only.

There in one sheet some tables, allocated one under others and sideways from them, and the amount of lines of each table is in advance not known. Therefore the position of the next table should walk on sheet in the arbitrary direction.

4

Re: Whether there is a fast method of a program spelling of reports Excel?

And you fill with the table data on other sheets, and from them links with data migration on sample sheet

5

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad;
outswapping for Ehgrid with a cap and totals
Semifree old ActiveX a component, In the beginning you draw a template in Excel with keywords, then you launch report generation. With restrictions it is possible to consult, but it is not assured that earns in last Excel
In source codes of the project Pineapple on With ++ it is possible to borrow algorithms of filling of templates Calc, by analogy to the previous component ActiveX

6

Re: Whether there is a fast method of a program spelling of reports Excel?

sereginseregin wrote:

svnvlad;
outswapping for Ehgrid with a cap and totals
Well there the variant, the given version not  is more difficult. (Fig.) see.
Something is represented to more real of type of storage of the titles, one empty data package and , and copyings-inserts in total sheet after filling of lines of the data.

7

Re: Whether there is a fast method of a program spelling of reports Excel?

  wrote:

And you fill with the table data on other sheets, and from them links with data migration on sample sheet

It is possible more in detail about data migration by links?

8

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

something Is represented to more real of type of storage of the titles, one empty data package and , and copyings-inserts in total sheet after filling of lines of the data.

The second and third variant just for this purpose
Draw caps and cellars of the tables, one (or a little) lines in between for a tabular part with instructions of names of fields and special tags. The algorithm finds proper places, doubles a line of a tabular part by an amount of lines in the data, brings values in cells.

9

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

I Draw title program, it is necessary to consider all nuances of the text, join of cells, orientation of the fonts, already the second hour, it not a variant.

It not the variant, is idiocy.
Personally I did about twenty years ago so: allowed to analysts to draw a report template, by means of Named Cells marked places where it is necessary to interpose the data, and it was necessary to make only report filling in five lines of type WriteQueryToExcel (qSomeData, MyExcel) and to tell "cripple a template as want, me it any more does not concern".

10

Re: Whether there is a fast method of a program spelling of reports Excel?

softwarer wrote:

it is passed...
It not the variant, is idiocy.
Personally I did about twenty years ago so: allowed to analysts to draw a report template, by means of Named Cells marked places where it is necessary to interpose the data, and it was necessary to make only report filling in five lines of type WriteQueryToExcel (qSomeData, MyExcel) and to tell "cripple a template as want, me it any more does not concern".

And it is possible more in detail about Named Cells and where about it to esteem?
Such template allows to work with dynamic changeable size of data arrays? As in a picture - layout of the lower table will be defined by an amount of lines of the upper table.

11

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

And it is possible more in detail about Named Cells and where about it to esteem?

It that I named a range. It is adjusted in the manager of names of a bookmark of "Formula".

12

Re: Whether there is a fast method of a program spelling of reports Excel?

wadman;
Esteemed about concrete ranges. It not the most terrible. It is possible and to add on cell addresses the data, a difference small.
The most difficult is to shift downwards  tables, to interpose the necessary amount of lines of the data.
The algorithm sees such:
1. We create a template consisting of 4 sheets - under one table on each sheet. In the table only a cap, one empty data package and . The table is lined,  and formatting of cells are generated.
2. At an insertion of the data from  with each new interposed line of the data:
- We interpose before  blank line (or 2 lines, looking what data package);
- We copy an empty data package and it is interposed it these new 2 lines is that formatting and the incorporated cells was copied;
- We interpose from  the data into the first empty unit;
- We repeat depending on an amount of imported lines of the data.
3. We delete the superfluous tail empty unit before .
4. In  we bring totals.
5. In the same way we fill remaining 3 tables on 3 sheets.
6. We create new 5th sheet, and it is done Copy-Paste 3 filled tables from sheets 1,2,3,4 on sheet 5 according to volume of the generated tables.
7. We delete sheets 1,2,3,4.
8. We save a file.

13

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

Such template allows to work with dynamic changeable size of data arrays?

The template is a template. Both you will write operation with it, and allows. Named Cells are necessary just that at an insertion  when the further lines moved downwards, it is easy to find a place where to interpose the following data set. The main complexity actually in other - to make so that when the different data is deduced "in two columns" (different length) to make so that the general  moved correctly (without breaking, on a maximum from their lengths), but thus shorter of tables would not flood the formatting underlaying blank lines.

14

Re: Whether there is a fast method of a program spelling of reports Excel?

softwarer wrote:

it is passed...
The template is a template. Both you will write operation with it, and allows. Named Cells are necessary just that at an insertion  when the further lines moved downwards, it is easy to find a place where to interpose the following data set. The main complexity actually in other - to make so that when the different data is deduced "in two columns" (different length) to make so that the general  moved correctly (without breaking, on a maximum from their lengths), but thus shorter of tables would not flood the formatting underlaying blank lines.

Whether the above-stated algorithm (in my message above) approaches, or the concrete template itself removes  at an insertion of the data?
Whether there is at you an example of operation with concrete ranges, for example, for an insertion of such data packages (where height - 2 lines and are join of cells)?

15

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

the Algorithm sees such

Yes, I at myself and do.
Only I directly in cells allocate type substitutions #Name# which are then replaced with an appropriate field from a data set

16

Re: Whether there is a fast method of a program spelling of reports Excel?

Whether

svnvlad wrote:

the above-stated algorithm (in my message above)

Approaches
Probably, yes. I with the such was not soared, but for absolutely difficult reports, probably, so really it is more convenient.

svnvlad wrote:

or the concrete template itself removes  at an insertion of the data?

The template is a template.  the command "removes to interpose a line" Ekselja. The command is caused from that procedure which deduces .
Whether

svnvlad wrote:

There is at you an example of operation with concrete ranges, for example, for an insertion of such data packages (where height - 2 lines and are join of cells)?

I do not remember. I did it somewhere in two-thousand year, made API of which sufficed under required reports and since then to it was not returned.

17

Re: Whether there is a fast method of a program spelling of reports Excel?

No2 wrote:

it is passed...
Yes, I at myself and do.
Only I directly in cells allocate type substitutions #Name# which are then replaced with an appropriate field from a data set

#Name# means in cells such identifiers are registered? Also search of cells inside  on a finding and changeover of this cell by the data is produced?

18

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

1. We create a template consisting of 4 sheets - under one table on each sheet. In the table only a cap, one empty data package and . The table is lined,  and formatting of cells are generated.
...
6. We create new 5th sheet, and it is done Copy-Paste 3 filled tables from sheets 1,2,3,4 on sheet 5 according to volume of the generated tables.
7. We delete sheets 1,2,3,4.

If at tables the different amount of columns with different width - goes formatting after copying
Besides Named Cells, it is necessary to specify syntactic words sections (units) - lines for filling with tabular data. In Tera XL Report on the right for each unit it is underlined in the first line of the unit #begin table1, by last line of the unit #end table1. In Pineapple in a line of any column [:table_section1:]. Tabular sections (units) on one sheet can be much.

svnvlad wrote:

2. At an insertion of the data from  with each new interposed line of the data:
- We interpose before  blank line (or 2 lines, looking what data package);
- We copy an empty data package and it is interposed it these new 2 lines is that formatting and the incorporated cells was copied;
- We interpose from  the data into the first empty unit;
- We repeat depending on an amount of imported lines of the data.
3. We delete the superfluous tail empty unit before .

The main thing to define the beginning and the end (lines) of the tabular unit on syntactic words. To copy the unit (these lines) on a record count in datasete.
Generally similar reports  in 4 stages
1. Concrete cells of the Cap-cellar of the report (One record from ) are filled
2. In a cycle concrete tabular parts it is filled from the
3. The file is saved in a temporal folder in the form of a template
4. The saved file-template opens

19

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

#Name# means in cells such identifiers are registered? Also search of cells inside  on a finding and changeover of this cell by the data is produced?

Well. At me an insertion of the data only in single line of cells, so search idle time.

20

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

it is passed...
#Name# means in cells such identifiers are registered? Also search of cells inside  on a finding and changeover of this cell by the data is produced?

It is not necessary to sort out: at Range instead of coordinates it is possible to specify string value of the name.

21

Re: Whether there is a fast method of a program spelling of reports Excel?

var app, a, w, ra, r: OleVariant;
begin
app: = CreateOleObject (' Excel. Application ');
app. Application. EnableEvents: = False;
app. DisplayAlerts: = false;
app. WorkBooks. Open (' C:\ARMS\templ.xlsx ');
w: = app. WorkBooks [1];
a: = w. ActiveSheet;
r: = a. Range [' DATA '];

Somehow so.

22

Re: Whether there is a fast method of a program spelling of reports Excel?

sereginseregin wrote:

svnvlad;
outswapping for Ehgrid with a cap and totals
Semifree old ActiveX a component, In the beginning you draw a template in Excel with keywords, then you launch report generation. With restrictions it is possible to consult, but it is not assured that earns in last Excel
In source codes of the project Pineapple on With ++ it is possible to borrow algorithms of filling of templates Calc, by analogy to the previous component ActiveX

Downloaded Afalina XL Report, studied, but it it is somehow strange . The first start normally, but deduces only single line of the data with the truncated data. And the subsequent starts produces an OLE-error, yet you will not create a new same template from zero. More shortly, does not work.
I will try Tera XL Report.
It is a pity that such good components, and sank into oblivion. And new nobody does that is strange!

23

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad, and flexcel did not approach? It is not assured truth that he is able to deduce in some lines

24

Re: Whether there is a fast method of a program spelling of reports Excel?

svnvlad wrote:

It is a pity that such good components, and sank into oblivion. And new nobody does that is strange!

Therefore  for itself in Calc by analogy to Pineapple. We create a template in Calc. We unpack, Parsim, Generim XML, then it is packed reversely, and the ready report in Calc is opened to the user.
Any time thought in Excel xlsx such to make, but there a format subtilized. Is simplified Excel XML which is not packed, but with it there are too nuances after file discovery.

25

Re: Whether there is a fast method of a program spelling of reports Excel?

sereginseregin wrote:

it is passed...
Therefore  for itself in Calc by analogy to Pineapple. We create a template in Calc. We unpack, Parsim, Generim XML, then it is packed reversely, and the ready report in Calc is opened to the user.
Any time thought in Excel xlsx such to make, but there a format subtilized. Is simplified Excel XML which is not packed, but with it there are too nuances after file discovery.

in xml a picture it does not turn out to interpose, at once all on a root cuts

svnvlad wrote:

it is passed...
#Name# means in cells such identifiers are registered? Also search of cells inside  on a finding and changeover of this cell by the data is produced?

there the separate collection is with all Named fields

wadman wrote:

it is passed...
It is not necessary to sort out: at Range instead of coordinates it is possible to specify string value of the name.

Badly that can delete a cell, for example it is not necessary. It is better to take away all list of fields and on it to fill that is possible

Posts [ 1 to 25 of 29 ]

Pages 1 2 Next

You must login or register to post a reply