project about question paper generation in asp.net

Question

1.How to read random rows from uploaded excel using c#..? 2. How to store those random rows in a text file..? using c#..?

Arun Kumar · Answer

i had tried that too.. but still getting that same error..pls help me sir

Suvendu Shekhar Giri · Answer

Try changing your namespace to alias like- using Excel = Microsoft.Office.Interop.Excel; Hope, it helps :)

Arun Kumar · Answer

yes private void button1_Click(object sender, EventArgs e) { Excel.Range[] rows = RandomRows(10, @"C:	est\whatever.xlsx"); DataTable dt = new DataTable(); bool ColumnsCreated = false; foreach(Excel.Range row in rows) { object[,] values = row.Value; int columnCount = values.Length; if(!ColumnsCreated) { for(int i = 0; i { DataColumn dc = new DataColumn(String.Format("Column {0}", i)); dt.Columns.Add(dc); ColumnsCreated = true; } } DataRow dr = dt.NewRow(); for (int i = 0; i { dr[String.Format("Column {0}", i)] = values[1,i+1]; } dt.Rows.Add(dr); } RandomExcelRows.DataSource = dt; } And then create a method underneath called RandomRows containing the following: private Excel.Range[] RandomRows(int randomRowsToGet, string worksheetLocation, int worksheetNumber = 1, int lowestRow = 0, int highestRow = 99) { Excel.Range[] rows = new Excel.Range[randomRowsToGet]; Excel.Application excel = new Excel.Application(); Excel.Workbook workbook = excel.Workbooks.Open(worksheetLocation); Excel.Worksheet worksheet = workbook.Worksheets[worksheetNumber]; List rowNumbers = new List (); bool allUniqueNumbers = false; Random random = new Random(); while (!allUniqueNumbers) { int nextNumber = random.Next(lowestRow, highestRow); if (!rowNumbers.Contains(nextNumber)) rowNumbers.Add(nextNumber); if (rowNumbers.Count == randomRowsToGet) allUniqueNumbers = true; } for (int i = 0; i { rows[i] = worksheet.UsedRange.Rows[rowNumbers[i]]; } Marshal.ReleaseComObject(excel); return rows; } check this sir..& help meee sir getting error like : the type or namespace name excel could not be found (are you missing a using directive or an assembly reference)

Suvendu Shekhar Giri · Answer

anything you have tried so far?

project about question paper generation in asp.net

Answers (4)