reza11_2005
یک شنبه 30 فروردین 1394, 12:05 عصر
سلام این قطعه کد ببنید
void ExportToExcel(DataGridView dgv)
{
try
{
System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentUICul ture;
System.Threading.Thread.CurrentThread.CurrentUICul ture = new System.Globalization.CultureInfo("en-US");
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook excelBook = excelApp.Workbooks.Add(XlSheetType.xlWorksheet);
Microsoft.Office.Interop.Excel.Worksheet excelWorksheet = (Worksheet)(excelBook.Worksheets[1]);
excelWorksheet.DisplayRightToLeft = true;
int ClmnCnt = dgv.Columns.Count;
Range[] rng = new Range[ClmnCnt];
for (int x = 0; x < ClmnCnt; x++)
{
string CellAddress = Convert.ToString(Convert.ToChar(Convert.ToByte(x + 65))) + "1";
rng[x] = excelWorksheet.get_Range(CellAddress, CellAddress);
rng[x].Value2 = dgv.Columns[x].HeaderText;
}
int j = 2;
foreach (DataRow r in ds.Tables[0].Rows)
{
for (int k = 0; k < ClmnCnt; k++)
{
string CellAddress = Convert.ToString(Convert.ToChar(Convert.ToByte (k + 65))) + j.ToString();
rng[k] = excelWorksheet.get_Range(CellAddress, CellAddress);
rng[k].Value2 = r[k].ToString();
}
j++;
}
excelApp.Visible=true;
}
catch (Exception ex)
{
MessageBox.Show("مشکلی در تبدیل به موجود آمده است");
}
}
نمی دانم کجایش مشکل دارم
void ExportToExcel(DataGridView dgv)
{
try
{
System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentUICul ture;
System.Threading.Thread.CurrentThread.CurrentUICul ture = new System.Globalization.CultureInfo("en-US");
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook excelBook = excelApp.Workbooks.Add(XlSheetType.xlWorksheet);
Microsoft.Office.Interop.Excel.Worksheet excelWorksheet = (Worksheet)(excelBook.Worksheets[1]);
excelWorksheet.DisplayRightToLeft = true;
int ClmnCnt = dgv.Columns.Count;
Range[] rng = new Range[ClmnCnt];
for (int x = 0; x < ClmnCnt; x++)
{
string CellAddress = Convert.ToString(Convert.ToChar(Convert.ToByte(x + 65))) + "1";
rng[x] = excelWorksheet.get_Range(CellAddress, CellAddress);
rng[x].Value2 = dgv.Columns[x].HeaderText;
}
int j = 2;
foreach (DataRow r in ds.Tables[0].Rows)
{
for (int k = 0; k < ClmnCnt; k++)
{
string CellAddress = Convert.ToString(Convert.ToChar(Convert.ToByte (k + 65))) + j.ToString();
rng[k] = excelWorksheet.get_Range(CellAddress, CellAddress);
rng[k].Value2 = r[k].ToString();
}
j++;
}
excelApp.Visible=true;
}
catch (Exception ex)
{
MessageBox.Show("مشکلی در تبدیل به موجود آمده است");
}
}
نمی دانم کجایش مشکل دارم