Excel.Application instance

Question

Hi.
I am creating a program that gets data from a excel file and writes multiple results in several excel files for printing.
When I want to write the files, how many Excel.Application instance is necessary? I mean can I create an instance of Excel.Application for all of the files or I should create Application instance for each of them?
How about Excel.Workbook?

Thanks

Answer 1

@Sundar

 

If client donot want to view any console window to be viewed on the screen then you can go for windows form.

 

Because whenever a console application ran, it shows a black window which might distract the client.

 

For this, change your project output to 'Windows Application' instead of console application.

 

This will let it run on background (without UI).

 

Good Luck! 

Answer 2

Without console App or windows app, the system has to do automatically. I will set the time. Each day by that time, the mail should passed

Answer 3

Elaborate your word 'Machine learning' in this case.

Answer 4

Is there any possibility of implementing Machine Learning ? For this ?

Answer 5

Thank you salman

Answer 6

Here Console will never popup each time. It will run everything in background. This is the best way and as per my understanding there is no other way.

thanks. 

Answer 7

My question is, is there any other way ??? The console should not pop up for each time.

Answer 8

Already You Created Console app right. So just create a Schedular and which will run in background.

thanks. 

Answer 9

Actually I am using task Scheduler for this. I need a better way if any ??. Because, clients does not want to view the console popup at each interval of time. The operatoin should be done automaically in back end 

Answer 10

You can either use Task Scheduler and set your interval or create a windows service.

 

I recommend to use Task Scheduler for this