Export & templates
GridControlExport the rows you see to CSV or a real .xlsx workbook, and render a column through your own markup.
Overview
The grid exports itself: ExportToCsvAsync, ExportToXlsxAsync and the other ExportTo…Async
methods take the rows as currently filtered and sorted and the columns as currently visible, build the file on the server with
the library's own writers, and hand it to the browser. Where the File System Access API exists a save dialog opens; elsewhere
the file downloads. A GridColumn with a Template renders whatever markup you put inside it for each row,
with context as the row object; the Status column here renders a BadgeControl.
Examples
#Export the rows you see
Two hundred and fifty estimate lines. Search, filter or sort first, then export: the file holds exactly the rows and columns on screen, in the same order. When the export is done the grid shows the row count in a status pill.
Example
Razor
C#
| Item Code | Description | Trade Category | Status | Takeoff Qty | Unit Price | Total Cost |
|---|---|---|---|---|---|---|
| ITM-00001 | Foundation & Concrete Specification 1 | Foundation | Approved | 1 | $582.89 | $582.89 |
| ITM-00002 | Framing & Timber Specification 2 | Framing | Pending | 2 | $134.77 | $269.54 |
| ITM-00003 | Roofing & Siding Specification 3 | Mechanical | Review | 3 | $121.69 | $365.07 |
| ITM-00004 | Plumbing Rough-In Specification 4 | Electrical | Completed | 4 | $459.35 | $1,837.40 |
| ITM-00005 | Electrical & Lighting Specification 5 | Plumbing | Approved | 5 | $158.17 | $790.85 |
| ITM-00006 | HVAC & Insulation Specification 6 | Interior | Pending | 6 | $238.20 | $1,429.20 |
| ITM-00007 | Drywall & Texturing Specification 7 | Foundation | Review | 7 | $630.75 | $4,415.25 |
| ITM-00008 | Interior Trim & Doors Specification 8 | Framing | Completed | 8 | $450.98 | $3,607.84 |
| ITM-00009 | Flooring & Tile Specification 9 | Mechanical | Approved | 9 | $162.60 | $1,463.40 |
| ITM-00010 | Paint & Finish Specification 10 | Electrical | Pending | 10 | $662.06 | $6,620.60 |
| ITM-00011 | Cabinets & Countertops Specification 11 | Plumbing | Review | 11 | $214.40 | $2,358.40 |
| ITM-00012 | Sitework & Excavation Specification 12 | Interior | Completed | 12 | $233.72 | $2,804.64 |
| ITM-00013 | Foundation & Concrete Specification 13 | Foundation | Approved | 13 | $444.76 | $5,781.88 |
| ITM-00014 | Framing & Timber Specification 14 | Framing | Pending | 14 | $287.20 | $4,020.80 |
| ITM-00015 | Roofing & Siding Specification 15 | Mechanical | Review | 15 | $338.82 | $5,082.30 |
| ITM-00016 | Plumbing Rough-In Specification 16 | Electrical | Completed | 16 | $236.21 | $3,779.36 |
| ITM-00017 | Electrical & Lighting Specification 17 | Plumbing | Approved | 17 | $454.83 | $7,732.11 |
| ITM-00018 | HVAC & Insulation Specification 18 | Interior | Pending | 18 | $45.02 | $810.36 |
| ITM-00019 | Drywall & Texturing Specification 19 | Foundation | Review | 19 | $707.02 | $13,433.38 |
| ITM-00020 | Interior Trim & Doors Specification 20 | Framing | Completed | 20 | $505.62 | $10,112.40 |
| ITM-00021 | Flooring & Tile Specification 21 | Mechanical | Approved | 21 | $352.85 | $7,409.85 |
| ITM-00022 | Paint & Finish Specification 22 | Electrical | Pending | 22 | $144.36 | $3,175.92 |
| ITM-00023 | Cabinets & Countertops Specification 23 | Plumbing | Review | 23 | $91.60 | $2,106.80 |
| ITM-00024 | Sitework & Excavation Specification 24 | Interior | Completed | 24 | $614.38 | $14,745.12 |
| ITM-00025 | Foundation & Concrete Specification 25 | Foundation | Approved | 25 | $708.75 | $17,718.75 |
| ITM-00026 | Framing & Timber Specification 26 | Framing | Pending | 1 | $473.97 | $473.97 |
| ITM-00027 | Roofing & Siding Specification 27 | Mechanical | Review | 2 | $52.53 | $105.06 |
| ITM-00028 | Plumbing Rough-In Specification 28 | Electrical | Completed | 3 | $619.48 | $1,858.44 |
| ITM-00029 | Electrical & Lighting Specification 29 | Plumbing | Approved | 4 | $140.60 | $562.40 |
| ITM-00030 | HVAC & Insulation Specification 30 | Interior | Pending | 5 | $785.28 | $3,926.40 |
| ITM-00031 | Drywall & Texturing Specification 31 | Foundation | Review | 6 | $603.70 | $3,622.20 |
| ITM-00032 | Interior Trim & Doors Specification 32 | Framing | Completed | 7 | $453.95 | $3,177.65 |
| ITM-00033 | Flooring & Tile Specification 33 | Mechanical | Approved | 8 | $173.42 | $1,387.36 |
| ITM-00034 | Paint & Finish Specification 34 | Electrical | Pending | 9 | $50.28 | $452.52 |
| ITM-00035 | Cabinets & Countertops Specification 35 | Plumbing | Review | 10 | $276.97 | $2,769.70 |
| ITM-00036 | Sitework & Excavation Specification 36 | Interior | Completed | 11 | $510.69 | $5,617.59 |
| ITM-00037 | Foundation & Concrete Specification 37 | Foundation | Approved | 12 | $712.91 | $8,554.92 |
| ITM-00038 | Framing & Timber Specification 38 | Framing | Pending | 13 | $18.36 | $238.68 |
| ITM-00039 | Roofing & Siding Specification 39 | Mechanical | Review | 14 | $470.36 | $6,585.04 |
| ITM-00040 | Plumbing Rough-In Specification 40 | Electrical | Completed | 15 | $699.41 | $10,491.15 |
| ITM-00041 | Electrical & Lighting Specification 41 | Plumbing | Approved | 16 | $651.11 | $10,417.76 |
| ITM-00042 | HVAC & Insulation Specification 42 | Interior | Pending | 17 | $341.89 | $5,812.13 |
| ITM-00043 | Drywall & Texturing Specification 43 | Foundation | Review | 18 | $141.75 | $2,551.50 |
| ITM-00044 | Interior Trim & Doors Specification 44 | Framing | Completed | 19 | $37.39 | $710.41 |
| ITM-00045 | Flooring & Tile Specification 45 | Mechanical | Approved | 20 | $58.36 | $1,167.20 |
| ITM-00046 | Paint & Finish Specification 46 | Electrical | Pending | 21 | $679.40 | $14,267.40 |
| ITM-00047 | Cabinets & Countertops Specification 47 | Plumbing | Review | 22 | $547.49 | $12,044.78 |
| ITM-00048 | Sitework & Excavation Specification 48 | Interior | Completed | 23 | $112.90 | $2,596.70 |
| ITM-00049 | Foundation & Concrete Specification 49 | Foundation | Approved | 24 | $227.47 | $5,459.28 |
| ITM-00050 | Framing & Timber Specification 50 | Framing | Pending | 25 | $671.56 | $16,789.00 |
| ITM-00051 | Roofing & Siding Specification 51 | Mechanical | Review | 1 | $261.17 | $261.17 |
| ITM-00052 | Plumbing Rough-In Specification 52 | Electrical | Completed | 2 | $565.92 | $1,131.84 |
| ITM-00053 | Electrical & Lighting Specification 53 | Plumbing | Approved | 3 | $137.10 | $411.30 |
| ITM-00054 | HVAC & Insulation Specification 54 | Interior | Pending | 4 | $52.82 | $211.28 |
| ITM-00055 | Drywall & Texturing Specification 55 | Foundation | Review | 5 | $528.88 | $2,644.40 |
| ITM-00056 | Interior Trim & Doors Specification 56 | Framing | Completed | 6 | $453.53 | $2,721.18 |
| ITM-00057 | Flooring & Tile Specification 57 | Mechanical | Approved | 7 | $58.18 | $407.26 |
| ITM-00058 | Paint & Finish Specification 58 | Electrical | Pending | 8 | $372.31 | $2,978.48 |
| ITM-00059 | Cabinets & Countertops Specification 59 | Plumbing | Review | 9 | $615.59 | $5,540.31 |
| ITM-00060 | Sitework & Excavation Specification 60 | Interior | Completed | 10 | $549.19 | $5,491.90 |
| ITM-00061 | Foundation & Concrete Specification 61 | Foundation | Approved | 11 | $200.68 | $2,207.48 |
| ITM-00062 | Framing & Timber Specification 62 | Framing | Pending | 12 | $26.27 | $315.24 |
| ITM-00063 | Roofing & Siding Specification 63 | Mechanical | Review | 13 | $325.39 | $4,230.07 |
| ITM-00064 | Plumbing Rough-In Specification 64 | Electrical | Completed | 14 | $242.32 | $3,392.48 |
| ITM-00065 | Electrical & Lighting Specification 65 | Plumbing | Approved | 15 | $73.36 | $1,100.40 |
| ITM-00066 | HVAC & Insulation Specification 66 | Interior | Pending | 16 | $625.45 | $10,007.20 |
| ITM-00067 | Drywall & Texturing Specification 67 | Foundation | Review | 17 | $75.30 | $1,280.10 |
| ITM-00068 | Interior Trim & Doors Specification 68 | Framing | Completed | 18 | $409.48 | $7,370.64 |
| ITM-00069 | Flooring & Tile Specification 69 | Mechanical | Approved | 19 | $25.23 | $479.37 |
| ITM-00070 | Paint & Finish Specification 70 | Electrical | Pending | 20 | $693.14 | $13,862.80 |
| ITM-00071 | Cabinets & Countertops Specification 71 | Plumbing | Review | 21 | $388.30 | $8,154.30 |
| ITM-00072 | Sitework & Excavation Specification 72 | Interior | Completed | 22 | $451.47 | $9,932.34 |
| ITM-00073 | Foundation & Concrete Specification 73 | Foundation | Approved | 23 | $439.66 | $10,112.18 |
| ITM-00074 | Framing & Timber Specification 74 | Framing | Pending | 24 | $22.61 | $542.64 |
| ITM-00075 | Roofing & Siding Specification 75 | Mechanical | Review | 25 | $719.51 | $17,987.75 |
| ITM-00076 | Plumbing Rough-In Specification 76 | Electrical | Completed | 1 | $25.96 | $25.96 |
| ITM-00077 | Electrical & Lighting Specification 77 | Plumbing | Approved | 2 | $17.61 | $35.22 |
| ITM-00078 | HVAC & Insulation Specification 78 | Interior | Pending | 3 | $69.21 | $207.63 |
| ITM-00079 | Drywall & Texturing Specification 79 | Foundation | Review | 4 | $571.02 | $2,284.08 |
| ITM-00080 | Interior Trim & Doors Specification 80 | Framing | Completed | 5 | $44.36 | $221.80 |
| ITM-00081 | Flooring & Tile Specification 81 | Mechanical | Approved | 6 | $791.49 | $4,748.94 |
| ITM-00082 | Paint & Finish Specification 82 | Electrical | Pending | 7 | $804.63 | $5,632.41 |
| ITM-00083 | Cabinets & Countertops Specification 83 | Plumbing | Review | 8 | $407.01 | $3,256.08 |
| ITM-00084 | Sitework & Excavation Specification 84 | Interior | Completed | 9 | $334.03 | $3,006.27 |
| ITM-00085 | Foundation & Concrete Specification 85 | Foundation | Approved | 10 | $539.12 | $5,391.20 |
| ITM-00086 | Framing & Timber Specification 86 | Framing | Pending | 11 | $52.78 | $580.58 |
| ITM-00087 | Roofing & Siding Specification 87 | Mechanical | Review | 12 | $331.85 | $3,982.20 |
| ITM-00088 | Plumbing Rough-In Specification 88 | Electrical | Completed | 13 | $135.60 | $1,762.80 |
| ITM-00089 | Electrical & Lighting Specification 89 | Plumbing | Approved | 14 | $386.41 | $5,409.74 |
| ITM-00090 | HVAC & Insulation Specification 90 | Interior | Pending | 15 | $688.44 | $10,326.60 |
| ITM-00091 | Drywall & Texturing Specification 91 | Foundation | Review | 16 | $467.51 | $7,480.16 |
| ITM-00092 | Interior Trim & Doors Specification 92 | Framing | Completed | 17 | $355.59 | $6,045.03 |
| ITM-00093 | Flooring & Tile Specification 93 | Mechanical | Approved | 18 | $267.77 | $4,819.86 |
| ITM-00094 | Paint & Finish Specification 94 | Electrical | Pending | 19 | $786.17 | $14,937.23 |
| ITM-00095 | Cabinets & Countertops Specification 95 | Plumbing | Review | 20 | $513.73 | $10,274.60 |
| ITM-00096 | Sitework & Excavation Specification 96 | Interior | Completed | 21 | $639.84 | $13,436.64 |
| ITM-00097 | Foundation & Concrete Specification 97 | Foundation | Approved | 22 | $31.50 | $693.00 |
| ITM-00098 | Framing & Timber Specification 98 | Framing | Pending | 23 | $764.43 | $17,581.89 |
| ITM-00099 | Roofing & Siding Specification 99 | Mechanical | Review | 24 | $829.03 | $19,896.72 |
| ITM-00100 | Plumbing Rough-In Specification 100 | Electrical | Completed | 25 | $297.91 | $7,447.75 |
| ITM-00101 | Electrical & Lighting Specification 101 | Plumbing | Approved | 1 | $619.09 | $619.09 |
| ITM-00102 | HVAC & Insulation Specification 102 | Interior | Pending | 2 | $153.01 | $306.02 |
| ITM-00103 | Drywall & Texturing Specification 103 | Foundation | Review | 3 | $102.67 | $308.01 |
| ITM-00104 | Interior Trim & Doors Specification 104 | Framing | Completed | 4 | $399.33 | $1,597.32 |
| ITM-00105 | Flooring & Tile Specification 105 | Mechanical | Approved | 5 | $298.26 | $1,491.30 |
| ITM-00106 | Paint & Finish Specification 106 | Electrical | Pending | 6 | $674.69 | $4,048.14 |
| ITM-00107 | Cabinets & Countertops Specification 107 | Plumbing | Review | 7 | $141.27 | $988.89 |
| ITM-00108 | Sitework & Excavation Specification 108 | Interior | Completed | 8 | $129.49 | $1,035.92 |
| ITM-00109 | Foundation & Concrete Specification 109 | Foundation | Approved | 9 | $198.31 | $1,784.79 |
| ITM-00110 | Framing & Timber Specification 110 | Framing | Pending | 10 | $517.91 | $5,179.10 |
| ITM-00111 | Roofing & Siding Specification 111 | Mechanical | Review | 11 | $450.91 | $4,960.01 |
| ITM-00112 | Plumbing Rough-In Specification 112 | Electrical | Completed | 12 | $853.97 | $10,247.64 |
| ITM-00113 | Electrical & Lighting Specification 113 | Plumbing | Approved | 13 | $666.29 | $8,661.77 |
| ITM-00114 | HVAC & Insulation Specification 114 | Interior | Pending | 14 | $586.24 | $8,207.36 |
| ITM-00115 | Drywall & Texturing Specification 115 | Foundation | Review | 15 | $622.71 | $9,340.65 |
| ITM-00116 | Interior Trim & Doors Specification 116 | Framing | Completed | 16 | $261.05 | $4,176.80 |
| ITM-00117 | Flooring & Tile Specification 117 | Mechanical | Approved | 17 | $484.25 | $8,232.25 |
| ITM-00118 | Paint & Finish Specification 118 | Electrical | Pending | 18 | $856.35 | $15,414.30 |
| ITM-00119 | Cabinets & Countertops Specification 119 | Plumbing | Review | 19 | $568.21 | $10,795.99 |
| ITM-00120 | Sitework & Excavation Specification 120 | Interior | Completed | 20 | $35.58 | $711.60 |
| ITM-00121 | Foundation & Concrete Specification 121 | Foundation | Approved | 21 | $308.60 | $6,480.60 |
| ITM-00122 | Framing & Timber Specification 122 | Framing | Pending | 22 | $804.70 | $17,703.40 |
| ITM-00123 | Roofing & Siding Specification 123 | Mechanical | Review | 23 | $38.07 | $875.61 |
| ITM-00124 | Plumbing Rough-In Specification 124 | Electrical | Completed | 24 | $201.79 | $4,842.96 |
| ITM-00125 | Electrical & Lighting Specification 125 | Plumbing | Approved | 25 | $240.63 | $6,015.75 |
| ITM-00126 | HVAC & Insulation Specification 126 | Interior | Pending | 1 | $47.71 | $47.71 |
| ITM-00127 | Drywall & Texturing Specification 127 | Foundation | Review | 2 | $198.71 | $397.42 |
| ITM-00128 | Interior Trim & Doors Specification 128 | Framing | Completed | 3 | $518.49 | $1,555.47 |
| ITM-00129 | Flooring & Tile Specification 129 | Mechanical | Approved | 4 | $373.88 | $1,495.52 |
| ITM-00130 | Paint & Finish Specification 130 | Electrical | Pending | 5 | $94.67 | $473.35 |
| ITM-00131 | Cabinets & Countertops Specification 131 | Plumbing | Review | 6 | $859.46 | $5,156.76 |
| ITM-00132 | Sitework & Excavation Specification 132 | Interior | Completed | 7 | $118.18 | $827.26 |
| ITM-00133 | Foundation & Concrete Specification 133 | Foundation | Approved | 8 | $105.18 | $841.44 |
| ITM-00134 | Framing & Timber Specification 134 | Framing | Pending | 9 | $288.11 | $2,592.99 |
| ITM-00135 | Roofing & Siding Specification 135 | Mechanical | Review | 10 | $290.26 | $2,902.60 |
| ITM-00136 | Plumbing Rough-In Specification 136 | Electrical | Completed | 11 | $653.48 | $7,188.28 |
| ITM-00137 | Electrical & Lighting Specification 137 | Plumbing | Approved | 12 | $716.95 | $8,603.40 |
| ITM-00138 | HVAC & Insulation Specification 138 | Interior | Pending | 13 | $22.69 | $294.97 |
| ITM-00139 | Drywall & Texturing Specification 139 | Foundation | Review | 14 | $50.77 | $710.78 |
| ITM-00140 | Interior Trim & Doors Specification 140 | Framing | Completed | 15 | $729.42 | $10,941.30 |
| ITM-00141 | Flooring & Tile Specification 141 | Mechanical | Approved | 16 | $776.51 | $12,424.16 |
| ITM-00142 | Paint & Finish Specification 142 | Electrical | Pending | 17 | $217.36 | $3,695.12 |
| ITM-00143 | Cabinets & Countertops Specification 143 | Plumbing | Review | 18 | $802.29 | $14,441.22 |
| ITM-00144 | Sitework & Excavation Specification 144 | Interior | Completed | 19 | $733.49 | $13,936.31 |
| ITM-00145 | Foundation & Concrete Specification 145 | Foundation | Approved | 20 | $252.53 | $5,050.60 |
| ITM-00146 | Framing & Timber Specification 146 | Framing | Pending | 21 | $478.54 | $10,049.34 |
| ITM-00147 | Roofing & Siding Specification 147 | Mechanical | Review | 22 | $554.30 | $12,194.60 |
| ITM-00148 | Plumbing Rough-In Specification 148 | Electrical | Completed | 23 | $546.53 | $12,570.19 |
| ITM-00149 | Electrical & Lighting Specification 149 | Plumbing | Approved | 24 | $178.46 | $4,283.04 |
| ITM-00150 | HVAC & Insulation Specification 150 | Interior | Pending | 25 | $267.67 | $6,691.75 |
| ITM-00151 | Drywall & Texturing Specification 151 | Foundation | Review | 1 | $170.59 | $170.59 |
| ITM-00152 | Interior Trim & Doors Specification 152 | Framing | Completed | 2 | $40.15 | $80.30 |
| ITM-00153 | Flooring & Tile Specification 153 | Mechanical | Approved | 3 | $211.22 | $633.66 |
| ITM-00154 | Paint & Finish Specification 154 | Electrical | Pending | 4 | $808.44 | $3,233.76 |
| ITM-00155 | Cabinets & Countertops Specification 155 | Plumbing | Review | 5 | $854.31 | $4,271.55 |
| ITM-00156 | Sitework & Excavation Specification 156 | Interior | Completed | 6 | $679.39 | $4,076.34 |
| ITM-00157 | Foundation & Concrete Specification 157 | Foundation | Approved | 7 | $129.94 | $909.58 |
| ITM-00158 | Framing & Timber Specification 158 | Framing | Pending | 8 | $765.89 | $6,127.12 |
| ITM-00159 | Roofing & Siding Specification 159 | Mechanical | Review | 9 | $173.70 | $1,563.30 |
| ITM-00160 | Plumbing Rough-In Specification 160 | Electrical | Completed | 10 | $265.55 | $2,655.50 |
| ITM-00161 | Electrical & Lighting Specification 161 | Plumbing | Approved | 11 | $490.99 | $5,400.89 |
| ITM-00162 | HVAC & Insulation Specification 162 | Interior | Pending | 12 | $487.78 | $5,853.36 |
| ITM-00163 | Drywall & Texturing Specification 163 | Foundation | Review | 13 | $620.61 | $8,067.93 |
| ITM-00164 | Interior Trim & Doors Specification 164 | Framing | Completed | 14 | $118.64 | $1,660.96 |
| ITM-00165 | Flooring & Tile Specification 165 | Mechanical | Approved | 15 | $523.45 | $7,851.75 |
| ITM-00166 | Paint & Finish Specification 166 | Electrical | Pending | 16 | $347.73 | $5,563.68 |
| ITM-00167 | Cabinets & Countertops Specification 167 | Plumbing | Review | 17 | $763.79 | $12,984.43 |
| ITM-00168 | Sitework & Excavation Specification 168 | Interior | Completed | 18 | $393.18 | $7,077.24 |
| ITM-00169 | Foundation & Concrete Specification 169 | Foundation | Approved | 19 | $310.97 | $5,908.43 |
| ITM-00170 | Framing & Timber Specification 170 | Framing | Pending | 20 | $834.23 | $16,684.60 |
| ITM-00171 | Roofing & Siding Specification 171 | Mechanical | Review | 21 | $409.10 | $8,591.10 |
| ITM-00172 | Plumbing Rough-In Specification 172 | Electrical | Completed | 22 | $476.57 | $10,484.54 |
| ITM-00173 | Electrical & Lighting Specification 173 | Plumbing | Approved | 23 | $820.58 | $18,873.34 |
| ITM-00174 | HVAC & Insulation Specification 174 | Interior | Pending | 24 | $703.79 | $16,890.96 |
| ITM-00175 | Drywall & Texturing Specification 175 | Foundation | Review | 25 | $124.07 | $3,101.75 |
| ITM-00176 | Interior Trim & Doors Specification 176 | Framing | Completed | 1 | $106.23 | $106.23 |
| ITM-00177 | Flooring & Tile Specification 177 | Mechanical | Approved | 2 | $17.42 | $34.84 |
| ITM-00178 | Paint & Finish Specification 178 | Electrical | Pending | 3 | $169.58 | $508.74 |
| ITM-00179 | Cabinets & Countertops Specification 179 | Plumbing | Review | 4 | $814.26 | $3,257.04 |
| ITM-00180 | Sitework & Excavation Specification 180 | Interior | Completed | 5 | $627.08 | $3,135.40 |
Documentation
The export methods and GridExportFormat, and the Template parameter of GridColumn, are still to be written from Grid/GridControl.razor.cs, Grid/GridExportModels.cs and Grid/GridColumn.cs.