Exemple #1
0
 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++;
     }
 }
Exemple #2
0
 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;
 }
Exemple #3
0
 private ExcelData GetClipData()
 {
     if (Clipboard.ContainsText(TextDataFormat.Text))
     {
         ExcelData data = new ExcelData(Clipboard.GetText());
         if (data.IsValid)
         {
             return data;
         }
     }
     return null;
 }