gdata.io.handleScriptLoaded({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$georss":"http://www.georss.org/georss","xmlns$thr":"http://purl.org/syndication/thread/1.0","xmlns$blogger":"http://schemas.google.com/blogger/2008","id":{"$t":"tag:blogger.com,1999:blog-3826368468004556615"},"updated":{"$t":"2023-12-26T13:46:15.660-08:00"},"category":[{"term":"scp"},{"term":"SAP ABAP"},{"term":"Tutorial series on SAP Enterpise Portal"},{"term":"geocoder"},{"term":"export sapui5 project"},{"term":"events in classical reports"},{"term":"util"},{"term":"layout"},{"term":"pull"},{"term":"joins"},{"term":"tables"},{"term":"SEGW"},{"term":"viz charts"},{"term":"sap cloud platform mobile services"},{"term":"types of views"},{"term":"Security Considerations"},{"term":"sap web ide deprecated"},{"term":"pool"},{"term":"SAP ABAP function modules"},{"term":"tree table"},{"term":"cloud foundry"},{"term":"custom login page"},{"term":"sap cloud platform for portal sites"},{"term":"admin cockpit sap cloud mobile services"},{"term":"Introduction to SAP portal sites"},{"term":"srv"},{"term":"hcp"},{"term":"OOPs Concepts"},{"term":"sap fiori tools"},{"term":"SAP ABAP Blog."},{"term":"export sap projects"},{"term":"ui5"},{"term":"maintainability"},{"term":"associations"},{"term":"combo box"},{"term":"SAP BAS"},{"term":"Logon Page in Enterprise Portal"},{"term":"margins"},{"term":"Web IDE"},{"term":"mtar"},{"term":"CAP"},{"term":"ABAP Development"},{"term":"sap viz frame"},{"term":"sort"},{"term":"Plugin"},{"term":"appearance"},{"term":"workflow"},{"term":"Agile Development"},{"term":"architecture of sap fiori"},{"term":"outer join"},{"term":"SAP S/4HANA"},{"term":"sap fiori"},{"term":"Data Storage"},{"term":"file"},{"term":"SAP overview"},{"term":"function"},{"term":"Sapui5 jobs"},{"term":"Classical report"},{"term":"sap fiori tutorial"},{"term":"webIDE application"},{"term":"Installation of sap ui5 plugin"},{"term":"app router"},{"term":"Scalable Applications"},{"term":"smarttable"},{"term":"odata tutorial"},{"term":"sap enterprise portal"},{"term":"vizframe control"},{"term":"stage"},{"term":"events"},{"term":"selected index"},{"term":"tab"},{"term":"How to export SAP Web IDE Workspace projects"},{"term":"hello world application"},{"term":"SAPUI5 data communication"},{"term":"online training abap"},{"term":"SAP NetWeaver Portal"},{"term":"apps"},{"term":"pfcg"},{"term":"sap mobility jobs"},{"term":"commit"},{"term":"launchpad"},{"term":"DPC"},{"term":"Pass by value and return"},{"term":"routing in split app"},{"term":"Module Pool"},{"term":"sapui5 xml editor"},{"term":"sap.m.list"},{"term":"searching"},{"term":"tag"},{"term":"CAPM Apps"},{"term":"css folder"},{"term":"get expanded entity"},{"term":"ABAP Job Preparation"},{"term":"mta"},{"term":"custom image"},{"term":"xlsx"},{"term":"Mock data"},{"term":"multi target application"},{"term":"javascript"},{"term":"Routing"},{"term":"responsive table in sapui5"},{"term":"add and delete operation"},{"term":"csv upload validation"},{"term":"saml"},{"term":"external library"},{"term":"ALV programming examples"},{"term":"sap btp"},{"term":"Custom Controls"},{"term":"Project structure"},{"term":"openui5"},{"term":"dv"},{"term":"create destinations to connect mobile services from sap web ide"},{"term":"sap custom portal sites"},{"term":"modules"},{"term":"Interactive Reports"},{"term":"user experience sap"},{"term":"odata v2"},{"term":"ABAP New Features"},{"term":"Developer Tips"},{"term":"sap fiori launchpad configuration"},{"term":"Logon to SAP ABAP"},{"term":"cloud foundary"},{"term":"SAP ABAP Certification"},{"term":"Tutorials"},{"term":"ABAP Interview Questions"},{"term":"controller"},{"term":"Routing in sapui5"},{"term":"Environment variables"},{"term":"ALV reports"},{"term":"Transport Request Number"},{"term":"sap fiori enterprise portal"},{"term":"CSN"},{"term":"Parts"},{"term":"jwt token"},{"term":"register cloud platform"},{"term":"annotations"},{"term":"Navigation Properties"},{"term":"component.js"},{"term":"deman pop-in"},{"term":"configure catalogs and groups"},{"term":"Best practices"},{"term":"local service"},{"term":"sap web ide"},{"term":"i18n"},{"term":"Dialog sapui5"},{"term":"chrome"},{"term":"ABAP Coding Best Practices"},{"term":"HANA Modeling"},{"term":"charts in sapui5"},{"term":"sap fiori enterprise portal sites"},{"term":"google maps"},{"term":"SAP Business Technology Platform"},{"term":"formatters"},{"term":"resource bundle"},{"term":"Pass by reference"},{"term":"pass multiple values"},{"term":"projection views"},{"term":"sapui5 diagnostics window"},{"term":"web dynpro"},{"term":"webapp"},{"term":"get expanded entityset"},{"term":"Setting Up an App Router in SAP CAPM Project on BTP: A Step-by-Step Guide"},{"term":"help views"},{"term":"BDC"},{"term":"contrller"},{"term":"video tutorial on nested views and fragments"},{"term":"iwfnd"},{"term":"odata"},{"term":"debugging javascript files"},{"term":"smart table"},{"term":"SAP Programming"},{"term":"SAP Development"},{"term":"SAP netweaver gateway"},{"term":"api"},{"term":"Blobs in JavaScript"},{"term":"sap fiori apps"},{"term":"Visual studio code"},{"term":"How to Change logon Page of Enterprise Portal"},{"term":"dynamic"},{"term":"sapui5 code editor"},{"term":"git"},{"term":"xml code editor"},{"term":"Transaction code"},{"term":"parameter"},{"term":"ABAP on HANA interview questions and answers"},{"term":"Global sub routines"},{"term":"interactive reports example"},{"term":"layouts"},{"term":"ABAP List Viewer"},{"term":"JDK"},{"term":"filter"},{"term":"Fragment in sapui5"},{"term":"controller.js"},{"term":"video tutorial on globalization"},{"term":"CLASSICAL REPORTS"},{"term":"Sorting"},{"term":"odata v4"},{"term":"CRUD operations"},{"term":"create OData service"},{"term":"crud"},{"term":"Navigation"},{"term":"authorization"},{"term":"responsive"},{"term":"SAP functional modules"},{"term":"validate using headers"},{"term":"CDL"},{"term":"SUB ROUTINES"},{"term":"interactive reports events"},{"term":"sheet.js"},{"term":"MDK introduction"},{"term":"SAP Bussiness Application Studio"},{"term":"begin set"},{"term":"UI5 Inspector"},{"term":"get cursor"},{"term":"drag and drop"},{"term":"component preload"},{"term":"ABAP"},{"term":"spider chart"},{"term":"interview tips"},{"term":"view"},{"term":"Sap RAP"},{"term":"Answers"},{"term":"Templates and Accelerators in SAP Portal sites"},{"term":"work Area"},{"term":"SAP ABAP on HANA"},{"term":"sap webide"},{"term":"read"},{"term":"ABAP HANA Integration"},{"term":"sap MDK"},{"term":"ABAP 7.5"},{"term":"submitbatch"},{"term":"version"},{"term":"transparent"},{"term":"Microservices in SAP BTP"},{"term":"resources"},{"term":"import"},{"term":"SAP Data Presentation"},{"term":"create"},{"term":"SAP ECC"},{"term":"debug files in production environment"},{"term":"sap fiori configuration cockpit portal sites"},{"term":"SAP cloud solutions"},{"term":"speech recognition"},{"term":"groups"},{"term":"icf"},{"term":"ABAP 7.6"},{"term":"custom control"},{"term":"configuring destination in sap web ide"},{"term":"viz control"},{"term":"Mta yaml"},{"term":"odata deep structures"},{"term":"BAS"},{"term":"push"},{"term":"ios"},{"term":"data element"},{"term":"search"},{"term":"ALV Grid Report"},{"term":"Internal Tables"},{"term":"properties"},{"term":"minScreenWidth"},{"term":"configuring tiles"},{"term":"aggregation binding"},{"term":"grouping"},{"term":"controller hooks"},{"term":"portal site"},{"term":"import project"},{"term":"ABAP Developer Tips"},{"term":"json model"},{"term":"Introduction"},{"term":"branding"},{"term":"list"},{"term":"SAP Technical Interviews"},{"term":"android"},{"term":"package"},{"term":"SAP Fiori Configuration cockpit"},{"term":"create cloud foundary account"},{"term":"sap app"},{"term":"custom sapui5 app extension"},{"term":"edit"},{"term":"SAP ABAP views"},{"term":"excel"},{"term":"ABAP Code Examples"},{"term":"SmartForms"},{"term":"logo"},{"term":"sap freestyle portal sites"},{"term":"HANA Development"},{"term":"fiori apps"},{"term":"Image Upload"},{"term":"javascript code editor"},{"term":"OData v4 advantages"},{"term":"Development"},{"term":"index of list"},{"term":"offline capabilities"},{"term":"containers"},{"term":"portal"},{"term":"changeset"},{"term":"Binary Data Handling"},{"term":"distance"},{"term":"sap cloud foundary"},{"term":"technical interview questions"},{"term":"Cloud Application Programming Model"},{"term":"implementing SAP Fiori"},{"term":"odat v4"},{"term":"MockSever"},{"term":"Event Handling"},{"term":"local development"},{"term":"RAP Implementation"},{"term":"sap ui5 excel upload"},{"term":"Data types"},{"term":"How to get Selected table index value?"},{"term":"xml view"},{"term":"hierarchial ALV"},{"term":"extending apps"},{"term":"sap capm"},{"term":"manifest.json"},{"term":"DDIC"},{"term":"ABAP Data Modeling"},{"term":"reports"},{"term":"User Interaction"},{"term":"batch processing in OData"},{"term":"login"},{"term":"sap backend system"},{"term":"event"},{"term":"authentication"},{"term":"css"},{"term":"job search"},{"term":"types of subroutines"},{"term":"LOCAL SUB ROUTINES"},{"term":"mobile development kit"},{"term":"item"},{"term":"sap fiori portal site"},{"term":"enable sap web ide"},{"term":"use strict"},{"term":"json"},{"term":"routing in full application"},{"term":"Introduction to sap enterprise portal"},{"term":"doalog"},{"term":"CDS"},{"term":"chart.js"},{"term":"Mdk app"},{"term":"ALE"},{"term":"mfa"},{"term":"view extensions"},{"term":"sap abap tutorials"},{"term":"system objects"},{"term":"maint_service"},{"term":"introduction to sapui5"},{"term":"Dev Tools"},{"term":"Configure Catalog and Groups in SAP Fiori Portal Sites"},{"term":"design principles"},{"term":"component configuration"},{"term":"ABAP Job Interview Insights"},{"term":"rest"},{"term":"sap fiori launchpad"},{"term":"google maps api"},{"term":"MPC"},{"term":"inline expressions"},{"term":"data binding"},{"term":"table"},{"term":"cache buster"},{"term":"setup"},{"term":"tiles"},{"term":"HANA Performance Tuning."},{"term":"Pass by value (or) call by value"},{"term":"beginset"},{"term":"path"},{"term":"XS-UAA"},{"term":"model folder"},{"term":"sapui5"},{"term":"view replacement"},{"term":"introduction to ERP"},{"term":"example classical report example"},{"term":"SAP MTA"},{"term":"external style"},{"term":"Internal Table"},{"term":"step by step process to create odata"},{"term":"update"},{"term":"add"},{"term":"walkthrough admin cockpit"},{"term":"fiori"},{"term":"python"},{"term":"hello world"},{"term":"sapui5 code validator"},{"term":"responsiveness"},{"term":"node.js"},{"term":"Search Help in DDIC"},{"term":"backend components"},{"term":"custom fiori app"},{"term":"xs security"},{"term":"introduction to sap web ide"},{"term":"SAP CAP"},{"term":"SAP technical modules"},{"term":"inner join"},{"term":"string"},{"term":"internal style"},{"term":"lpd_cust"},{"term":"radar chart"},{"term":"csv"},{"term":"OData v2 vs. OData v4"},{"term":"validation"},{"term":"nested view"},{"term":"push a project in github"},{"term":"aggregations"},{"term":"charts"},{"term":"SAP Fiori Launchpad Portal Site"},{"term":"sapui5 project"},{"term":"introduction to odata annotations"},{"term":"export project"},{"term":"types of tables"},{"term":"operations on internal table"},{"term":"large string"},{"term":"Activate OData Service in SICF"},{"term":"sapui5 lint"},{"term":"Most common examples in sap ui5"},{"term":"video tutorial on formatter and inline expressions"},{"term":"pdf"},{"term":"fiori launchpad"},{"term":"extending sapui5 apps"},{"term":"sap mobile services"},{"term":"sap mobile services tutorial"},{"term":"sap portal site"},{"term":"Fragment"},{"term":"Configuring Fiori Tiles in sap portal sites"},{"term":"mdk"},{"term":"annotations in OData"},{"term":"sap mobile development kit"},{"term":"metadata.xml"},{"term":"SAP Mobile cards"},{"term":"SAP ABAP video tutorials"},{"term":"btp"},{"term":"setup sap bussiness application studio"},{"term":"ABAP Innovations"},{"term":"Introduction and DDIC"},{"term":"introduction to sap fiori"},{"term":"optimization"},{"term":"examples"},{"term":"- SAP ABAP performance optimization\n\n- ABAP performance tuning\n\n- SAP ABAP best practices\n\n- SAP ABAP performance tips\n\n- ABAP performance optimization techniques\n\n- SAP ABAP performance improvements"},{"term":"sap"},{"term":"SAP Tech Trends"},{"term":"sapui5 csv file upload import"},{"term":"sap.m.table"},{"term":"frontend components"},{"term":"Field Catalog"},{"term":"File Manipulation"},{"term":"SAP RAP Tutorial"},{"term":"js"},{"term":"mobile services in cloud foundary"},{"term":"sicf"},{"term":"roles"},{"term":"file reader"},{"term":"maintainence view"},{"term":"Security"},{"term":"SAP implementation."},{"term":"domain"},{"term":"sap cloud platform SDK"},{"term":"Globalization and localization"},{"term":"xml"},{"term":"marker"},{"term":"SAP Interview Prep"},{"term":"sap web IDE Workspace export"},{"term":"re usability"},{"term":"sapui5 nested view"},{"term":"voice recognition"},{"term":"sap fiori application"},{"term":"video tutorial on routing"},{"term":"Offline app"},{"term":"index"},{"term":"Latest ABAP FAQs"},{"term":"Naming conventions"},{"term":"fiori tiles"},{"term":"fiori jobs"},{"term":"SAPui5 application on SAP bussiness application studio"},{"term":"database views"},{"term":"upload"},{"term":"sapui5 excel import"},{"term":"Batch"},{"term":"sapui5 project structuring"},{"term":"token"},{"term":"handling localized texts"},{"term":"globalization"},{"term":"SAP HANA clould cockpit"},{"term":"deploy to cloud foundry"},{"term":"test Odata service"},{"term":"github"},{"term":"sap fiori jobs"},{"term":"sap cloud platform"},{"term":"capm"},{"term":"sapui5 github"},{"term":"formatter"},{"term":"cluster"},{"term":"ALV Grid Tutorial"},{"term":"controller extension"},{"term":"fiori app"},{"term":"view extension"},{"term":"Cloud-Native Architecture"},{"term":"HANA"},{"term":"multi cloud environment"},{"term":"interview questions"},{"term":"filtering"},{"term":"ABAP CDS Views"},{"term":"variable names"},{"term":"CQL"},{"term":"gulp"},{"term":"boolean"},{"term":"SAP modules"},{"term":"delete"},{"term":"logon page"},{"term":"introduction to sap abap"},{"term":"sapui5 apps"},{"term":"pull a project"},{"term":"split app"},{"term":"sapui5 best practices"},{"term":"read table"},{"term":"SAP OData"},{"term":"Debugging ABAP"},{"term":"universal worklist"},{"term":"expression"},{"term":"controls and views"},{"term":"Custom control to make a Radar Chart using Chart.js library in SAPUI5."},{"term":"Cache"},{"term":"view modification"},{"term":"odata tutorial series"},{"term":"xls"},{"term":"sap BTP CAPM"},{"term":"append operation"},{"term":"code quality"},{"term":"example of CAP"},{"term":"header item relationship"},{"term":"launchpad configuration"},{"term":"Latest ABAP Updates"},{"term":"sap ui5"},{"term":"dataset"},{"term":"register odata service"},{"term":"padding"},{"term":"RAP"},{"term":"OData v2 benefits"},{"term":"v4"},{"term":"ABAP Enhancements"},{"term":"responsive table"},{"term":"npm"},{"term":"RAP Model"},{"term":"catalogs"},{"term":"sap fiori elements"},{"term":"login configuration"},{"term":"Web Application Development"},{"term":"application"},{"term":"value"},{"term":"enterprise portal"},{"term":"selected"}],"title":{"type":"text","$t":"SAP Development: Mastering SAP UI5, BTP, Fiori, CAPM, RAP, ABAP; and More!"},"subtitle":{"type":"html","$t":"Welcome to the ultimate SAP UI5, BTP, Fiori, CAPM, RAP, ABAP blog! Explore comprehensive tutorials, interview questions, and real-world examples to master SAP development. Elevate your skills in creating stunning UI5 apps, harnessing the power of BTP, and building Fiori applications. Unlock the potential of CAPM, RAP, and ABAP, and learn to integrate seamlessly with the enterprise portal. Whether you're a beginner or an experienced developer, this blog is your go-to resource for SAP expertise!"},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https://www.blogger.com/feeds/3826368468004556615/posts/default/-/sapui5+csv+file+upload+import?alt\u003djson-in-script\u0026max-results\u003d50"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/3826368468004556615/posts/default/-/sapui5+csv+file+upload+import?alt\u003djson-in-script\u0026max-results\u003d50"},{"rel":"alternate","type":"text/html","href":"http://www.sapui5tutors.com/search/label/sapui5%20csv%20file%20upload%20import"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Sanjo Thomas"},"uri":{"$t":"https://www.blogger.com/profile/06687889588258406801"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"generator":{"version":"7.00","uri":"https://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"1"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"50"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-3826368468004556615.post-7824443109469385746"},"published":{"$t":"2022-04-02T06:59:00.004-07:00"},"updated":{"$t":"2022-04-02T07:02:29.103-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"csv"},{"scheme":"http://www.blogger.com/atom/ns#","term":"import"},{"scheme":"http://www.blogger.com/atom/ns#","term":"sapui5 csv file upload import"},{"scheme":"http://www.blogger.com/atom/ns#","term":"upload"},{"scheme":"http://www.blogger.com/atom/ns#","term":"file reader"},{"scheme":"http://www.blogger.com/atom/ns#","term":"HANA"},{"scheme":"http://www.blogger.com/atom/ns#","term":"sapui5"},{"scheme":"http://www.blogger.com/atom/ns#","term":"crud"}],"title":{"type":"text","$t":"How to import Excel CSV file to SAP UI5 Application."},"content":{"type":"html","$t":"\u003cp\u003eIn this blog, we will see how can we import a csv file in SAP UI5 application.\u0026nbsp;\u003c/p\u003e\u003cp\u003eThis would be a bit different from importing excel file just as I explained inthe previous \u003ca href\u003d\"http://www.sapui5tutors.com/2022/04/how-to-import-excel-xlsxxls-file-to-sap.html\" target\u003d\"_blank\"\u003eblog\u003c/a\u003e, since in this technique we wont be rquired to use a third party library.\u003c/p\u003e\u003cp\u003eJust like in my previous blog, lets keep the use case simple. We will have a simple view with a FileUploader to browse a csv file and a table to display the data.\u003c/p\u003e\u003cpre class\u003d\"lang:js decode:true\" style\u003d\"background-color: #f1f1f1; border-radius: 0px; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; break-inside: avoid; color: #666666; font-size: 15px; line-height: 1.6; margin-bottom: 1.6em; margin-top: 24px; max-width: 100%; overflow-wrap: break-word; overflow: auto; padding: 1em 1.5em;\" title\u003d\"FileUpload.view.xml\"\u003e\u0026lt;core:View xmlns:core\u003d\"sap.ui.core\" xmlns:mvc\u003d\"sap.ui.core.mvc\"\n\txmlns\u003d\"sap.m\" xmlns:u\u003d\"sap.ui.unified\" xmlns:l\u003d\"sap.ui.layout.form\"\n\tcontrollerName\u003d\"com.fileuploader.FileUpload\" xmlns:html\u003d\"http://www.w3.org/1999/xhtml\"\u0026gt;\n\t\u0026lt;Page title\u003d\"Demo on CSV File Upload\"\u0026gt;\n\t\u0026lt;content\u0026gt;\n\t\t\u0026lt;l:SimpleForm editable\u003d\"true\"\u0026gt;\n\t\t \u0026lt;l:content\u0026gt;\n\t\t  \u0026lt;Label text\u003d\"File Name\"\u0026gt;\n\t\t  \u0026lt;/Label\u0026gt;\n\t\t\u0026lt;VBox\u0026gt;\n\t\t \u0026lt;u:FileUploader id\u003d\"idfileUploader\" width\u003d\"50%\"\n\t\t    sameFilenameAllowed\u003d\"false\" buttonText\u003d\"\" fileType\u003d\"CSV\"\n\t\t    placeholder\u003d\"Choose a CSV file\" style\u003d\"Emphasized\"\u0026gt;\n\t\t\u0026lt;/u:FileUploader\u0026gt;\n\t\t\u0026lt;Button text\u003d\"Upload\" press\u003d\"onUpload\"\u0026gt;\u0026lt;/Button\u0026gt;\n\t\t\u0026lt;/VBox\u0026gt;\n\t\t\u0026lt;/l:content\u0026gt;\n\t\t\u0026lt;/l:SimpleForm\u0026gt;\n\n\t\t\u0026lt;Table id\u003d\"idTable\" items\u003d\"{/}\"\u0026gt;\n\t\t\u0026lt;items\u0026gt;\n\t\t    \u0026lt;ColumnListItem\u0026gt;\n\t\t\t\u0026lt;cells\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"{VBELN}\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"{ERDAT}\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"{VBTYP}\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"{TRVOG}\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"{AUART}\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/cells\u0026gt;\n\t\t   \u0026lt;/ColumnListItem\u0026gt;\n                \u0026lt;/items\u0026gt;\n\t        \u0026lt;columns\u0026gt;\n\t\t\t\u0026lt;Column\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"Sales Document\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/Column\u0026gt;\n\t\t\t\u0026lt;Column\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"Date\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/Column\u0026gt;\n\t\t\t\u0026lt;Column\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"Type\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/Column\u0026gt;\n\t\t        \u0026lt;Column\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"Sales Org\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/Column\u0026gt;\n\t\t\t\u0026lt;Column\u0026gt;\n\t\t\t\u0026lt;Text text\u003d\"Category\"\u0026gt;\u0026lt;/Text\u0026gt;\n\t\t\t\u0026lt;/Column\u0026gt;\n\t\t\u0026lt;/columns\u0026gt;\n\t\t\u0026lt;/Table\u0026gt;\n\t\t\u0026lt;/content\u0026gt;\n\t\u0026lt;/Page\u0026gt;\n\u0026lt;/core:View\u0026gt;\u003c/pre\u003e\u003cp\u003e\u003c/p\u003e\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\u003ca href\u003d\"https://blogger.googleusercontent.com/img/a/AVvXsEjtu6Sa2hwpbFjftbxuqZcXCyk-AMyS2x6Y5B5oV28O9_9zNLBE3bclwxajSja45ncvZlPqwvOv-OfsnB8k1KAG8huplfsgz9FZ5SGmqS0d6DO1ArCGUq-0tcHiVdWC4phfuA66d7yYCgnPokg_jvGSt6pvhk2FKDQudPgUCOJcMICURF8bsUP22ds\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cimg data-original-height\u003d\"386\" data-original-width\u003d\"1377\" height\u003d\"180\" src\u003d\"https://blogger.googleusercontent.com/img/a/AVvXsEjtu6Sa2hwpbFjftbxuqZcXCyk-AMyS2x6Y5B5oV28O9_9zNLBE3bclwxajSja45ncvZlPqwvOv-OfsnB8k1KAG8huplfsgz9FZ5SGmqS0d6DO1ArCGUq-0tcHiVdWC4phfuA66d7yYCgnPokg_jvGSt6pvhk2FKDQudPgUCOJcMICURF8bsUP22ds\u003dw640-h180\" width\u003d\"640\" /\u003e\u003c/a\u003e\u003c/div\u003e\u003cbr /\u003e\u003cbr /\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003eNow update the code in the onUpload function in the respective controller.\u003c/p\u003e\u003cpre class\u003d\"lang:js decode:true\" style\u003d\"background-color: #f1f1f1; border-radius: 0px; border: 1px solid rgb(221, 221, 221); box-sizing: border-box; break-inside: avoid; color: #666666; font-size: 15px; line-height: 1.6; margin-bottom: 1.6em; margin-top: 24px; max-width: 100%; overflow-wrap: break-word; overflow: auto; padding: 1em 1.5em;\"\u003eonUpload : function(e) {\n\t\n\tvar fU \u003d this.getView().byId(\"idfileUploader\");\n\tvar domRef \u003d fU.getFocusDomRef();\n\tvar file \u003d domRef.files[0];\n\t\n\t\n\t// Create a File Reader object\n\tvar reader \u003d new FileReader();\n\tvar t \u003d this;\n\t\n\treader.onload \u003d function(e) {\n\t    var strCSV \u003d e.target.result;\n\t    var arrCSV \u003d strCSV.match(/[\\w .]+(?\u003d,?)/g);\n\t    var noOfCols \u003d 5;\n\n\t    // To ignore the first row which is header\n\t    var hdrRow \u003d arrCSV.splice(0, noOfCols);\n\n\t    var data \u003d [];\n\t    while (arrCSV.length \u0026gt; 0) {\n\t\tvar obj \u003d {};\n\t\t// extract remaining rows one by one\n\t\tvar row \u003d arrCSV.splice(0, noOfCols)\n\t\tfor (var i \u003d 0; i \u0026lt; row.length; i++) {\n\t\t    obj[hdrRow[i]] \u003d row[i].trim()\n\t\t}\n\t\t// push row to an array\n\t\tdata.push(obj)\n\t    }\n\t    \n\t    // Bind the data to the Table\n\t    var oModel \u003d new sap.ui.model.json.JSONModel();\n\t    oModel.setData(data);\n\t    var oTable \u003d t.byId(\"idTable\");\n\t    oTable.setModel(oModel);\n\t};\n\treader.readAsBinaryString(file);\n    }\u003c/pre\u003e\u003cp\u003eThe above code in onUpload function will read the data in CSV file and load it to json model and bind it to the table.\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\u003ca href\u003d\"https://blogger.googleusercontent.com/img/a/AVvXsEjUJUU_Ool7D2VHyvPinqemDXoZ0JoCEOVuWKBX1s_9BX8UM7-3vBI83-7EvExtVOfA9enLDgtcGT9hS6yZFrC_21NY3AZU04JwfRCkIJnTnHAh4qR4RXAGHZ2ltFCgYdbjpsr5EtB-pdKusBCgVBXcTvGfAs3OV3sI7qkPF2m7JwxUhcrh13-LihE\" style\u003d\"margin-left: 1em; margin-right: 1em;\"\u003e\u003cimg data-original-height\u003d\"404\" data-original-width\u003d\"1371\" height\u003d\"188\" src\u003d\"https://blogger.googleusercontent.com/img/a/AVvXsEjUJUU_Ool7D2VHyvPinqemDXoZ0JoCEOVuWKBX1s_9BX8UM7-3vBI83-7EvExtVOfA9enLDgtcGT9hS6yZFrC_21NY3AZU04JwfRCkIJnTnHAh4qR4RXAGHZ2ltFCgYdbjpsr5EtB-pdKusBCgVBXcTvGfAs3OV3sI7qkPF2m7JwxUhcrh13-LihE\u003dw640-h188\" width\u003d\"640\" /\u003e\u003c/a\u003e\u003c/div\u003e\u003cbr /\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003eHereby, we have successfully uploaded the CSV to UI5 application and shown it on the table. Now, as per requirement user can select a particular record and perform CRUD operations.\u003c/p\u003e\u003cp\u003eThis way we have seen both ways of importing Excel and CSV files to UI5 application. We can also add some additional validations on excel imported files by simply comparing the desired template with the imported file template. This we can see in the next blog.\u003c/p\u003e"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.sapui5tutors.com/feeds/7824443109469385746/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.sapui5tutors.com/2022/04/how-to-import-excel-csv-file-to-sap-ui5.html#comment-form","title":"1 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/3826368468004556615/posts/default/7824443109469385746"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/3826368468004556615/posts/default/7824443109469385746"},{"rel":"alternate","type":"text/html","href":"https://www.sapui5tutors.com/2022/04/how-to-import-excel-csv-file-to-sap-ui5.html","title":"How to import Excel CSV file to SAP UI5 Application."}],"author":[{"name":{"$t":"Sanjo Thomas"},"uri":{"$t":"https://www.blogger.com/profile/06687889588258406801"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https://blogger.googleusercontent.com/img/a/AVvXsEjtu6Sa2hwpbFjftbxuqZcXCyk-AMyS2x6Y5B5oV28O9_9zNLBE3bclwxajSja45ncvZlPqwvOv-OfsnB8k1KAG8huplfsgz9FZ5SGmqS0d6DO1ArCGUq-0tcHiVdWC4phfuA66d7yYCgnPokg_jvGSt6pvhk2FKDQudPgUCOJcMICURF8bsUP22ds\u003ds72-w640-c-h180","height":"72","width":"72"},"thr$total":{"$t":"1"}}]}});