hesam_dj10
سه شنبه 26 اسفند 1393, 14:55 عصر
سلام من یه کد دارم که اطلاعات دیتا گرید رو مبره تو اکسل
try {
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]);
excelApp.Visible = true;
excelWorksheet.DisplayRightToLeft = true;
Range rng1 = excelWorksheet.get_Range("A1", "A1");
rng1.Value2 = "کد";
rng1.Font.Bold = true;
Range rng2 = excelWorksheet.get_Range("B1", "B1");
rng2.Value2 = "نام";
rng2.Font.Bold = true;
Range rng3 = excelWorksheet.get_Range("C1", "C1");
rng3.Value2 = "نام خانوادگي";
rng3.Font.Bold = true;
int i = 1;
foreach (DataRow r in ds.Tables[0].Rows)
{
i++;
string s = i.ToString();
Range r1 = excelWorksheet.get_Range("A" + s, "A" + s);
r1.Value2 = r[0].ToString();
Range r2 = excelWorksheet.get_Range("B" + s, "B" + s);
r2.Value2 = r[1].ToString();
Range r3 = excelWorksheet.get_Range("C" + s, "C" + s);
r3.Value2 = r[2].ToString();
}
ولی این ارور رو میده
Error 13 'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Excel.DataTable'
قبل این کد هم این کد رو دارم
DataTable dt = new DataTable();
da.Fill(dt);
با این تداخل چه کنم؟؟؟؟؟
try {
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]);
excelApp.Visible = true;
excelWorksheet.DisplayRightToLeft = true;
Range rng1 = excelWorksheet.get_Range("A1", "A1");
rng1.Value2 = "کد";
rng1.Font.Bold = true;
Range rng2 = excelWorksheet.get_Range("B1", "B1");
rng2.Value2 = "نام";
rng2.Font.Bold = true;
Range rng3 = excelWorksheet.get_Range("C1", "C1");
rng3.Value2 = "نام خانوادگي";
rng3.Font.Bold = true;
int i = 1;
foreach (DataRow r in ds.Tables[0].Rows)
{
i++;
string s = i.ToString();
Range r1 = excelWorksheet.get_Range("A" + s, "A" + s);
r1.Value2 = r[0].ToString();
Range r2 = excelWorksheet.get_Range("B" + s, "B" + s);
r2.Value2 = r[1].ToString();
Range r3 = excelWorksheet.get_Range("C" + s, "C" + s);
r3.Value2 = r[2].ToString();
}
ولی این ارور رو میده
Error 13 'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Excel.DataTable'
قبل این کد هم این کد رو دارم
DataTable dt = new DataTable();
da.Fill(dt);
با این تداخل چه کنم؟؟؟؟؟