project about question paper generation in asp.net

yes

private void button1_Click(object sender, EventArgs e)

{

Excel.Range[] rows = RandomRows(10, @"C:\test\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 < columnCount; 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 < columnCount; 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 < randomRowsToGet; 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)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Omkar Gupta7y ago
Can u give me source code of questions paper generator app
Arun Kumar9y ago
i had tried that too.. but still getting that same error..pls help me sir
Suvendu Shekhar Giri9y ago
Try changing your namespace to alias like-
using Excel = Microsoft.Office.Interop.Excel;
Hope, it helps :)
Arun Kumar9y ago
yes

private void button1_Click(object sender, EventArgs e)
{
Excel.Range[] rows = RandomRows(10, @"C:\test\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 < columnCount; 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 < columnCount; 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 < randomRowsToGet; 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 Giri9y ago
anything you have tried so far?