<div>
Hi Litu,<br />
<br />
I would humbly submit that this isn't a Java question, but an Excel/Office automation question. If I were you, I'd go ask in the Excel forum.<br />
<br />
At any rate, you probably know already that Java (J2SE 6.0) contains not one iota of Excel, or even MS Office, specific knowledge or supporting APIs.<br />
<br />

</div>


Hi Litu,

I would humbly submit that this isn't a Java question, but an Excel/Office automation question. If I were you, I'd go ask in the Excel forum.

At any rate, you probably know already that Java (J2SE 6.0) contains not one iota of Excel, or even MS Office, specific knowledge or supporting APIs.



<div>
Hi <br />
Try using JExcelApi or there are some Jakarta tools
</div>


Hi
Try using JExcelApi or there are some Jakarta tools

<div>
<div class="content wysiwyg-content">
I am working on a product in java whereby a xml is parsed and converted to a microsoft excell sheet.The data is parsing properly &nbsp;in the code where I am working .The data parsed is converted into an internal format and from that the data is converted to excel sheet.<br />
<br />
I need java code to implement the functionality such that a new worksheet should be created in excel when the capacity of the current excel is exceeded
</div>
</div>


I am working on a product in java whereby a xml is parsed and converted to a microsoft excell sheet.The data is parsing properly  in the code where I am working .The data parsed is converted into an internal format and from that the data is converted to excel sheet.

I need java code to implement the functionality such that a new worksheet should be created in excel when the capacity of the current excel is exceeded

java code for creating a new worksheet in microsoft excel when the current worksheet exceeds the capacity

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.