DevExpress の ASPxSpreadsheet での値取得（JavaScript）

DevExpress の ASPxSpreadsheet での全画面設定（JavaScript）のサンプルです。

現状の画面デザインはこのようになっています。
今回はセルの値を取得します。

＜全画面設定（JavaScript）＞

「>」をクリックします。

↓

「Designer…」をクリックします。

↓

「Client-Side Events」をクリックします。

↓

「SelectionChanged」をクリックします。

↓

「s.GetCellValue(myColIdx,myRowIdx);」を使用します。

↓

【サンプルプログラム】

<form id="form1" runat="server">
<div>
    <dx:ASPxSpreadsheet ID="ASPxSpreadsheet1" runat="server" 
        WorkDirectory="D:¥10_PG¥99_サンプル¥VB.net¥2010¥DevExpress¥ASPxSpreadsheet¥Data" 
        Height="700px" Theme="RedWine">
        <RibbonTabs>
            <dx:SRFileTab>
                <Groups>
                    <dx:SRFileCommonGroup Name="共通" Text="共通">
                        <Items>
                            <dx:SRFileNewCommand Name="新規作成" Text="新規作成" Visible="False">
                            </dx:SRFileNewCommand>
                            <dx:SRFileSaveCommand>
                            </dx:SRFileSaveCommand>
                            <dx:SRFileOpenCommand ShowText="False">
                            </dx:SRFileOpenCommand>
                            <dx:SRFileSaveAsCommand>
                            </dx:SRFileSaveAsCommand>
                            <dx:SRFilePrintCommand>
                            </dx:SRFilePrintCommand>
                        </Items>
                    </dx:SRFileCommonGroup>
                </Groups>
            </dx:SRFileTab>
            <dx:SRHomeTab>
                <Groups>
                    <dx:SRClipboardGroup>
                        <Items>
                            <dx:SRPasteSelectionCommand>
                            </dx:SRPasteSelectionCommand>
                            <dx:SRCutSelectionCommand>
                            </dx:SRCutSelectionCommand>
                            <dx:SRCopySelectionCommand>
                            </dx:SRCopySelectionCommand>
                        </Items>
                    </dx:SRClipboardGroup>
                    <dx:SRUndoGroup Visible="False">
                        <Items>
                            <dx:SRFileUndoCommand>
                            </dx:SRFileUndoCommand>
                            <dx:SRFileRedoCommand>
                            </dx:SRFileRedoCommand>
                        </Items>
                    </dx:SRUndoGroup>
                    <dx:SRFontGroup>
                        <Items>
                            <dx:SRFormatFontNameCommand>
                                <PropertiesComboBox NullText="(Font Name)" Width="130px">
                                </PropertiesComboBox>
                            </dx:SRFormatFontNameCommand>
                            <dx:SRFormatFontSizeCommand>
                                <PropertiesComboBox NullText="(Font Size)" Width="60px">
                                </PropertiesComboBox>
                            </dx:SRFormatFontSizeCommand>
                            <dx:SRFormatIncreaseFontSizeCommand>
                            </dx:SRFormatIncreaseFontSizeCommand>
                            <dx:SRFormatDecreaseFontSizeCommand>
                            </dx:SRFormatDecreaseFontSizeCommand>
                            <dx:SRFormatFontBoldCommand>
                            </dx:SRFormatFontBoldCommand>
                            <dx:SRFormatFontItalicCommand>
                            </dx:SRFormatFontItalicCommand>
                            <dx:SRFormatFontUnderlineCommand>
                            </dx:SRFormatFontUnderlineCommand>
                            <dx:SRFormatFontStrikeoutCommand>
                            </dx:SRFormatFontStrikeoutCommand>
                            <dx:SRFormatBordersCommand>
                            </dx:SRFormatBordersCommand>
                            <dx:SRFormatFillColorCommand AutomaticColorItemValue="Automatic">
                            </dx:SRFormatFillColorCommand>
                            <dx:SRFormatFontColorCommand AutomaticColorItemValue="Automatic">
                            </dx:SRFormatFontColorCommand>
                            <dx:SRFormatBorderLineColorCommand AutomaticColorItemValue="Automatic">
                            </dx:SRFormatBorderLineColorCommand>
                        </Items>
                    </dx:SRFontGroup>
                    <dx:SRAlignmentGroup>
                        <Items>
                            <dx:SRFormatAlignmentTopCommand>
                            </dx:SRFormatAlignmentTopCommand>
                            <dx:SRFormatAlignmentMiddleCommand>
                            </dx:SRFormatAlignmentMiddleCommand>
                            <dx:SRFormatAlignmentBottomCommand>
                            </dx:SRFormatAlignmentBottomCommand>
                            <dx:SRFormatAlignmentLeftCommand>
                            </dx:SRFormatAlignmentLeftCommand>
                            <dx:SRFormatAlignmentCenterCommand>
                            </dx:SRFormatAlignmentCenterCommand>
                            <dx:SRFormatAlignmentRightCommand>
                            </dx:SRFormatAlignmentRightCommand>
                            <dx:SRFormatDecreaseIndentCommand>
                            </dx:SRFormatDecreaseIndentCommand>
                            <dx:SRFormatIncreaseIndentCommand>
                            </dx:SRFormatIncreaseIndentCommand>
                            <dx:SRFormatWrapTextCommand>
                            </dx:SRFormatWrapTextCommand>
                            <dx:SREditingMergeCellsGroupCommand>
                            </dx:SREditingMergeCellsGroupCommand>
                        </Items>
                    </dx:SRAlignmentGroup>
                    <dx:SRNumberGroup>
                        <Items>
                            <dx:SRFormatNumberAccountingCommand>
                            </dx:SRFormatNumberAccountingCommand>
                            <dx:SRFormatNumberPercentCommand>
                            </dx:SRFormatNumberPercentCommand>
                            <dx:SRFormatNumberCommaStyleCommand>
                            </dx:SRFormatNumberCommaStyleCommand>
                            <dx:SRFormatNumberIncreaseDecimalCommand>
                            </dx:SRFormatNumberIncreaseDecimalCommand>
                            <dx:SRFormatNumberDecreaseDecimalCommand>
                            </dx:SRFormatNumberDecreaseDecimalCommand>
                        </Items>
                    </dx:SRNumberGroup>
                    <dx:SRCellsGroup>
                        <Items>
                            <dx:SRFormatInsertCommand>
                            </dx:SRFormatInsertCommand>
                            <dx:SRFormatRemoveCommand>
                            </dx:SRFormatRemoveCommand>
                            <dx:SRFormatFormatCommand>
                            </dx:SRFormatFormatCommand>
                        </Items>
                    </dx:SRCellsGroup>
                    <dx:SREditingGroup>
                        <Items>
                            <dx:SRFormatAutoSumCommand>
                            </dx:SRFormatAutoSumCommand>
                            <dx:SRFormatFillCommand>
                            </dx:SRFormatFillCommand>
                            <dx:SRFormatClearCommand>
                            </dx:SRFormatClearCommand>
                            <dx:SREditingSortAndFilterCommand>
                            </dx:SREditingSortAndFilterCommand>
                            <dx:SREditingFindAndSelectCommand>
                            </dx:SREditingFindAndSelectCommand>
                        </Items>
                    </dx:SREditingGroup>
                    <dx:SRStylesGroup>
                        <Items>
                            <dx:SRFormatAsTableCommand>
                            </dx:SRFormatAsTableCommand>
                        </Items>
                    </dx:SRStylesGroup>
                </Groups>
            </dx:SRHomeTab>
            <dx:SRInsertTab>
                <Groups>
                    <dx:SRTablesGroup>
                        <Items>
                            <dx:SRInsertTableCommand>
                            </dx:SRInsertTableCommand>
                        </Items>
                    </dx:SRTablesGroup>
                    <dx:SRIllustrationsGroup>
                        <Items>
                            <dx:SRFormatInsertPictureCommand>
                            </dx:SRFormatInsertPictureCommand>
                        </Items>
                    </dx:SRIllustrationsGroup>
                    <dx:SRChartsGroup>
                        <Items>
                            <dx:SRInsertChartColumnCommand>
                            </dx:SRInsertChartColumnCommand>
                            <dx:SRInsertChartLinesCommand>
                            </dx:SRInsertChartLinesCommand>
                            <dx:SRInsertChartPiesCommand>
                            </dx:SRInsertChartPiesCommand>
                            <dx:SRInsertChartBarsCommand>
                            </dx:SRInsertChartBarsCommand>
                            <dx:SRInsertChartAreasCommand>
                            </dx:SRInsertChartAreasCommand>
                            <dx:SRInsertChartScattersCommand>
                            </dx:SRInsertChartScattersCommand>
                            <dx:SRInsertChartOthersCommand>
                            </dx:SRInsertChartOthersCommand>
                        </Items>
                    </dx:SRChartsGroup>
                    <dx:SRLinksGroup>
                        <Items>
                            <dx:SRFormatInsertHyperlinkCommand>
                            </dx:SRFormatInsertHyperlinkCommand>
                        </Items>
                    </dx:SRLinksGroup>
                </Groups>
            </dx:SRInsertTab>
            <dx:SRPageLayoutTab Name="ページレイアウト" Text="ページレイアウト" Visible="False">
                <Groups>
                    <dx:SRPageSetupGroup ShowDialogBoxLauncher="True">
                        <Items>
                            <dx:SRPageSetupMarginsCommand>
                            </dx:SRPageSetupMarginsCommand>
                            <dx:SRPageSetupOrientationCommand>
                            </dx:SRPageSetupOrientationCommand>
                            <dx:SRPageSetupPaperKindCommand>
                            </dx:SRPageSetupPaperKindCommand>
                        </Items>
                    </dx:SRPageSetupGroup>
                    <dx:SRPrintGroup ShowDialogBoxLauncher="True">
                        <Items>
                            <dx:SRPrintGridlinesCommand>
                            </dx:SRPrintGridlinesCommand>
                            <dx:SRPrintHeadingsCommand>
                            </dx:SRPrintHeadingsCommand>
                        </Items>
                    </dx:SRPrintGroup>
                </Groups>
            </dx:SRPageLayoutTab>
            <dx:SRFormulasTab>
                <Groups>
                    <dx:SRFunctionLibraryGroup>
                        <Items>
                            <dx:SRFunctionsAutoSumCommand>
                            </dx:SRFunctionsAutoSumCommand>
                            <dx:SRFunctionsFinancialCommand>
                            </dx:SRFunctionsFinancialCommand>
                            <dx:SRFunctionsLogicalCommand>
                            </dx:SRFunctionsLogicalCommand>
                            <dx:SRFunctionsTextCommand>
                            </dx:SRFunctionsTextCommand>
                            <dx:SRFunctionsDateAndTimeCommand>
                            </dx:SRFunctionsDateAndTimeCommand>
                            <dx:SRFunctionsLookupAndReferenceCommand>
                            </dx:SRFunctionsLookupAndReferenceCommand>
                            <dx:SRFunctionsMathAndTrigonometryCommand>
                            </dx:SRFunctionsMathAndTrigonometryCommand>
                            <dx:SRFunctionsMoreCommand>
                            </dx:SRFunctionsMoreCommand>
                        </Items>
                    </dx:SRFunctionLibraryGroup>
                    <dx:SRCalculationGroup>
                        <Items>
                            <dx:SRFunctionsCalculationOptionCommand>
                            </dx:SRFunctionsCalculationOptionCommand>
                            <dx:SRFunctionsCalculateNowCommand>
                            </dx:SRFunctionsCalculateNowCommand>
                            <dx:SRFunctionsCalculateSheetCommand>
                            </dx:SRFunctionsCalculateSheetCommand>
                        </Items>
                    </dx:SRCalculationGroup>
                </Groups>
            </dx:SRFormulasTab>
            <dx:SRDataTab>
                <Groups>
                    <dx:SRDataSortAndFilterGroup>
                        <Items>
                            <dx:SRDataSortAscendingCommand>
                            </dx:SRDataSortAscendingCommand>
                            <dx:SRDataSortDescendingCommand>
                            </dx:SRDataSortDescendingCommand>
                            <dx:SRDataFilterToggleCommand ShowText="True">
                            </dx:SRDataFilterToggleCommand>
                            <dx:SRDataFilterClearCommand>
                            </dx:SRDataFilterClearCommand>
                            <dx:SRDataFilterReApplyCommand>
                            </dx:SRDataFilterReApplyCommand>
                        </Items>
                    </dx:SRDataSortAndFilterGroup>
                    <dx:SRDataToolsGroup>
                        <Items>
                            <dx:SRDataToolsDataValidationGroupCommand>
                            </dx:SRDataToolsDataValidationGroupCommand>
                        </Items>
                    </dx:SRDataToolsGroup>
                </Groups>
            </dx:SRDataTab>
            <dx:SRViewTab>
                <Groups>
                    <dx:SRShowGroup>
                        <Items>
                            <dx:SRViewShowGridlinesCommand>
                            </dx:SRViewShowGridlinesCommand>
                        </Items>
                    </dx:SRShowGroup>
                    <dx:SRViewGroup>
                        <Items>
                            <dx:SRFullScreenCommand>
                            </dx:SRFullScreenCommand>
                        </Items>
                    </dx:SRViewGroup>
                    <dx:SRWindowGroup>
                        <Items>
                            <dx:SRViewFreezePanesGroupCommand>
                            </dx:SRViewFreezePanesGroupCommand>
                        </Items>
                    </dx:SRWindowGroup>
                </Groups>
            </dx:SRViewTab>
        </RibbonTabs>
        <ClientSideEvents SelectionChanged="function(s, e) {
        	var myString = '';
            var myColIdx = 5;
            var myRowIdx = 4;

            myString = 'セル（';
            myString = myString + myColIdx;
            myString = myString + '、';
            myString = myString + myRowIdx;
            myString = myString + '）の値は「';
            myString = myString + s.GetCellValue(myColIdx,myRowIdx);
            myString = myString + '」です。';
            alert(myString);	
        }" />
    </dx:ASPxSpreadsheet> 
</div>
</form>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

<div>

<dx:ASPxSpreadsheet ID="ASPxSpreadsheet1" runat="server"

WorkDirectory="D:¥10_PG¥99_サンプル¥VB.net¥2010¥DevExpress¥ASPxSpreadsheet¥Data"

Height="700px" Theme="RedWine">

<dx:SRFileTab>

<dx:SRFileCommonGroup Name="共通" Text="共通">

<Items>

<dx:SRFileNewCommand Name="新規作成" Text="新規作成" Visible="False">

</dx:SRFileNewCommand>

<dx:SRFileSaveCommand>

</dx:SRFileSaveCommand>

<dx:SRFileOpenCommand ShowText="False">

</dx:SRFileOpenCommand>

<dx:SRFileSaveAsCommand>

</dx:SRFileSaveAsCommand>

<dx:SRFilePrintCommand>

</dx:SRFilePrintCommand>

</Items>

</dx:SRFileCommonGroup>

</Groups>

</dx:SRFileTab>

<dx:SRHomeTab>

<dx:SRClipboardGroup>

<Items>

<dx:SRPasteSelectionCommand>

</dx:SRPasteSelectionCommand>

<dx:SRCutSelectionCommand>

</dx:SRCutSelectionCommand>

<dx:SRCopySelectionCommand>

</dx:SRCopySelectionCommand>

</Items>

</dx:SRClipboardGroup>

<dx:SRUndoGroup Visible="False">

<Items>

<dx:SRFileUndoCommand>

</dx:SRFileUndoCommand>

<dx:SRFileRedoCommand>

</dx:SRFileRedoCommand>

</Items>

</dx:SRUndoGroup>

<dx:SRFontGroup>

<Items>

<dx:SRFormatFontNameCommand>

</PropertiesComboBox>

</dx:SRFormatFontNameCommand>

<dx:SRFormatFontSizeCommand>

</PropertiesComboBox>

</dx:SRFormatFontSizeCommand>

<dx:SRFormatIncreaseFontSizeCommand>

</dx:SRFormatIncreaseFontSizeCommand>

<dx:SRFormatDecreaseFontSizeCommand>

</dx:SRFormatDecreaseFontSizeCommand>

<dx:SRFormatFontBoldCommand>

</dx:SRFormatFontBoldCommand>

<dx:SRFormatFontItalicCommand>

</dx:SRFormatFontItalicCommand>

<dx:SRFormatFontUnderlineCommand>

</dx:SRFormatFontUnderlineCommand>

<dx:SRFormatFontStrikeoutCommand>

</dx:SRFormatFontStrikeoutCommand>

<dx:SRFormatBordersCommand>

</dx:SRFormatBordersCommand>

<dx:SRFormatFillColorCommand AutomaticColorItemValue="Automatic">

</dx:SRFormatFillColorCommand>

<dx:SRFormatFontColorCommand AutomaticColorItemValue="Automatic">

</dx:SRFormatFontColorCommand>

<dx:SRFormatBorderLineColorCommand AutomaticColorItemValue="Automatic">

</dx:SRFormatBorderLineColorCommand>

</Items>

</dx:SRFontGroup>

<dx:SRAlignmentGroup>

<Items>

<dx:SRFormatAlignmentTopCommand>

</dx:SRFormatAlignmentTopCommand>

<dx:SRFormatAlignmentMiddleCommand>

</dx:SRFormatAlignmentMiddleCommand>

<dx:SRFormatAlignmentBottomCommand>

</dx:SRFormatAlignmentBottomCommand>

<dx:SRFormatAlignmentLeftCommand>

</dx:SRFormatAlignmentLeftCommand>

<dx:SRFormatAlignmentCenterCommand>

</dx:SRFormatAlignmentCenterCommand>

<dx:SRFormatAlignmentRightCommand>

</dx:SRFormatAlignmentRightCommand>

<dx:SRFormatDecreaseIndentCommand>

</dx:SRFormatDecreaseIndentCommand>

<dx:SRFormatIncreaseIndentCommand>

</dx:SRFormatIncreaseIndentCommand>

<dx:SRFormatWrapTextCommand>

</dx:SRFormatWrapTextCommand>

<dx:SREditingMergeCellsGroupCommand>

</dx:SREditingMergeCellsGroupCommand>

</Items>

</dx:SRAlignmentGroup>

<dx:SRNumberGroup>

<Items>

<dx:SRFormatNumberAccountingCommand>

</dx:SRFormatNumberAccountingCommand>

<dx:SRFormatNumberPercentCommand>

</dx:SRFormatNumberPercentCommand>

<dx:SRFormatNumberCommaStyleCommand>

</dx:SRFormatNumberCommaStyleCommand>

<dx:SRFormatNumberIncreaseDecimalCommand>

</dx:SRFormatNumberIncreaseDecimalCommand>

<dx:SRFormatNumberDecreaseDecimalCommand>

</dx:SRFormatNumberDecreaseDecimalCommand>

</Items>

</dx:SRNumberGroup>

<dx:SRCellsGroup>

<Items>

<dx:SRFormatInsertCommand>

</dx:SRFormatInsertCommand>

<dx:SRFormatRemoveCommand>

</dx:SRFormatRemoveCommand>

<dx:SRFormatFormatCommand>

</dx:SRFormatFormatCommand>

</Items>

</dx:SRCellsGroup>

<dx:SREditingGroup>

<Items>

<dx:SRFormatAutoSumCommand>

</dx:SRFormatAutoSumCommand>

<dx:SRFormatFillCommand>

</dx:SRFormatFillCommand>

<dx:SRFormatClearCommand>

</dx:SRFormatClearCommand>

<dx:SREditingSortAndFilterCommand>

</dx:SREditingSortAndFilterCommand>

<dx:SREditingFindAndSelectCommand>

</dx:SREditingFindAndSelectCommand>

</Items>

</dx:SREditingGroup>

<dx:SRStylesGroup>

<Items>

<dx:SRFormatAsTableCommand>

</dx:SRFormatAsTableCommand>

</Items>

</dx:SRStylesGroup>

</Groups>

</dx:SRHomeTab>

<dx:SRInsertTab>

<dx:SRTablesGroup>

<Items>

<dx:SRInsertTableCommand>

</dx:SRInsertTableCommand>

</Items>

</dx:SRTablesGroup>

<dx:SRIllustrationsGroup>

<Items>

<dx:SRFormatInsertPictureCommand>

</dx:SRFormatInsertPictureCommand>

</Items>

</dx:SRIllustrationsGroup>

<dx:SRChartsGroup>

<Items>

<dx:SRInsertChartColumnCommand>

</dx:SRInsertChartColumnCommand>

<dx:SRInsertChartLinesCommand>

</dx:SRInsertChartLinesCommand>

<dx:SRInsertChartPiesCommand>

</dx:SRInsertChartPiesCommand>

<dx:SRInsertChartBarsCommand>

</dx:SRInsertChartBarsCommand>

<dx:SRInsertChartAreasCommand>

</dx:SRInsertChartAreasCommand>

<dx:SRInsertChartScattersCommand>

</dx:SRInsertChartScattersCommand>

<dx:SRInsertChartOthersCommand>

</dx:SRInsertChartOthersCommand>

</Items>

</dx:SRChartsGroup>

<dx:SRLinksGroup>

<Items>

<dx:SRFormatInsertHyperlinkCommand>

</dx:SRFormatInsertHyperlinkCommand>

</Items>

</dx:SRLinksGroup>

</Groups>

</dx:SRInsertTab>

<dx:SRPageLayoutTab Name="ページレイアウト" Text="ページレイアウト" Visible="False">

<dx:SRPageSetupGroup ShowDialogBoxLauncher="True">

<Items>

<dx:SRPageSetupMarginsCommand>

</dx:SRPageSetupMarginsCommand>

<dx:SRPageSetupOrientationCommand>

</dx:SRPageSetupOrientationCommand>

<dx:SRPageSetupPaperKindCommand>

</dx:SRPageSetupPaperKindCommand>

</Items>

</dx:SRPageSetupGroup>

<dx:SRPrintGroup ShowDialogBoxLauncher="True">

<Items>

<dx:SRPrintGridlinesCommand>

</dx:SRPrintGridlinesCommand>

<dx:SRPrintHeadingsCommand>

</dx:SRPrintHeadingsCommand>

</Items>

</dx:SRPrintGroup>

</Groups>

</dx:SRPageLayoutTab>

<dx:SRFormulasTab>

<dx:SRFunctionLibraryGroup>

<Items>

<dx:SRFunctionsAutoSumCommand>

</dx:SRFunctionsAutoSumCommand>

<dx:SRFunctionsFinancialCommand>

</dx:SRFunctionsFinancialCommand>

<dx:SRFunctionsLogicalCommand>

</dx:SRFunctionsLogicalCommand>

<dx:SRFunctionsTextCommand>

</dx:SRFunctionsTextCommand>

<dx:SRFunctionsDateAndTimeCommand>

</dx:SRFunctionsDateAndTimeCommand>

<dx:SRFunctionsLookupAndReferenceCommand>

</dx:SRFunctionsLookupAndReferenceCommand>

<dx:SRFunctionsMathAndTrigonometryCommand>

</dx:SRFunctionsMathAndTrigonometryCommand>

<dx:SRFunctionsMoreCommand>

</dx:SRFunctionsMoreCommand>

</Items>

</dx:SRFunctionLibraryGroup>

<dx:SRCalculationGroup>

<Items>

<dx:SRFunctionsCalculationOptionCommand>

</dx:SRFunctionsCalculationOptionCommand>

<dx:SRFunctionsCalculateNowCommand>

</dx:SRFunctionsCalculateNowCommand>

<dx:SRFunctionsCalculateSheetCommand>

</dx:SRFunctionsCalculateSheetCommand>

</Items>

</dx:SRCalculationGroup>

</Groups>

</dx:SRFormulasTab>

<dx:SRDataTab>

<dx:SRDataSortAndFilterGroup>

<Items>

<dx:SRDataSortAscendingCommand>

</dx:SRDataSortAscendingCommand>

<dx:SRDataSortDescendingCommand>

</dx:SRDataSortDescendingCommand>

<dx:SRDataFilterToggleCommand ShowText="True">

</dx:SRDataFilterToggleCommand>

<dx:SRDataFilterClearCommand>

</dx:SRDataFilterClearCommand>

<dx:SRDataFilterReApplyCommand>

</dx:SRDataFilterReApplyCommand>

</Items>

</dx:SRDataSortAndFilterGroup>

<dx:SRDataToolsGroup>

<Items>

<dx:SRDataToolsDataValidationGroupCommand>

</dx:SRDataToolsDataValidationGroupCommand>

</Items>

</dx:SRDataToolsGroup>

</Groups>

</dx:SRDataTab>

<dx:SRViewTab>

<dx:SRShowGroup>

<Items>

<dx:SRViewShowGridlinesCommand>

</dx:SRViewShowGridlinesCommand>

</Items>

</dx:SRShowGroup>

<dx:SRViewGroup>

<Items>

<dx:SRFullScreenCommand>

</dx:SRFullScreenCommand>

</Items>

</dx:SRViewGroup>

<dx:SRWindowGroup>

<Items>

<dx:SRViewFreezePanesGroupCommand>

</dx:SRViewFreezePanesGroupCommand>

</Items>

</dx:SRWindowGroup>

</Groups>

</dx:SRViewTab>

</RibbonTabs>

<ClientSideEvents SelectionChanged="function(s, e) {

var myString = '';

var myColIdx = 5;

var myRowIdx = 4;

myString = 'セル（';

myString = myString + myColIdx;

myString = myString + '、';

myString = myString + myRowIdx;

myString = myString + '）の値は「';

myString = myString + s.GetCellValue(myColIdx,myRowIdx);

myString = myString + '」です。';

alert(myString);

}" />

</dx:ASPxSpreadsheet>

</div>

</form>

それでは、実行して動作確認を行います。

↓

無事にエクセル表示の値取得（JavaScript）が出来ました。

MENU

最近の投稿

人気記事

MENU

DevExpress の ASPxSpreadsheet での値取得（JavaScript）

関連記事はこちら:

最近の投稿

人気記事