In my Exporting table data to MS-Excel Sheet(enhanced Web Dynpro Binary Cache), we have seen how to pass data to an Excel File using MS-Excel formatting. There was another Web Dynpro Java a couple of weeks ago. This time, it was how to read data from an MS-Excel file.
The setup is exactly the same as shown Exporting table data to MS-Excel Sheet(enhanced Web Dynpro Binary Cache)
To just demonstrate how this works , we need the following things:
- File Upload UI Element
- Upload Excel File Button UI Element – onAction -> Upload
- FileName – bound to File Upload UI Element property – fileName
- FileResource – bound to File Upload UI Element property – data