代码之家 › 专栏 › 技术社区 › User987

将对象列表转换为合理可读的CSV/Excel文件

report c#-4.0 file asp.net c#

-1

User987 · 技术社区 · 8 年前

我有两个类,看起来像这样:

 public class SortedUser
    {
        public string Email { get; set; }

        public List<IpInfo> IPAndCountries = new List<IpInfo>();
    }

然后:

 public class IpInfo
    {

        public string Ip { get; set; }


        public string Hostname { get; set; }


        public string City { get; set; }


        public string Region { get; set; }


        public string Country { get; set; }


        public string Loc { get; set; }


        public string Org { get; set; }


        public string Postal { get; set; }

    }

我想从中创建一个合理可读的文件(txt、csv甚至xls/xlsx),它可能看起来像:

User1 Email

IP1 Country City
IP2 Country City
IP3 Country City
and so on...

User2 Email

IP1 Country City
IP2 Country City
IP3 Country City
and so on...

User3 Email

IP1 Country City
IP2 Country City
IP3 Country City
and so on...

最简单的方法是什么?有人能帮我吗?

另外,它甚至可以是一个PDF文件(这将是最好的)。

1 回复 | 直到 8 年前

jdweng 8 年前

请尝试以下操作:

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.IO;

namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:\temp\test.csv";
        static void Main(string[] args)
        {
            SortedUser sortedUser = new SortedUser();
            sortedUser.Output(FILENAME);
        }
    }
    public class SortedUser
    {
        public static List<SortedUser> sortedUsers = new List<SortedUser>();

        public string Email { get; set; }
        public List<IpInfo> IPAndCountries = new List<IpInfo>();

        public void Output(string filename)
        {
            StreamWriter writer = new StreamWriter(filename);
            string line = "";


            line = string.Join(",",new string[] {"Email","Ip","Hostname", "City", "Region", "Country", "Loc", "Org", "Postal"});
            writer.WriteLine(line);

            foreach (SortedUser user in sortedUsers)
            {
                foreach (IpInfo ipInfo in user.IPAndCountries)
                {
                    line = string.Join(",",
                        user.Email,
                        ipInfo.Ip,
                        ipInfo.Hostname,
                        ipInfo.City,
                        ipInfo.Region,
                        ipInfo.Country,
                        ipInfo.Loc,
                        ipInfo.Org,
                        ipInfo.Postal
                    );
                    writer.WriteLine(line);
                }
            }

            writer.Flush();
            writer.Close();
        }
    }


 public class IpInfo
    {
        public string Ip { get; set; }
        public string Hostname { get; set; }
        public string City { get; set; }
        public string Region { get; set; }
        public string Country { get; set; }
        public string Loc { get; set; }
        public string Org { get; set; }
        public string Postal { get; set; }
    }
}