Esportare dati in formato ODS (Foglio di Calcolo OpenDocument)
public static void ExportToOds(DataSet source, string fileName)
{
System.IO.StreamWriter excelDoc;
excelDoc = new System.IO.StreamWriter(fileName);
excelDoc.Write("<table>");
excelDoc.Write("<tr>");
{
System.IO.StreamWriter excelDoc;
excelDoc = new System.IO.StreamWriter(fileName);
excelDoc.Write("<table>");
excelDoc.Write("<tr>");
for (int x = 0; x < source.Tables[0].Columns.Count; x++)
{
excelDoc.Write("<td align=\"left\" valign=\"middle\" width=\"100%\"><strong>");
excelDoc.Write(source.Tables[0].Columns[x].ColumnName);
excelDoc.Write("</strong></td>");
}
excelDoc.Write("</tr>");
foreach (DataRow x in source.Tables[0].Rows)
{
excelDoc.Write("<tr>");
for (int y = 0; y < source.Tables[0].Columns.Count; y++)
{
excelDoc.Write("<td align=\"left\" valign=\"middle\">");
excelDoc.Write(string.Format("{0}", x[y]));
excelDoc.Write("</td>");
}
excelDoc.Write("</tr>");
}
excelDoc.Write("</table>");
excelDoc.Close();
}