Search
18880 results 551-560
Forum
- 10th Nov 2020Excel Export create multiple sheetsUPDATE for people who have to export big tables (where the number of columns are bigger than 24) You have to change : mergeCol = ((header.length - 1) + 10).toString(36).toUpperCase(); mergeCells = ''+'' + ''; in the function getTableData(table, title) Because it doesnt manage the column looking like : 'AA1' (instead the value is something like '1A1', Excel doesn"t know how to interpret it so you have a message like : "We found a problem with some content in "filename.xlsx" Do you want us to try to recover as much as we can?" at the opening so remplace the line by something like that : mergeCol = "B1"; mergeCells = ''+'' + '';
- 1st Nov 2020Ability to create an overlay over entire table while ajax processing is in progress.Looks like you can define the element that [Busy Load)(https://piccard21.github.io/busy-load/) applies to. You can use the preXHR event to show the loader and xhr to hide it. You can apply it to any element list the table tag. Or if you want to overlay the Datatable elements like search and paging you can apply it to the wrapper div which has the id of example_wrapper where example is the id of your table. See this example: http://live.datatables.net/lufuraji/1/edit Kevin
- 29th Oct 2020How can I create a condition in the ajax or controllerand I need that if it comes true it will be shown and if it comes false it will not. What would you expect to be shown in that column of the table if it is false? It would be worth looking at columns.render as that might get you moving in the right direction, Colin
- 25th Oct 2020How to create dynamic columns and trouble fixedColumnsIf you want to be able to define the columns by the Ajax loaded data, you need to get the column information first and then load the DataTable. This FAQ covers that. Allan
- 20th Oct 2020Does anyone know how to create columns dynamically and include a render function in the array?Solved :hushed:
- 21st Sep 2020Modal keeps loading after create, edit or delete bootstrap 4Duplicate of this thread - please don't repeat posts. Colin
- 21st Aug 2020Button or New to search json object to create new rows into tableDaft question perhaps, but would this not be a good use case for a select list? I'm afraid we don't have any examples of what you are looking for specifically. Do you have the list of AD users up front, or are you needing to Ajax loading them? I did start work on a DataTables plug-in for Editor a while back, but it isn't yet complete (layout was difficult, so that is part of DT2). Allan
- 27th Jul 2020How to Create DataTable's Pagination Link Custom designs and change it's Default Place in DOM.Thanks For Help, Instead I created Custom paging and it is creating other issues, can you please look at that ? https://datatables.net/forums/discussion/63394/datatables-serverside-processing-not-working-with-custom-paging-in-asp-net-core/p1?new=1
- 11th Jul 2020Create separate js file and call in separate htmlYou just add a script include statement like you have for the other .js files: <head> <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs4-4.1.1/jq-3.3.1/jszip-2.5.0/dt-1.10.21/af-2.3.5/b-1.6.2/b-colvis-1.6.2/b-flash-1.6.2/b-html5-1.6.2/b-print-1.6.2/cr-1.5.2/fc-3.3.1/fh-3.1.7/kt-2.5.2/r-2.2.5/rg-1.1.2/rr-1.2.7/sc-2.0.2/sp-1.1.1/sl-1.3.1/datatables.min.css"/> <script type="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/v/bs4-4.1.1/jq-3.3.1/jszip-2.5.0/dt-1.10.21/af-2.3.5/b-1.6.2/b-colvis-1.6.2/b-flash-1.6.2/b-html5-1.6.2/b-print-1.6.2/cr-1.5.2/fc-3.3.1/fh-3.1.7/kt-2.5.2/r-2.2.5/rg-1.1.2/rr-1.2.7/sc-2.0.2/sp-1.1.1/sl-1.3.1/datatables.min.js"></script> <script type="text/javascript" src="https://code.highcharts.com/highcharts.js"></script> <script type="text/javascript" src="https://code.highcharts.com/modules/exporting.js"></script> <script type="text/javascript" src="/js/myscript.js"></script> <meta charset=utf-8 /> <title>DataTables - JS Bin</title> </head> are there similar things to import declarations I need in the external js file? You are already loading the dependent files in the head of your page. Kevin
- 24th Jun 2020How to create nested tables from multidimensional json resultdataBasically the answer is yes you can do either. Here is a simple example of how to show the data in one table: http://live.datatables.net/kucujotu/1/edit It uses columns.render to render the array of sites objects into the column. Assuming that is what you want to do. Using Javascript map to iterate the specific sites object. You can use any Javascript methods in the function to achieve the output you want. It accesses the data using data.results. If you are using the ajax option then you will use the ajax.dataSrc option to point to results You will want to look at the Nested Objects Example. Please post any questions. Kevin