public void OutputTestWorkbook()
{
string html = File.ReadAllText("htmlTable.html");
byte[] data = new WorkbookGenerator().FromHtmlString(html);
File.WriteAllBytes(Path.Combine(Environment.CurrentDirectory, "test.xlsx"), data);
}
private void FillWorkBook(ExportBook book)
{
if (!book.Sheets?.Any() ?? true)
{
throw new Exception("sheets is empty");
}
_workBook = WorkbookGenerator.GetIWorkbook(book.Ext);
foreach (var item in book.Sheets)
{
this.CreateSheet(item.Data.GetType().GetGenericArguments()[0], item.SheetName, item.Title, item.Data?.ToList(), item.FilterColumn?.ToList());
}
}
/// <summary>
/// 导入Excel
/// </summary>
/// <param name="fileStream">excel文件流</param>
/// <param name="ext">excel后缀</param>
/// <param name="importBook">导入模型</param>
/// <param name="outPutErrorStream">错误输出流</param>
/// <returns>导入结果</returns>
public ImportResult ImportExcel(Stream fileStream, ExtEnum ext, ImportBook importBook, Stream outPutErrorStream = null)
{
var ret = new ImportResult();
var sheets = importBook.Sheets.Select(m => this.CreateResultSheetInstance(m.GetType().GenericTypeArguments[0], m)).ToArray();
ret.SetSheets(sheets);
IWorkbook workbook;
try
{
workbook = WorkbookGenerator.GetIWorkbook(fileStream, ext);
}
catch (Exception ex)
{
ret.SetBookFormatErrorMessage(ex.Message, ex);
return(ret);
}
var errorStyleGenerator = new ImporterErrorStyleGenerator(workbook, importBook.DataErrorForegroundColor, importBook.RepeatedErrorForegroundColor, importBook.DefaultForegroundColor);
for (var i = 0; i < workbook.NumberOfSheets; i++)
{
var sheet = workbook.GetSheetAt(i);
var sheetModel = ret.Sheets.FirstOrDefault(m => m.SheetIndex == i || m.SheetName == sheet.SheetName);
if (sheetModel == null)
{
continue;
}
sheetModel.SheetIndex = i;
sheetModel.SheetName = sheet.SheetName;
this.ParseSheetToModel(sheet, sheetModel);
if (outPutErrorStream != null)
{
errorStyleGenerator.InitStyle(sheet, sheetModel.HeaderRowIndex);
errorStyleGenerator.SetErrorStyle(sheet, sheetModel);
}
}
if (outPutErrorStream != null)
{
workbook.Write(outPutErrorStream);
}
return(ret);
}
public Stream Export(ExportBook book, Stream stream)
{
if (stream == null)
{
throw new Exception("stream is null");
}
if (!book.Sheets?.Any() ?? true)
{
throw new Exception("sheets is empty");
}
IWorkbook workbook = WorkbookGenerator.GetIWorkbook(book.Ext);
foreach (var item in book.Sheets)
{
this.CreateSheet(workbook, item.SheetName, item.Title, item.Data, item.FilterColumn);
}
workbook.Write(stream);
workbook.Close();
return(stream);
}
