首先来看转换成Excel
StreamWriter sw = new StreamWriter(Server.MapPath("Public/DataExport/Data.xls"), false, System.Text.Encoding.GetEncoding(0));
string str = "";
Array array = null;
for (int i = 0; i < arraylist.Count; i++)
{
str = "";
array = ((Array)arraylist[i]);
for (int k = 0; k < array.Length; k++)
{
str += "\t" + (array.GetValue(k) == null ? "" : array.GetValue(k).ToString());
}
sw.WriteLine(str);
}
sw.Close();
现在我们转换成xml
StreamWriter sw = new StreamWriter(Server.MapPath("Public/DataExport/Data.xml"), false, System.Text.Encoding.GetEncoding(-0));
string str = "<?xml version=\"1.0\" encoding=\"gb2312\" ?><maps>";
sw.WriteLine(str);
Array array = null;
for (int i = 1; i < arraylist.Count; i++)
{
str = "<map>";
sw.WriteLine(str);
array = ((Array)arraylist[i]);
for (int k = 0; k < array.Length; k++)
{
str = "<" + ((Array)arraylist[0]).GetValue(k).ToString() + ">" + (array.GetValue(k) == null ? "" : array.GetValue(k).ToString()) + "</" +((Array)arraylist[0]).GetValue(k).ToString() + ">";
sw.WriteLine(str);
}
str = "</map>";
sw.WriteLine(str);
}
str = "</maps>";
sw.WriteLine(str);
sw.Close();
当然这里我们进行的是比较简单的转换,对于复杂的转换需要我们酌情处理。