public void CopyData(DataGridView dataGridView, int colFrom, int rowFrom, ExcelData excelData) { int num = Math.Min(dataGridView.ColumnCount - colFrom, excelData.ColumnCount); int num2 = Math.Min(dataGridView.RowCount - rowFrom, excelData.RowCount); int num3 = (colFrom + num) - 1; int num4 = (rowFrom + num2) - 1; int num5 = 0; int num6 = 0; int num7 = colFrom; while (num7 <= num3) { int num8 = rowFrom; while (num8 <= num4) { if (!string.IsNullOrEmpty(excelData[num5, num6])) { dataGridView[num7, num8].Value = excelData[num5, num6]; } num8++; num6++; } num7++; num5++; } }
private bool CheckExcelData(ExcelData excelData) { for (int i = 0; i < excelData.RowCount; i++) { string str; if (!this.FormatExcelCell(excelData[0, i], out str)) { return false; } excelData[0, i] = str; } return true; }
private ExcelData GetClipData() { if (Clipboard.ContainsText(TextDataFormat.Text)) { ExcelData data = new ExcelData(Clipboard.GetText()); if (data.IsValid) { return data; } } return null; }