Automation of my daily reprot.

Question

Hi Team I am Narendra Bhimaneniworking for some MNC organizationhere every week i need to generate one report which we call it as DSR.Intially report(excel) will run by other teamwhich we call it as ACT teamthey are using mainframes(COBOLJCLAndDB2).Depends on their report we are generating final report by creating SQL querywith 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 manuallyi 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 aspnet MVC or C#.

Nilesh Shah · Answer

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.

pritaeas · Answer

https://github.com/tonyqus/npoi You can use this to open and read your Excel file.