Click here to Skip to main content
16,013,642 members

Comments by TheAbominable (Top 17 by date)

TheAbominable 23-Nov-16 12:17pm View    
Thank you for the explanation!
I will try both approaches and see which one works best. The approaches I will follow are:

1) Save the file on the server (I imagine there is a way to delete the file at the end of the code AFTER having it read)

2) Use a library which lets me read the file directly from the InputStream.

I will update you with my progress.

Thank you!
TheAbominable 23-Nov-16 11:22am View    
Thank you, Richard.
I added even more code. As previously mentioned, when uploading any file from the user interface to the server, my code is able to save the file on a Sharepoint 2010 Library ["ExcelLib"] and the file saves successfully. However, when reading the same file that has been uploaded (for the purpose of parsing it and storing its data on a Sharepoint List), the code fails. Does it fail because I have not saved the file within the windows server? Is there any way to read the file directly from where it has been saved, the Sharepoint Library, instead?

Thank you.
TheAbominable 22-Nov-16 17:33pm View    
Thank you, Richard. I have updated my question and you will notice that I included code related to the upload process. I have also tried (code not included on my question) uploading the file itself to the Sharepoint 2010 library and it works flawlessly, however, when it comes to running the section of the code that reads/parses the file, I do receive an error in the connection.open() line. So, the file uploaded to the Sharepiont library without issues, but when it comes to parsing it (in order to move its data to a Sharepoint List), it has issues.

Like I said, I have also made it simpler and saved the excel file locally on the server (the file is on myuser\Desktop), use exactly the same logic you see above, and the file is read thoroughly, parsed, and its data is moved to the Sharepiont 2010 List flawlessly. Any idea as to what may be the issue? I also tried uploading the file and use the SaveAs("C:\" + fileName), but this did not work.
TheAbominable 16-Nov-16 10:00am View    
Thank you. Yes, I've read/heard something along those lines. How would I go about rebinding the the datapickers in the printDiv method? I've updated my question and you'll see what I added inside the printDiv function, but still it does not work.
TheAbominable 15-Nov-16 12:50pm View    
I do not want to recover a state. What I would like is for the datepicker to continue working. We click on the textbox and the calendar pops up and you choose a date. You print whatever comes out after clicking the submit button and the page remains as it was, however, you click back on the textbox and the calendar does not pop up... no state is being saved.