110,567
社区成员
发帖
与我相关
我的任务
分享400分求一C#函数:彻底删除EXCEL中某SHEET的第一行
要求:返回BOOL值
参数:String ExcelPath(EXCEL物理地址)
String SheetName(EXCEL工作簿名称)
Int LineSNumber(要删除工作簿里的某行数)
要彻底地删除.......要跟手动在EXCEL表里删除的效果
谢谢大家帮忙!
由于单帖限制,其余300分我另开帖,回复即可
参数:String ExcelPath(EXCEL物理地址)
String SheetName(EXCEL工作簿名称)
Int LineSNumber(要删除工作簿里的某行数)
要彻底地删除.......要跟手动在EXCEL表里删除的效果
谢谢大家帮忙!
由于单帖限制,其余300分我另开帖,回复即可
...全文
请发表友善的回复…
发表回复
pansy5 2010-04-02
- 打赏
- 举报
wzp144650来领分,过一会我再发
http://topic.csdn.net/u/20100402/16/cb07b209-dc06-4d15-bc91-d587de5ae32d.html
http://topic.csdn.net/u/20100402/16/cb07b209-dc06-4d15-bc91-d587de5ae32d.html
cococzj 2010-04-02
- 打赏
- 举报
以上代码需要引用
using Excel = Microsoft.Office.Interop.Excel;
using Excel = Microsoft.Office.Interop.Excel;
cococzj 2010-04-02
- 打赏
- 举报
Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
//根据url打开excel
Excel.Workbook xlWorkbook = xlApp.Workbooks.Add(ExcelPath);
//设置要操作的工作页
Excel.Worksheet xSheet = (Excel.Worksheet)Workbooks.Sheets[pageIndex];
xSheet.Activate();
//得到从rowIndex1到rowIndex2的行
Excel.Range range = xSheet.get_Range(xSheet.Cells[rowIndex1, 1], xSheet.Cells[rowIndex2, xSheet.Columns.Count]);
range.Select();
range.Delete(System.Reflection.Missing.Value);
//根据url打开excel
Excel.Workbook xlWorkbook = xlApp.Workbooks.Add(ExcelPath);
//设置要操作的工作页
Excel.Worksheet xSheet = (Excel.Worksheet)Workbooks.Sheets[pageIndex];
xSheet.Activate();
//得到从rowIndex1到rowIndex2的行
Excel.Range range = xSheet.get_Range(xSheet.Cells[rowIndex1, 1], xSheet.Cells[rowIndex2, xSheet.Columns.Count]);
range.Select();
range.Delete(System.Reflection.Missing.Value);
王子样 2010-04-02
- 打赏
- 举报
[Quote=引用 6 楼 wzp144650 的回复:]
using System;
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
……
[/Quote]
试一下看看。
using System;
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
……
[/Quote]
试一下看看。
wzp144650 2010-04-02
- 打赏
- 举报
using System;
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
{
if (DeleteRow("D:\\SS.XLS", "sheet1", "0"))
Console.WriteLine("true");
else
Console.WriteLine("false");
Console.Read();
}
public static bool DeleteRow(string ExcelPath, string SheetName, string LineSNumber)
{
bool isDelete = false;
try
{
Workbook workbook = new Workbook();
workbook.LoadData(ExcelPath);
Worksheet sheet = workbook.Worksheets[SheetName];
sheet.Cells.DeleteRow(Int32.Parse(LineSNumber));
workbook.Save(ExcelPath);
isDelete = true;
}
catch (Exception ex)
{
isDelete = false;
}
return isDelete;
}
}
}
需要引用aspose.cells组件
下载地址
http://download.csdn.net/source/2192653
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
{
if (DeleteRow("D:\\SS.XLS", "sheet1", "0"))
Console.WriteLine("true");
else
Console.WriteLine("false");
Console.Read();
}
public static bool DeleteRow(string ExcelPath, string SheetName, string LineSNumber)
{
bool isDelete = false;
try
{
Workbook workbook = new Workbook();
workbook.LoadData(ExcelPath);
Worksheet sheet = workbook.Worksheets[SheetName];
sheet.Cells.DeleteRow(Int32.Parse(LineSNumber));
workbook.Save(ExcelPath);
isDelete = true;
}
catch (Exception ex)
{
isDelete = false;
}
return isDelete;
}
}
}
需要引用aspose.cells组件
下载地址
http://download.csdn.net/source/2192653
pansy5 2010-04-02
- 打赏
- 举报
我还顶!!!!
pansy5 2010-04-02
- 打赏
- 举报
自己顶!!
Code従業員 2010-04-02
- 打赏
- 举报
建议用VBA删除，C#的话我代码在家，下班才拿的到，懒的写了
Columns("A:A").Delete Shift:=xlToLeft
Columns("A:A").Delete Shift:=xlToLeft
pansy5 2010-04-02
- 打赏
- 举报
[Quote=引用 1 楼 icdbow 的回复:]
能不能开EXCEL？
[/Quote]
什么意思?
能不能开EXCEL？
[/Quote]
什么意思?
Code従業員 2010-04-02
- 打赏
- 举报
能不能开EXCEL？
