Coder Forum

C# Quellcode

for (int i = 0; i < MyGrid.Rows.Count - 1; i++)
                {
                    for (int j = 0; j < MyGrid.Columns.Count; j++)
                    {
                        worksheet.Cells[i + 2, j + 1] = MyGrid.Rows[i].Cells[j].Value.ToString();
                        if(j == 6)
                        {
                           // string hlpNumber = MyGrid.Rows[i].Cells[j].Value.ToString();
                           // hlpNumber.Remove(5, 10);
                            //MessageBox.Show(MyGrid.Rows[i].Cells[j].Value.ToString());
 
                           // worksheet.Cells[i + 2, j + 1] = hlpNumber.ToString();
                        }
                    }
                }
 
                ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[1, 6]).EntireColumn.NumberFormat = "0";
 
 
 
 
 
                // save the application
                workbook.SaveAs(saveFileDialog1.FileName,56, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                // Exit from the application
                app.Quit();
            }