<div>
why not create a spreadsheet with a query per sheet ?<br />
<br />
when they hit refresh in the sheet, the data gets reloaded.<br />
Seems way easier
</div>


<div>
How to do that , As I am fresher in JAVA and SQL DB combination . Please share any samples
</div>


<div>
Also the final should be it should work as automated,, every day the team should the mail notification with the output what they are seeing in the spreadsheet.. Hope you have understood the req..<br />
Let me know if you need more details.
</div>


<div>
there are many examples of how to connect excel to an oracle database<br />
<br />
sample via lmgtfy:<br />
<a href="http://bfy.tw/Grwa" rel="ugc">http://bfy.tw/Grwa</a>
</div>


<div>
there is no point for the mail<br />
just open the spreadsheet and hit refresh
</div>


<div>
it is asking user name and password. Datasorce and Location<br />
from where I can get this information..
</div>


<div>
from the same place you run your query ?
</div>


<div>
No this is not my requirment. Thanks for your help!!!<br />
I am looking for a java script which can be helpful to write into the spreadsheet and send the mail to the team<br />
<br />
Thanks<br />
Venkatesh.
</div>


<div>
I'm not a Java person but if you can create a spreadsheet with one query, it should be a simple matter to add a loop to run through several queries and create a new sheet on each loop.<br />
<br />
Since you say you are new to Java, where did the Java requirement come from? &nbsp;Do you not have Java developers that work with you that can help?<br />
<br />
I posted some .Net code back in 2013 that shows how to create a spreadsheet from table data.<br />
<br />
Hopefully it can give you some ideas:<br />
<a href="https://www.experts-exchange.com/questions/28225475/Best-way-to-export-to-excel-from-OracledataReader-in-c.html?anchorAnswerId=39450396#a39450396" rel="ugc">https://www.experts-exchange.com/questions/28225475/Best-way-to-export-to-excel-from-OracledataReader-in-c.html?anchorAnswerId=39450396#a39450396</a>
</div>


<div>
Thank you NetMinder, But I am keenly looking for Javascript . becoz I can add this code into a scheduler by adding a mail to the code.. &nbsp;Hope you have understood. thanks much for sharing your thoughts.<br />
<br />
Thanks<br />
Venkatesh.
</div>


<div>
Java and JavaScript are two different things.<br />
<br />
Not fully understanding but that is OK. &nbsp;I don't have to. &nbsp;You can schedule and email from just about any language.
</div>


<div>
If who can able to help on my requirent can help me to add the Mail notification at the end with the path where I am placing the output file is really helpful<br />
<br />
Thanks<br />
Venkatesh
</div>


<div>
This might be useful to you<br />
<a href="https://www.experts-exchange.com/questions/28945335/How-do-i-send-mail-with-attachment-and-mail-body-will-have-some-data.html" rel="ugc">https://www.experts-exchange.com/questions/28945335/How-do-i-send-mail-with-attachment-and-mail-body-will-have-some-data.html</a>
</div>


<div>
If possible, please post your code and accept that so others may benefit from it.
</div>


<div>
As my own solution worked here rather than the suggestiong shared by the members
</div>


<div>
<div class="content wysiwyg-content">
I have 5 Quiries which will pull the data from the oracle database and show the results<br />
<br />
Now I am planning to work on a project like as below<br />
<br />
1. JAVA program to use the Quries and pull those information and<br />
2. Write into a spreadsheet with individual sheet names and <br />
3. Finally send out an mail to the team with the link where I have copied the sheets.<br />
<br />
Please share your thoughts<br />
<br />
Thanks<br />
Venkatesh.
</div>
</div>


I have 5 Quiries which will pull the data from the oracle database and show the results

Now I am planning to work on a project like as below

1. JAVA program to use the Quries and pull those information and
2. Write into a spreadsheet with individual sheet names and 
3. Finally send out an mail to the team with the link where I have copied the sheets.

Please share your thoughts

Thanks
Venkatesh.

JAVA &amp; SQL Automation

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

jQuery (Core) is a cross-browser JavaScript library that provides abstractions for common client-side tasks such as Document Object Model (DOM) traversal, DOM manipulation, event handling, animation and Ajax. jQuery also provides a platform to create plugins that extend jQuery's capabilities beyond those already provided by the library.

jQuery

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.

JAVA &amp; SQL Automation

JAVA & SQL Automation