如何将数据excel导出到listview？ [英] How do I export data excel to listview?

问题描述

大家好，

我想将数据excel导出到listview。我能怎么做？我使用visual studio 2015，c＃



我尝试过：



Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application（）;

Microsoft.Office.Interop.Excel.Workbook xlWorkbook = xlApp.Workbooks.Open （textBox1.Text）; //

Microsoft.Office.Interop.Excel._Worksheet xlWorksheet = xlWorkbook.Sheets [1];

Microsoft.Office.Interop.Excel。范围xlRange = xlWorksheet.UsedRange;



int rowCount = xlRange.Rows.Count;

int colCount = xlRange.Columns.Count; < （$ i $ 0; i< = rowCount; i ++）

$


// for（int j = 1; j< = colCount; j ++）

// {





试试

{





List ViewItem lvitem = new ListViewItem（）;

lvitem.Text = xlRange.Cells [i，1] .Value2.ToString（）;

lvitem.SubItems.Add（xlRange .Cells [i，2] .Value2.ToString（））;

lvitem.SubItems.Add（xlRange.Cells [i，3] .Value2.ToString（））;

listView_playlist.Items.Add（lvitem）;



}

hi all,
I want to export data excel to listview. How can I do? and I use visual studio 2015 , c#

What I have tried:

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(textBox1.Text);//
Microsoft.Office.Interop.Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Microsoft.Office.Interop.Excel.Range xlRange = xlWorksheet.UsedRange;

int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;

for (int i = 0; i <= rowCount; i++)
{

//for (int j = 1; j <= colCount; j++)
//{


try
{


ListViewItem lvitem = new ListViewItem();
lvitem.Text = xlRange.Cells[i, 1].Value2.ToString();
lvitem.SubItems.Add(xlRange.Cells[i, 2].Value2.ToString());
lvitem.SubItems.Add(xlRange.Cells[i, 3].Value2.ToString());
listView_playlist.Items.Add(lvitem);

}

推荐答案

首先，你将需要如何使用C＃读取Excel文件 [ ^ ]

然后，循环到将单元格数据填充到 C＃ListView控件 [ ^ ]

First, you will need to How to read an Excel file using C#[^]
Then, loop to populate the cell data to C# ListView Control[^]

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