Error: while reading excel file created(exported) from WD through JXL API

[Former Member]

Hi,

I have created (exported using JXL API) an excel file by sending data from my Webdynpro application

The created Excel File is correct.

Through my Webdynpro application I can save this excel file to any local location in my PC.

I want to upload(import to another WD application) the same Excel file, specified above.

<b>I can do this only after,

I open the exported file (saved in local location) and save it once gain.(just click on the save button in the excel editor.)</b>

Otherwise I am unable to read the sheets of this file.

I should be able to read the same excel file exported from WD, without saving it once again.

It would be appreciable , if anybody helps.

Thanks and regards

Smitha

[Former Member · Accepted solution]

Hi,

I think this is some thing to do with the Mime types of the file.

Regards

Ayyapparaj

[Former Member · Accepted solution]

Hi

I have checked the MIME type.

It is "application/vnd.ms-excel" while exporting and importing.

Can you help me.

thanks

Smitha

[Former Member]

Hi ,

im venkata reddy im new to SDN

here is my suggestion

Using Fileinputstream and file outputstream u can read the file and write to Remote Ends I mean u can serialize the file to any PC

if any doubts plz ask

thanks,

venkat

[Former Member]

Try This ,

java script :

-

---

<FORM ENCTYPE='multipart/form-data'

method='POST' action='/myservlet'>

<INPUT TYPE='file' NAME='mptest'>

<INPUT TYPE='submit' VALUE='upload'>

</FORM>

java code :

________

if(submitButton.equals(multi.getParameter("Submit")))

{

out.println("Files:");

Enumeration files = multi.getFileNames();

while (files.hasMoreElements()) {

String name = (String)files.nextElement();

String filename = multi.getFilesystemName(name);

String type = multi.getContentType(name);

File f = multi.getFile(name);

FileReader fs = new FileReader(f);

BufferedReader in = new BufferedReader(fs);

String s, s2 = new String();

while((s = in.readLine())!= null) {

s2 += s + "\n";

}

thanks & Regards ,

venkat