public string rangeToTable(Excel.Range range) {
int rows = range.Rows.Count;
int cols = range.Columns.Count;
XmlDocument document = new XmlDocument();
XmlNode root = document.CreateElement("table");
document.AppendChild(root);
for ( int row = 1 ; row <= rows ; row++ ) {
XmlNode rowNode = document.CreateElement("tr");
root.AppendChild(rowNode);
for ( int col = 1 ; col <= cols ; col++ ) {
XmlNode columnNode = document.CreateElement("td");
rowNode.AppendChild(columnNode);
columnNode.InnerText = (string)((Excel.Range)range.Cells[row,col]).Text;
}
}
return document.OuterXml;
}