cannot create an excel file from asp.net

Question

I am trying to create an excel file but couldnt succeed. I tried to use many examples but the best one is I guess the micrsoft's example.

I get an error on the fourth line where there is a mark the error message like below

"One or more types required to compile a dynamic expression cannot be found. Are you missing a reference?"

What am I doing wrong? How can I fix this or is there a better solution?

var excelApp = new Excel.Application();
excelApp.Visible = false;
excelApp.Workbooks.Add();
Excel._Worksheet workSheet = (Excel.Worksheet)excelApp.ActiveSheet;  //*****ERROR
workSheet.Cells[1, "A"] = "ID Number";
workSheet.Cells[1, "B"] = "Current Balance";

AnalystCave.com · Accepted Answer · 2014-10-26 13:21:49Z

2

Try this:

Excel.Workbook wb = excelApp.Workbooks.Add();
Excel.Worksheet workSheet = (Excel.Worksheet)wb.ActiveSheet;

answered Oct 26, 2014 at 13:21

AnalystCave.com

5,0242 gold badges25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cannot create an excel file from asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related