Home Importing into grid from the Excel
Reply: 0

Importing into grid from the Excel

user1290 Published in June 19, 2018, 2:44 pm

I am currently having a ui-grid in Angular JS with sorting and editing functionality and the code is like below

   $scope.samplesGridOptions = {
    enableColumnResizing: true,
    enableRowSelection: true,
    multiSelect: false,
    enableGridMenu: true,
    enableCellEditOnFocus: true,
    columnDefs: [
        { field: 'externalID', displayName: 'External ID' },
        { field: 'apexLotNum', displayName: 'APEX Lot' },
            field: 'chamberName',
            displayName: 'Chamber Name',
            editType: 'dropdown',
            editableCellTemplate: 'ui-grid/dropdownEditor',
            enableCellEdit: true, editDropdownOptionsArray: $scope.chamberNameList,
            editDropdownIdLabel: 'value',
            editDropdownValueLabel: 'value'
    gridMenuCustomItems: [],
    onRegisterApi: function (gridApi) {
        $scope.samplesGridAPI = gridApi;
        $scope.samplesGridOptions.data = $scope.virtualSampleList;

I can manually add and remove things in to grid but I am not sure if there is a way if I can upload from the excel to populate the grid. I am new to the JS libraries and not sure if there is any easy way to upload the excel file in to the ui-grid

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.459568 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO