Reading Excel Ranges from a COM Addin

For some reason, the index starts at 1... don't know why that is, so to convert an excel range into an html table you can do this:

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;
}

Reading Excel Ranges from a COM Addin

Browse Space

Explore Confluence

Your Account

Other Features

Add Content