Show theme settings Shopping cart Download trialFree Trial
Segoe UI
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Custom Data Merge

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
NAME:
DEPARTMENT:
Date
Account
Transport
Fuel
Phone
Entertainment
Misc.
Total
1/16/2013
212340
$ 130.00
$12.42
$ 8.00
$ -
$ 19.20
$ 469.62
2/17/2013
289043
$ -
$16.62
$ 6.80
$ -
$ 29.35
$ 347.77
1/18/2013
212340
$ 10.00
$ -
$ 2.89
$ 90.00
$ 12.30
$ 173.19
12/19/2013
216049
$ 30.00
$ -
$ 9.79
$ 120.00
$110.20
$ 329.99
2/20/2013
292352
$ 150.00
$10.48
$ 9.32
$ -
$ 59.89
$ 570.19
4/21/2013
567384
$ 30.00
$20.14
$ 5.56
$ -
$ 30.70
$ 425.40
078-05-1120
Nick Ellison
Meals
Hotel
Description
$ 250.00
Business trip
$ 50.00
Business trip
$ 45.00
$ 250.00
Holiday
$ -
$ 58.00
$ -
Holiday
$ 60.00
Business trip
$ 45.00
$ 295.50
$ 289.00
$ 50.00
Business trip
HR-manager
Tom Nilson
HR
9547320
PURPOSE:
PAY PERIOD:
534084310
HR-Conference
SSN:
EXPENSE REPORT
from 1/16/2013 to 12/19/2013
STATEMENT NUMBER:
EMPLOYEE INFORMATION:
POSITION:
EMPLOYEE ID:
MANAGER:
5/22/2013
890733
$ 70.00
$15.07
$ 14.05
$ -
$100.93
$ 594.05
11/3/2013
578292
$ -
$33.42
$ 2.00
$ -
$320.20
$ 764.62
11/3/2013
199123
$ 90.00
$13.82
$ 2.60
$ -
$ 23.00
$ 528.42
7/25/2013
423509
$ -
$37.50
$ 2.04
$ 104.06
$ 19.20
$ 222.80
3/26/2013
543288
$ 90.00
$14.20
$ 0.25
$ 60.40
$ 12.00
$ 246.85
10/27/2013
457382
$ 125.00
$16.00
$ 14.00
$ -
$ 35.59
$ 440.59
8/28/2013
584839
$ -
$10.04
$ 12.04
$ -
$ 30.00
$ 297.23
4/29/2013
483922
$ -
$56.50
$ 12.45
$ -
$ 60.00
$ 388.95
10/30/2013
890763
$ 125.00
$ 1.42
$ 1.05
$ -
$148.28
$ 551.20
$ 850.00
$257.63
$102.84
$ 374.46
Subtotal:
$ 6,350.87
APPROVED:
NOTES:
Advances:
TOTAL:
$6,350.87
$ 50.00
$ 349.00
Business trip
Holiday
$ -
$ 60.00
$ -
Holiday
$ 70.00
$ 45.00
$ 205.00
Business trip
$ 40.00
Business trip
$ 205.15
$ 55.45
$ 220.00
Business trip
$2,966.65
$ 788.45
Business trip
$ 205.00
$ 55.00
$ 349.00
$ 45.00
Business trip
$ 349.00
$ 60.00
Business trip
$1,010.84
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK


In this demo, a spreadsheet template is loaded into the DevExpress ASP.NET MVC Spreadsheet and programmatically populated with data taken from an XML file. The template displays the predefined report layout and contains specific aggregate formulas. The data is retrieved from an XML file and merged with the corresponding worksheet cells into an integrated report. As a result, a worksheet represents a complete report calculated automatically.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos