Avatar of litu900
litu900
Flag for India asked on

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

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
JavaMicrosoft ExcelWeb Servers

Avatar of undefined
Last Comment
formula1act

8/22/2022 - Mon
softwarepearls_com

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.

ASKER CERTIFIED SOLUTION
humanonomics

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
formula1act

Hi
Try using JExcelApi or there are some Jakarta tools
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck