aspose读Excel

2013-03-15 22:11 hongjiumu 阅读(2630) 评论(0) 编辑收藏举报

private string ReadExcelCell(string path, int row, int column)
        {
            Workbook workbook = new Workbook();
            workbook.Open(path);
 
            Cells cells = workbook.Worksheets[0].Cells;
 
            for (int i = 0; i < cells.MaxDataRow + 1; i++)
            {
                if (i < row) continue;
                for (int j = 0; j < cells.MaxDataColumn + 1; j++)
                {
                    if (j < column) continue;
                    string s = cells[i, j].StringValue.Trim();
                    //一行行的读取数据，插入数据库的代码也可以在这里写
                    return s;
                }
            }
            return "找不到";
        }

private void Read(string path)
        {
            System.Data.DataTable dtDesc = new DataTable();
            dtDesc.Columns.Add("CMD", typeof(System.String));
            dtDesc.Columns.Add("PARA", typeof(System.String));
            dtDesc.Columns.Add("VAL", typeof(System.String));
            dtDesc.Columns.Add("MINVLAUE", typeof(System.String));
            dtDesc.Columns.Add("MAXVALUE", typeof(System.String));
 
            Workbook workbook = new Workbook();
            workbook.Open(path);
 
            Cells cells = workbook.Worksheets[0].Cells;
 
            System.Data.DataRow currentDataRow;
            for (int i = 1; i < cells.MaxDataRow + 1; i++)
            {
                currentDataRow = dtDesc.NewRow();
                for (int j = 0; j < cells.MaxDataColumn + 1; j++)
                {
                    currentDataRow[j] = cells[i, j].StringValue.Trim();
                }
                dtDesc.Rows.Add(currentDataRow);
            }
        }