时间:2021-05-20
在winform里拖入一个datagridview控件,跟一个openfiledialog控件
复制代码 代码如下:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Microsoft.Office.Core;
using Excel=Microsoft.Office.Interop.Excel;
using System.Windows.Forms;
using System.Reflection;
namespace Excelproject
{
public partial class ExcelForm : Form
{
private ExcelOperate eo;
private string excelpath;
private Excel.Application excel1;
private Excel.Workbooks wbs = null;
private Excel.Workbook wb = null;
private Excel.Sheets wss;
private Excel.Worksheet ws = null;
private Excel.Range range1 = null;
public ExcelForm()
{
InitializeComponent();
this.excel1 = new Excel.Application();
if (excel1 == null)
{
MessageBox.Show("error");
System.Windows.Forms.Application.Exit();
}
excel1.Visible = true;
}
#region excel文件打开关闭操作
private void 打开_Click(object sender, EventArgs e)
{
openFileDialog1 = new OpenFileDialog();
openFileDialog1.Title = "打开excel文件";
openFileDialog1.Filter = "excel03文件(*.xls)|*.xls|excel07文件(*.xlsx)|*.xlsx";
openFileDialog1.InitialDirectory = @"C:\Users\Administrator\Desktop";
openFileDialog1.RestoreDirectory = true;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
//打开文件对话框选择的文件
excelpath = openFileDialog1.FileName;
eo = new ExcelOperate();
readExcel(excelpath);
}
}
void readExcel(string path)
{
object miss = System.Reflection.Missing.Value;
excel1.UserControl = true;
excel1.DisplayAlerts = false;
excel1.Application.Workbooks.Open(excelpath, miss, miss, miss, miss,
miss, miss, miss, miss,
miss, miss, miss, miss,
miss, miss);
wbs = excel1.Workbooks;
wss = wbs[1].Worksheets;
ws = (Excel.Worksheet) wss.get_Item(1);
int rowNum = ws.UsedRange.Cells.Rows.Count;
int colNum = ws.UsedRange.Cells.Columns.Count;
string cellStr = null;
char ch = 'A';
for (int i = 0; i < colNum; i++)
{
dataGridView1.Columns.Add(i.ToString(), ch.ToString());
dataGridView1.Rows.Add(rowNum);
for (int j = 0; j <rowNum; j++)
{
cellStr = ch.ToString() + (j + 1).ToString();
dataGridView1[i, j].Value = ws.UsedRange.Cells.get_Range(cellStr, miss).Text.ToString();
}
ch++;
}
}
#endregion
}
}
声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。
本文实例讲述了C#实现将数据导出到word或者Excel中的方法。分享给大家供大家参考。具体如下:voidOutToWord(){if(dataGridView
第一次写C#与sql的东西,主要任务是从Excel读取数据,再存到SQLserver中。 先上读取Excel文件的code如下。publicboolGetFi
本文实例讲述了C#利用Openxml读取Excel数据的方法,分享给大家供大家参考。具体分析如下:这里有些问题,如果当Cell里面是日期和浮点型的话,对应的Ce
将DataGridView中的数据导出到Excel中有许多方法,常见的方法是使用OfficeCOM组件将DataGridView中的数据循环复制到ExcelCe
本文实例讲述了C#自定义导出数据到Excel的类。分享给大家供大家参考。具体如下:C#自定义Excel操作类,可以用于将DataTable导出到Excel文件,