使用进度条使用OLEDB从Excel写入和读取数据 [英] writing and reading data from Excel using OLEDB using a progressbar

问题描述

我想知道如何将进度条添加到excel oledb读/写操作

有关如何实现此目标的任何想法?

谢谢，


Jason

Hi,

I would like to know how to add a progress bar to an excel oledb read/write operation

any ideas on how to achieve this ?

Thanks,


Jason

推荐答案

尝试
使用OLEDB读写Excel [ http://csharp.net-informations.com/excel/csharp-excel-oledb.htm [^ ]
http://dotnetbeyond.blogspot.in/2011/09/readwrite-data-in-excel-using-oledb-c.html [

Try
Reading and Writing Excel using OLEDB[^]
http://csharp.net-informations.com/excel/csharp-excel-oledb.htm[^]
http://dotnetbeyond.blogspot.in/2011/09/readwrite-data-in-excel-using-oledb-c.html[^]

引用:
使用MS Excel(xls/xlsx)使用MDAC和Oledb [如何阅读或使用OLEDB数据提供程序写入excel文件 [使用OleDb读取/写入Excel数据 [ ^ ]

类似的讨论:
如何在不使用OLEDB的情况下读取/写入Excel文件 [ CodeProject搜索 [

Refer:
Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]
How to read or write excel file using OLEDB data provider[^]
Read/Write Excel data using OleDb[^]

Similar discussion:
How to read / Write Excel Files without using OLEDB[^]

Have look on similar articles on CodeProject Search[^]

首先获取Excel中记录的总数.

然后在读取每个记录时，通过计算百分比调用进度条.

请参考 http://www.dotnetperls.com/progressbar [使用C#的进度条 [

First get the Total Count of record in the Excel.

Then while reading each record invoke the progress bar by calculating the percentage.

Refer http://www.dotnetperls.com/progressbar[^]
&
Progress Bar using C#[^]

这篇关于使用进度条使用OLEDB从Excel写入和读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！