ArrayList转换成Excel或xml文件

首先来看转换成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();

当然这里我们进行的是比较简单的转换，对于复杂的转换需要我们酌情处理。