如何从excel中的listview导入数据？ [英] How to import data from listview in excel?

问题描述

try
            {

                string filename = "";
                SaveFileDialog op = new SaveFileDialog();
                op.Filter = "Exel|*.xls";
                if (op.ShowDialog() == DialogResult.OK)
                {
                    filename = op.FileName;
                    StreamWriter wr = new StreamWriter(filename);
                    for (int i = 0; i < DetailsView.Columns.Count; i++)
                    {

                        wr.Write(DetailsView.Columns[i].Text);
                        wr.Write("\t");

                    }
                    wr.Write("\n");

                    for (int r = 0; r < DetailsView.Items.Count - 1; r++)
                    {
                        for (int c = 0; c < DetailsView.Columns.Count; c++)
                        {
                            wr.Write(DetailsView.Items[r].SubItems[c].Text.ToString());
                            wr.Write("\t");
                        }
                        wr.Write("\n");
                    }



                    wr.Close();
                }
                System.Diagnostics.Process.Start(filename);




            }
            catch (SystemException io)
            {
                MessageBox.Show(io.Message);
            }

我的尝试：



这个程序正在运行，但是listview中的最后一个条目没有导入excel请帮帮我。

What I have tried:

this program is working but last entry in listview is not imported to excel please help me.

推荐答案

引用：

这个程序正在运行，但是listview中的最后一个条目不能导入excel请帮帮我..

this program is working but last entry in listview is not import to excel please help me ..

你试过删除 -1 in

Did you try to remove the -1 in

for (int r = 0; r < DetailsView.Items.Count - 1; r++)

这篇关于如何从excel中的listview导入数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！