private void ggexcelconn(string gangGuSheet)
{
OleDbConnection myConn = null;
DataSet thisDataSet = null;
Excel.Application myExcel = null;
Excel.Workbooks myWorkbooks = null;
Excel._Workbook myWorkbook = null;
Excel._Worksheet myWorksheet = null; try
{
myExcel = new Excel.Application();
myExcel.UserControl = true;
myWorkbooks = myExcel.Workbooks;
myWorkbook = myWorkbooks.Open(@"D:\localserver\filename", Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value);
myWorksheet = (Excel._Worksheet)myWorkbook.Worksheets[gangGuSheet];
myExcel.Cells[1, 1] = "日期";
myExcel.Application.DisplayAlerts = false;
myExcel.Visible = true;
myWorkbook.Save();
}
catch (Exception ex)
{ }
finally
{
if (myExcel != null)
{
myExcel.Quit();
}
}
gangGuSheet 作为 sheet 名传进来 为什么我每次修改的值 都是第一页的值 这个excel表有两个 sheet
{
OleDbConnection myConn = null;
DataSet thisDataSet = null;
Excel.Application myExcel = null;
Excel.Workbooks myWorkbooks = null;
Excel._Workbook myWorkbook = null;
Excel._Worksheet myWorksheet = null; try
{
myExcel = new Excel.Application();
myExcel.UserControl = true;
myWorkbooks = myExcel.Workbooks;
myWorkbook = myWorkbooks.Open(@"D:\localserver\filename", Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value);
myWorksheet = (Excel._Worksheet)myWorkbook.Worksheets[gangGuSheet];
myExcel.Cells[1, 1] = "日期";
myExcel.Application.DisplayAlerts = false;
myExcel.Visible = true;
myWorkbook.Save();
}
catch (Exception ex)
{ }
finally
{
if (myExcel != null)
{
myExcel.Quit();
}
}
gangGuSheet 作为 sheet 名传进来 为什么我每次修改的值 都是第一页的值 这个excel表有两个 sheet
解决方案 »
- 如何在winform中实现word模板的打印预览
- C# 如何读取一个JPG中的多个ICO进入ImageList?
- 各位前辈帮帮忙啦~
- C# 进销存系统
- 为什么在C#里面设置一个按钮的透明度却没有效果出来呢!求!!!
- C# winform button 拦截button点击事件消息
- 急 求助~~~sqlite for .net framework 无法加载System.Data.Sqlite.dll或他的依赖项
- 在c#里设计aspx页面时,用到的是web窗体上的控件,但运行时全部都看不见了(如text控件),这是什么问题?在线等待,谢谢!
- c#中,如何实现 饼形图 和柱形图? 肯定给分!
- 关于打印的问题
- 可以告诉我如何去学C#吗?谢谢!
- 关于Excel上传,是否都要保存了,才能分析里面的数据?
也许这个可以给你帮助