Automation of my daily reprot.

Narendra Bhimaneni

Hi Team,

I am Narendra Bhimaneni,working for some MNC organization,here every week i need to generate one report which we call it as DSR.Intially report(excel) will run by other team,which we call it as ACT team,they are using mainframes(COBOL,JCL,AndDB2).Depends on their report we are generating final report by creating SQL query,with one view which will work as a teporary table.we are passing their data into a view to work as a temporary table.Finall we are getting data from our backend.All these work is going manually,i want to generate one automation process for this stuff.

Can any body please explain how to read their data through an excel, and depend on that data i need to pull finall data using oracle backend and C# .eaither asp,net MVC or C#.

2 Replies

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

Nilesh Shah9y ago
Can the ACT team also create the same data in your Oracle database instead of creating the excel file?

if yes, then ACT team insert data in a table in Oracle, you create a view which can read data from this excel as per your required report format

if no, then let them write this excel to a share path on some network drive, you create a C# windows service or console app which is scheduled to watch that folder for new file created, as and when new file is created in that folder, this service or console app picks up the file, inserts data in Oracle db, then your view does rest of the work, or you can create a SQL job which will populate the data in required format.

There is also a windows file watcher control which can look for a new file created in a folder.
0
Guest User9y ago
https://github.com/tonyqus/npoi

You can use this to open and read your Excel file.
-1