html怎么把excel表格合并单元格,c# – 将Epplus Excel转换中的合并单元格处理为HTML...

我正在使用Epplus将Excel电子表格呈现为

HTML.到目前为止,它非常非常好,除了一件事……跨越合并的细胞.我似乎无法使逻辑正确.我想我会把它扔出去看看社区将如何处理它.到目前为止,这是我的代码.

public String ParseExcelStamps(String FileName)

{

FileInfo theFile = new FileInfo(FileName);

String html = "";

using (ExcelPackage xlPackage = new ExcelPackage(theFile))

{

var workbook = xlPackage.Workbook;

if (workbook != null)

{

for (int j = 1; j <= workbook.Worksheets.Count; j++)

{

Tab tab = new Tab();

html+= "

var worksheet = workbook.Worksheets[j];

tab.Title = worksheet.Name;

if (worksheet.Dimension == null) { continue; }

int rowCount = 0;

int maxColumnNumber = worksheet.Dimension.End.Column;

var convertedRecords = new List>(worksheet.Dimension.End.Row);

var excelRows = worksheet.Cells.GroupBy(c => c.Start.Row).ToList();

excelRows.ForEach(r =>

{

rowCount++;

html += String.Format("

");

var currentRecord = new List(maxColumnNumber);

var cells = r.OrderBy(cell => cell.Start.Column).ToList();

Double rowHeight = worksheet.Row(rowCount).Height;

for (int i = 1; i <= maxColumnNumber; i++)

{

var currentCell = cells.Where(c => c.Start.Column == i).FirstOrDefault();

//look aheads for colspan and rowspan

ExcelRangeBase previousCellAbove = null;

ExcelRangeBase previousCell = null;

ExcelRangeBase nextCell = null;

ExcelRangeBase nextCellBelow = null;

try { previousCellAbove = worksheet.Cells[rowCount-1, i]; }catch (Exception) { }

try { previousCell = worksheet.Cells[rowCount, (i - 1)]; }catch (Exception) { }

try { nextCell = worksheet.Cells[rowCount, (i + 1)]; }catch (Exception) { }

try { nextCellBelow = worksheet.Cells[rowCount+1, i]; }catch (Exception) { }

if ((previousCell != null) && (previousCell.Merge) && (currentCell != null) && (currentCell.Merge)){continue;}

if ((previousCellAbove != null) && (previousCellAbove.Merge) && (currentCell != null)) {continue; }

if (currentCell == null)

{

html += String.Format("

{0}", String.Empty);

}

else

{

int colSpan = 1;

int rowSpan = 1;

if ((nextCell != null) && (nextCell.Merge) && (currentCell.Merge)) {

colSpan = 2;

// Console.WriteLine(String.Format("{0} - {1}", currentCell.Address, nextCell.Address));

}

if ((nextCellBelow != null) && (nextCellBelow.Merge) && (currentCell.Merge)) {

Console.WriteLine(String.Format("{0} - {1}", currentCell.Address, nextCellBelow.Address));

}

html += String.Format("

{2}", colSpan, rowSpan, currentCell.Value);

}

}

html += String.Format("

");

});

html += "

";

}//worksheet loop

}

}

return html;

}