Thanks a lot Sanjiv. But will you please tell me how to write this in Java?Will it need some jar or what?
Regards, Veena -----Original Message----- From: Sanjiv Jivan [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 1:00 PM To: POI Users List Subject: Re: Reading Excel 3.0 format file The following VBA code should do it.. Workbooks.Open Filename:="C:\<path to Excel 3 file>" ActiveWorkbook.SaveAs Filename:= _ "C:\convert\excel-97.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Hope this helps, Sanjiv On Apr 2, 2005 2:21 AM, Veena Sarolkar <[EMAIL PROTECTED]> wrote: > > Hi All, > > I am very new to this forum. But I read the documentaion & came to know that > we can use HSSF to read & write Excel files. > But it only supports reading Excel file format of Excel 97. > Is there any way to read Excel 3.0 file. I have Excel 3.0 file & as I am > getting it from one URL i cannot use save as to save it in different format. > Or is there any way to convert this file to Excel 97 programmatically? > Please help me. This is very urgent. > > Regards, > Veena > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
