获取Excel中的自定义序列

 

private void button1_Click(object sender, EventArgs e)
{
    for (int i = 1; i <= Application.CustomListCount; i++)
    {
        object obj = Application.GetCustomListContents(i);
        Array arr = obj as Array;
        MessageBox.Show(GetString(arr));
    }
}

static string GetString(Array arrlist)
{
    StringBuilder sb = new StringBuilder();
    foreach (string s in arrlist)
    {
        sb.Append(s);
        sb.Append("\r");
    }
    return sb.ToString();
}