asp.net 读Excel文件

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
            {

            }

阅读更多
个人分类: asp.net
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭