DevExpress SpreadSheet操作示例

港控/mmm° 2023-08-17 16:01 189阅读 0赞

private void button1_Click(object sender, EventArgs e)
        {
            string fileName = string.Empty;
            openFileDialog.Filter = "Excel 工作簿|*.xlsx|Excel(97-2003)工作簿|*.xls";
            openFileDialog.RestoreDirectory = true;
            if (openFileDialog.ShowDialog() != System.Windows.Forms.DialogResult.OK)
            {
                return;
            }
            txtFilePath.Text = System.IO.Path.GetFullPath(openFileDialog.FileName);
            sheetControl.LoadDocument(txtFilePath.Text);
        }
        private void button2_Click(object sender, EventArgs e)
        {            
            Worksheet sheet = sheetControl.ActiveSheet as Worksheet;
            var rowInfo= sheetControl.ActiveWorksheet.Rows;
            Range range = sheetControl.ActiveWorksheet.GetDataRange();
            for (int row = 0; row < range.RowCount; row++ )
            {
                for (int col = 0; col < range.ColumnCount; col++)
                {
                    string s = sheetControl.ActiveWorksheet.GetCellValue(col, row).TextValue;
                    MessageBox.Show(s);
                }
            }
        }