关闭

asp.net 读Excel文件

229人阅读 评论(0) 收藏 举报

1.引用.net组件Microsoft.Office.Interop.Excel,

 

using Excel = Microsoft.Office.Interop.Excel;

 

2.Coding;

 

try
            {
                Microsoft.Office.Interop.Excel.Application excelApp = null;
                Excel.Workbook excelWorkbook = null;
                Excel.Worksheet excelWorksheet = null;
                Excel.Range range = null;

 

                string fileName = "sl.xlsx";
                excelApp = new Excel.ApplicationClass();
                excelWorkbook = excelApp.Workbooks.Open(
               fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
               Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
               Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);//打开文件

                excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1];//excelSheets[1],读取第一个工作表
                int RowNum = excelWorksheet.UsedRange.Cells.Rows.Count; //有效行数
                this.Label1.Text += "RowNum="+Convert.ToString(RowNum)+"|";
                string start = "A"; //列起始位置
                string end = "B";//列终止位置
                for (int i = 1; i <= RowNum; i++)
                {
                    range = excelWorksheet.get_Range(start+"" +i.ToString(),end+""+i.ToString());
                    Array array = (Array)range.Cells.Value2;

                    this.Label1.Text += array.GetValue(1, 1).ToString() + "|";
                }
            }
            catch
            {

            }

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:31577次
    • 积分:466
    • 等级:
    • 排名:千里之外
    • 原创:16篇
    • 转载:2篇
    • 译文:0篇
    • 评论:2条
    文章分类
    最新评论