代码改变世界

aspose读Excel

2013-03-15 22:11  hongjiumu  阅读(2453)  评论(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);
            }
        }

aspose.ExportDataTable对同时包含number和数据的列,只取number忽略string.