PDA

View Full Version : import و export فایل های Word و Excel در #C



Kurdia
یک شنبه 07 آبان 1391, 18:57 عصر
با سلام
می خواستم بدونم چطوریژ می تونم import و export فایل های Word و Excel رو در #C انجام بدم

hamedranjbar20
جمعه 17 آذر 1391, 16:34 عصر
سلام
نمونه کد Import :



private void btnImport_Click(object sender, EventArgs e)
{
OpenFileDialog op = new OpenFileDialog();
op.Filter="Excel Files|*.xlsx";
if (op.ShowDialog() == DialogResult.OK)
{
string path = op.FileName;
string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
OleDbConnection objConn = new OleDbConnection(strConn);
string strSQL = "SELECT * FROM [Sheet1$]";
System.Data.DataTable dt = new System.Data.DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(strSQL,objConn);
da.Fill(dt);
listViewStud.Items.Clear();
foreach (DataRow oddReader in dt.Rows)
{
ListViewItem lst = new ListViewItem();
lst.Tag = oddReader;
lst.Text = oddReader[0] + "";
lst.SubItems.Add(oddReader[1] + "");
lst.SubItems.Add(oddReader[2] + "");
lst.SubItems.Add(oddReader[3] + "");
listViewStud.Items.Add(lst);
}
}

}


واینم نمونه کد Export :



private void btnExcel_Click(object sender, EventArgs e)
{
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;

Range rng4 = excelWorksheet.get_Range("D1", "D1");
rng4.Value2 = "معدل";
rng4.Font.Bold = true;

int i = 1;
foreach (DataRow r in objDataTable.Rows)
{
i++;
Range r1 = excelWorksheet.get_Range("A" + i, "A" + i);
r1.Value2 = r["name"].ToString();
Range r2 = excelWorksheet.get_Range("B" + i, "B" + i);
r2.Value2 = r["family"].ToString();
Range r3 = excelWorksheet.get_Range("C" + i, "C" + i);
r3.Value2 = r["birth"].ToString();
Range r4 = excelWorksheet.get_Range("D" + i, "D" + i);
r4.Value2 = r["avg"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}