[smitakardak]

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 .

[syfran]

[rules][/rules]

[NickDMax]

@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.

[syfran]

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

[pbl]

JExcelapi will allow you to read the .xls