static void Main(string[] args)
{
IExcelPlugin excel = new ExcelPlugin();
var workbook = excel.CreateExcel();
var sheet = excel.CreateSheet(workbook, "sheet1");
sheet = excel.CreateSheet(workbook, "sheet1");
sheet = excel.CreateSheet(workbook, "sheet1");
sheet = excel.CreateSheet(workbook, "sheet1");
//测试1
string json = @"['Small','Medium','Large']";
JArray data = JArray.Parse(json);
var ok = excel.WriteRow(sheet, 0, 1, data);
//测试2
var sheet2 = excel.CreateSheet(workbook, "sheet2");
json = @"[['Small','Medium','Large'],['Small','Medium','Large']]";
data = JArray.Parse(json);
ok = excel.WriteRange(sheet2, 0, 0, data);
ok = excel.Save(workbook, @"C:\Users\Joey\Desktop\百度疫情迁徙数据\山东.xlsx");
Console.WriteLine("保存结果:{0}", ok);
Console.ReadLine();
}
public void TestSetCell2()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
var sheet = excel.GetSheet(workbook, 0);
if (sheet == null)
{
continue;
}
var result = excel.WriteCell(sheet, 5, 5, "just for test value");
excel.Save(workbook, filePath);
if (result)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
}
public void TestReadRange()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
var sheet = excel.GetSheet(workbook, 0);
var result = excel.ReadRange(sheet, "A1:F6");
foreach (var item in result)
{
Console.WriteLine(item.ToString());
}
if (result.Count == 36)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
}
public void TestDeleteSheet()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
workbook = excel.DeleteSheet(workbook, 0);
excel.Close(workbook, true);
}
}
public void TestGetColumsCount()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
var sheet = excel.GetSheet(workbook, 0);
var result = excel.GetColumsCount(sheet);
Console.WriteLine(result);
}
}
public void TestReadRow()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
var sheet = excel.GetSheet(workbook, 0);
var result = excel.ReadRow(sheet, 5);
if (result.Count >= 0)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
}
public void TestReadExcel()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var wb = excel.OpenExcel(filePath);
if (wb != null)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
wb.Close();
}
}
public void TestWriteCell()
{
IExcelPlugin excel = new ExcelPlugin();
var workbook = excel.CreateExcel();
var sheet = excel.CreateSheet(workbook, "shee1");
var result = excel.WriteCell(sheet, 0, 1, "name");
result = excel.WriteCell(sheet, 1, 1, 1);
result = excel.WriteCell(sheet, 2, 1, 23.90);
result = excel.WriteCell(sheet, 3, 1, 3999999999.00000003);
if (result)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
excel.Save(workbook, "");
}
