excel转html td tr,在Epplus Excel中处理合并单元格转换为HTML

我正在使用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;

}

+0

我会问的第一个问题是，它是否可以编辑工作表中取消合并单元格。值得一试？ –

2012-07-11 00:24:50

+0

我真的很想解决这个问题，而不必编辑源代码，再加上Im不能控制源文档。 –

2012-07-11 20:46:21

+0

这个技巧就是Epplus的cell.merge只返回一个布尔值。当您检查一个单元格以查看它是否合并时，无法判断它是否与单元格在之前，之后，之下或之前合并，因此无法确定它是否是colspan或rowspan。 –

2012-07-11 20:48:50