C#Winform实现导入和导出Excel文件_c#winform生成excel,winform生成excel资源-CSDN下载

4 浏览量 2021-01-21 18:57:50 上传评论 1 收藏 34KB PDF 举报

资源推荐

资源详情

资源评论

C# Winform实现导入和导出实现导入和导出Excel文件文件

本文实例为大家分享了Winform实现导入导出Excel文件的具体代码，供大家参考，具体内容如下

/// <summary>

/// 导出Excel文件

/// </summary>

/// /// <param name="dataSet"></param>

/// <param name="dataTable">数据集</param>

/// <param name="isShowExcle">导出后是否打开文件</param>

/// <returns></returns>

public static bool DataTableToExcel(string filePath, System.Data.DataTable dataTable, bool isShowExcle)

{

//System.Data.DataTable dataTable = dataSet.Tables[0];

int rowNumber = dataTable.Rows.Count;

int columnNumber = dataTable.Columns.Count;

int colIndex = 0;

if (rowNumber == 0)

{

return false;

}

Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook workbook =

excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);

Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];

excel.Visible = isShowExcle;

Microsoft.Office.Interop.Excel.Range range;

foreach (DataColumn col in dataTable.Columns)

{

colIndex++;

excel.Cells[1, colIndex] = col.ColumnName;

}

object[,] objData = new object[rowNumber, columnNumber];

for (int r = 0; r < rowNumber; r++)

{

for (int c = 0; c < columnNumber; c++)

{

objData[r, c] =dataTable.Rows[r][c];

}

}

range = worksheet.get_Range(excel.Cells[2, 1], excel.Cells[rowNumber + 1, columnNumber]);

range.Value2 = objData;

range.NumberFormatLocal = "@";

worksheet.SaveAs(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing, Type.Missing);

//excel.Quit();

return true;

}

读取Excel文件数据到DataTable

/// <summary>

/// 读取Excel文件数据到DataTable

/// </summary>

/// <param name="filePath">Excel文件路径</param>

private void Import_Excel(string filePath)

{

string sqlconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";

string sql = @"select * from [Sheet1$]";

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余1页未读，立即下载

内容反馈

weixin_38710323

粉丝: 1

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip