我想在excel文件单元的值替换下构建它,但我得到了一个错误
我搜索了,但找不到任何解决方案
using Spire.Xls;
using System;
using System;
using System.Xml;
using System.Data;
using System.Data.Common;
namespace ExcelReplacement
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"exa.xls", ExcelVersion.Version97to2003);
Worksheet worksheet = workbook.Worksheets[0];
try
{
DataView DV = new DataView(workbook);
DV.RowFilter = string.Format(""Sector Responsible"ZPLNTMTLG__ZSEKTORSR: ZSEKTORSR LIKE '%{0}%'");
//Finding
CellRange range = worksheet.FindString("Example", false, false);
//Changing
worksheet.Replace(range.Value, "Result");
}
catch (System.Exception)
{
Console.WriteLine("There is no such a word");
}
workbook.SaveToFile("last.xls", ExcelVersion.Version97to2003);
System.Diagnostics.Process.Start(workbook.FileName);
}
}
}
严重性代码描述项目文件行抑制状态
错误CS1503参数1:无法从'spire.xls.workbook'转换为 'system.data.databable'excelPlacement d: users 26044809 oneDrive- ArçelikA.ş Documents Visual Studio 2015 projects excelreplacement excelreplacement program.cs 23活动
您是否要在Excel中的特定列中替换数据?如果是这样,请使用:
//Replace data within the 1st column
CellRange range = worksheet.Columns[0].FindString("Example", false, false);
用于将工作表转换为DataTable,使用:
DataTable datatable = worksheet.ExportDataTable();