Reading and Writing into excel sheets using java code?

read from and write into excel using java

[manoj_kgm]

Hi People,

I have a requirement to read from and write into excel sheet using the java code. can some one tell me what is the best way to do this using java? i want to read from multiple excel sheets and collate them into a single one . Thanks in advance.

Cheers,
manoj

[gergoe]

Your question is rather confusing;

You are either looking for a way to alter excel documents from JavaScript, which is looking for trouble, will only work on Windows platforms, and only with the proper ActiveX objects installed, and so on. In this case you actually need some excel macros or something equivalent.

Or (which I find more likely to be the case), you are looking for a Java code which does work with excel document, but if that's the case, you posted the question to the wrong forum, this is about the JavaScript (client-side scripting language), not about the Java, which is a more robust programming language, and has almost nothing to do with JavaScript.

[penders]

If Java, you could try asking in the Website Technology Issues [webmasterworld.com] forum - which apparently covers Java (as mentioned in this thread: Are we missing a Java Forum here [webmasterworld.com])