首页 新闻 会员 周边 捐助

excellibrary控件做excel导入怎么做呀

0
[待解决问题]

//create new xls file
        string file = "C:\\newdoc.xls";
        Workbook workbook = new Workbook();
        Worksheet worksheet = new Worksheet("First Sheet");
        worksheet.Cells[0, 1] = new Cell((short)1);
        worksheet.Cells[2, 0] = new Cell(9999999);
        worksheet.Cells[3, 3] = new Cell((decimal)3.45);
        worksheet.Cells[2, 2] = new Cell("Text string");
        worksheet.Cells[2, 4] = new Cell("Second string");
        worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
        worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
        worksheet.Cells.ColumnWidth[0, 1] = 3000;
        workbook.Worksheets.Add(worksheet);
        workbook.Save(file);
        
        // open xls file
        Workbook book = Workbook.Load(file);
        Worksheet sheet = book.Worksheets[0];

        // traverse cells
        //把当前单元格cell的后边的值,Pair<Pair<int, int>, Cell>
        //就是那个大写Cell,赋值给了以dgvCells的结构数组,
        //数组的x值指的是当前循环的cell的左边就是Pair的后边值就是那个int,
        //y值指的是当前循环cell变量里的左边即Pair的左边值就是那个int
        foreach (Pair<Pair<int, int>, Cell> cell in sheet.Cells)
        {
            
            dgvCells[cell.Left.Right, cell.Left.Left].Value = cell.Right.Value;
        }
        // traverse rows by Index
        for (int rowIndex = sheet.Cells.FirstRowIndex;
           rowIndex <= sheet.Cells.LastRowIndex; rowIndex++)
        {
            Row row = sheet.Cells.GetRow(rowIndex);
            for (int colIndex = row.FirstColIndex;
           colIndex <= row.LastColIndex; colIndex++)
            {
                Cell cell = row.GetCell(colIndex);
            }
        }
dgvCells[cell.Left.Right, cell.Left.Left].Value = cell.Right.Value;这个不太懂,然后没有定义

问题补充:

dgvCells[cell.Left.Right, cell.Left.Left].Value = cell.Right.Value;这个会报错。

清空回声的主页 清空回声 | 菜鸟二级 | 园豆:204
提问于:2014-07-28 18:26
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册