4 Replies - 7068 Views - Last Post: 02 September 2009 - 04:38 PM Rate Topic: -----

#1 smitakardak  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 02-September 09

How i convert excel file into csv file using java code

Post icon  Posted 02 September 2009 - 03:06 AM

Hi,
I want to convert my excel file into csv file plz tel me how i do this in java ,VB,C# or ASP.NET .

plz rep me as soon as possible.
waiting for reply.
Thanks .
Is This A Good Question/Topic? 0
  • +

Replies To: How i convert excel file into csv file using java code

#2 syfran  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 83
  • View blog
  • Posts: 1,103
  • Joined: 12-July 09

Re: How i convert excel file into csv file using java code

Posted 02 September 2009 - 03:18 AM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

#3 NickDMax  Icon User is offline

  • Can grep dead trees!
  • member icon

Reputation: 2250
  • View blog
  • Posts: 9,245
  • Joined: 18-February 07

Re: How i convert excel file into csv file using java code

Posted 02 September 2009 - 10:31 AM

@syfran -- why? the question was not asking for code it was asking for advice -- you can give advice without code. Even giving code here would not be against the rules since this is a pretty advanced technique that would be hard to explain to someone.

@smitakardak -- Java is not the best place to do this. Excel is. So if you want to automate the process than look at scripting languages such as Javascript/VBScript which can connect to Excel though COM.

However, if you would really LIKE to use java you can. There is a Java-COM bridge called JACOB that can be used to connect to COM objects from java. From here it should be pretty easy to figure out from MSDN's description of Excel's COM model.

Another direction you could go in Java is to actually parse the excel files using Apache's POI -- this would be a better approach if this is something you will be doing a great deal or need to have done form a webserver etc.
Was This Post Helpful? 0
  • +
  • -

#4 syfran  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 83
  • View blog
  • Posts: 1,103
  • Joined: 12-July 09

Re: How i convert excel file into csv file using java code

Posted 02 September 2009 - 12:09 PM

Quote

@syfran -- why? the question was not asking for code it was asking for advice -- you can give advice without code. Even giving code here would not be against the rules since this is a pretty advanced technique that would be hard to explain to someone.


eh, I got a different feeling from the post but maybe that is just me :/
Was This Post Helpful? 0
  • +
  • -

#5 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8346
  • View blog
  • Posts: 31,904
  • Joined: 06-March 08

Re: How i convert excel file into csv file using java code

Posted 02 September 2009 - 04:38 PM

JExcelapi will allow you to read the .xls
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1