Generate Excel Advanced Reports

Not long ago the line said to generate an Excel report as follows, try a lot of methods are not, suddenly think of Excel references, macros, try to write down, found the effect is good.

You can refer to this method to generate excel in any format, perhaps a lot of people directly with Cheng line of writing, think this is how complex things ah, want to set the Excel format is more complicated. and the program cycle efficiency is very slow, as I can directly download after the direct printing, the format has been set up. Okay, Nonsense do not say much, feel good to use a lot of promotion, reprint please note from Http://www.cnbolgs.com/xiaobier, thank you. The following is a generated effect chart:

The database I use here is SQL Server. Say something:

First make an Excel style, such as above, I have the title here is fixed, the department and date is dynamic, the column name is fixed, the middle of the data is dynamic, the department attendance name is dynamic, the rest are static.

Do the style first. The following figure is the style I do first:

8,9 Why leave two lines, is for the 10th row of statistical function settings, the Total row is already set up the Excel formula, such as C10 is sum (C8:C9) and so on, if you insert rows to 8,9 the Excel

Automatically expands the formula for line 10th, such as SUM (C8:C9) when the Insert line automatically becomes sum (C8:C10), which everyone should know. and insert a line into the 8,9. His format is the front row of the root

The same, so here is the format of the Dynamic Data area. A few other places are the same.

The date of the third line I was let him quote Sheet2 in the A2, department is B2, attendance is C2