i wanna make a template to get some data from excel or anything and paste in to my template to insert data

And here you are: [image] You need only one callback function I included in a separate function note for better readability (do not wire this into your flow). The change node does the preparation of the table with a msg.ui_control object. Because you need minimum one cell to paste into (you can`t paste into an empty table) I put in some dummy data It is not necessary to configure the the table node only tick "send data on click" to activate the output. [copy-paste] And in Node-RED: [image] Here is the fow: [{"id":"4512106a.2f145","type":"change","z":"4ddb981f.f34df8","name":"ui_control & placeholder","rules":[{"t":"set","p":"ui_control","pt":"msg","to":"{\"customHeight\":20,\"tabulator\":{\"layout\":\"fitColumns\",\"clipboard\":true,\"clipboardCopySelector\":\"table\",\"clipboardCopyStyled\":false,\"clipboardPasteAction\":\"function(rowData){ this.send({ui_control:{callback:'clipboardPasteAction'},payload:rowData}); return this.table.replaceData(rowData); }\",\"columns\":[{\"field\":\"col1\",\"title\":\"Column #1\"},{\"field\":\"col2\",\"title\":\"Column #2\"},{\"field\":\"col3\",\"title\":\"Column #3\"}]}}","tot":"json"},{"t":"set","p":"payload","pt":"msg","to":"[{\"col1\":\"click here & CTRL+v\",\"col2\":\"or click here & CTRL+v\",\"col3\":\"or click here & CTRL+v\"},{\"col1\":\" or on any other cell\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"there is a issue with small or empty tables\",\"col2\":\"will be dixed soon\",\"col3\":\"\"},{\"col1\":\"Untill then we have\",\"col2\":\"to fill in some\",\"col3\":\"dummy lines\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":399,"y":255,"wires":[["71d16773.2b0a38"]]},{"id":"8d8d7ea4.2fe3f","type":"debug","z":"4ddb981f.f34df8","name":"clipboardPasteAction","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":1018,"y":238,"wires":[]},{"id":"71d16773.2b0a38","type":"ui_table","z":"4ddb981f.f34df8","group":"113a4af6.0aab85","name":"Copy & Paste","order":1,"width":"17","height":"7","columns":[],"outputs":1,"cts":true,"x":641,"y":255,"wires":[["d9789454.020d58"]]},{"id":"a0dee6b9.6423c8","type":"function","z":"4ddb981f.f34df8","name":"clipboardPasteAction Callback","func":"// callback: clipboardPasteAction\n// DO NOT USE IN A FLOW!\n\nclipboardPasteAction = \n// copy from here\nfunction(rowData){\n this.send({ui_control:{callback:'clipboardPasteAction'},payload:rowData});\n return this.table.replaceData(rowData);\n}\n// until here\n// use the Visual Editor!\n// paste into ui_table JSON \"clipboardPasteAction\":\"function(....\"\n\n// technical details\n//\n// the example function ends with\n//\n// return this.table.updateData(rows);\n// \n// but that's not updating the data (because it does try to update data through\n// the index field (default \"id\")\n// replaceData simply erase all existing rowData and fills in the pasted data\n// that's what we want","outputs":1,"noerr":0,"x":419,"y":204,"wires":[[]]},{"id":"38c0e825.798328","type":"ui_ui_control","z":"4ddb981f.f34df8","name":"on tab change","events":"change","x":182,"y":255,"wires":[["4512106a.2f145"]]},{"id":"d9789454.020d58","type":"switch","z":"4ddb981f.f34df8","name":"","property":"ui_control.callback","propertyType":"msg","rules":[{"t":"eq","v":"clipboardPasteAction","vt":"str"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":815,"y":255,"wires":[["8d8d7ea4.2fe3f"],["7b094d08.4d1224"]]},{"id":"7b094d08.4d1224","type":"debug","z":"4ddb981f.f34df8","name":"something else","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":998,"y":272,"wires":[]},{"id":"113a4af6.0aab85","type":"ui_group","z":"","name":"ui-table Copy & Paste","tab":"a1c14418.954cd8","disp":true,"width":"17","collapse":false},{"id":"a1c14418.954cd8","type":"ui_tab","z":"","name":"ui-table test","icon":"dashboard","disabled":false,"hidden":false}] CTRL-c is working too. It is set to "table" (including currently invisble cells) and no styling. Detailed documentation of this tabulator feature can be found here. Be aware that colum field names must match cells of the first row of the pasted data and the clipboard is tab \t and new line \n formatted, as windows clipboard does. http://tabulator.info/docs/4.5/clipboard#paste-parser There could be still a little issue in the vertical size of the table. So this is why the table is initialized with blank or dummy rows. Will be solved shortly

How do you see that working, and what have you tried so far?

@Paul-Reed sorry. [{"id":"af709301.03b","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"5f42e8d3.f4cfa8","type":"template","z":"af709301.03b","name":"html","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":" \n \n {{{payload.style}}}\n \n \n\n\n \n \n Name \n IP \n \n {{#payload}}\n \n {{{name}}} \n {{ip}} \n \n {{/payload}}\n ","x":670,"y":140,"wires":[["250d0ef.c7407f2"]]},{"id":"250d0ef.c7407f2","type":"http response","z":"af709301.03b","name":"","x":810,"y":140,"wires":[]},{"id":"7b12a04c.865b5","type":"template","z":"af709301.03b","name":"css","field":"payload.style","fieldType":"msg","format":"html","syntax":"mustache","template":"table {\n color: #333;\n font-family: Helvetica, Arial, sans-serif;\n width: 100%;\n border-collapse: collapse;\n border-spacing: 0;\n}\ntd, th {\n border: 1px solid transparent;\n /* No more visible border */\n height: 30px;\n transition: all 0.3s;\n /* Simple transition for hover effect */\n}\nth {\n background: #DFDFDF;\n /* Darken header a bit */\n font-weight: bold;\n}\ntd {\n background: #FAFAFA;\n text-align: center;\n}\n\n/* Cells in even rows (2,4,6...) are one color */\n\ntr:nth-child(even) td {\n background: #F1F1F1;\n}\n\n/* Cells in odd rows (1,3,5...) are another (excludes header cells) */\n\ntr:nth-child(odd) td {\n background: #FEFEFE;\n}\ntr td:hover {\n background: #666;\n color: #FFF;\n}\n\n/* Hover cell effect! */","x":530,"y":140,"wires":[["5f42e8d3.f4cfa8"]]},{"id":"fffca10d.7ddd8","type":"template","z":"af709301.03b","name":"","field":"payload","fieldType":"msg","format":"json","syntax":"mustache","template":"[\n {\"name\": \"Computer 1\", \"ip\": \"6.3.6.6\"},\n {\"name\": \"Computer 2\", \"ip\": \"6.3.6.6\"},\n {\"name\": \"Computer 3\", \"ip\": \"6.7.6.6\"},\n {\"name\": \"Computer 4\", \"ip\": \"6.4.6.6\"}\n]\n ","x":230,"y":140,"wires":[["d081cea9.0e997"]]},{"id":"d081cea9.0e997","type":"json","z":"af709301.03b","name":"","x":390,"y":140,"wires":[["7b12a04c.865b5"]]},{"id":"6d2e2a85.397724","type":"http in","z":"af709301.03b","name":"","url":"/table","method":"get","swaggerDoc":"","x":60,"y":140,"wires":[["fffca10d.7ddd8"]]},{"id":"fd085881.52bc68","type":"ui_template","z":"af709301.03b","group":"1c9e30f9.7d575f","name":"","order":0,"width":"0","height":"0","format":" \n {{msg.style}}\n \n\n \n \n {{ obj.name }} \n {{ obj.ip }} \n \n ","storeOutMessages":false,"fwdInMessages":true,"templateScope":"local","x":680,"y":220,"wires":[[]]},{"id":"8fd7e7d0.112818","type":"template","z":"af709301.03b","name":"","field":"payload","fieldType":"msg","format":"json","syntax":"mustache","template":"[\n {\"name\": \"Computer 1\", \"ip\": {{payload}}},\n {\"name\": \"Computer 2\", \"ip\": \"6.3.6.6\"},\n {\"name\": \"Computer 3\", \"ip\": \"6.7.6.6\"},\n {\"name\": \"Computer 4\", \"ip\": \"6.4.6.6\"}\n]\n ","x":230,"y":220,"wires":[["6e0954ee.59fe0c"]]},{"id":"973abcc1.524b8","type":"inject","z":"af709301.03b","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":80,"y":220,"wires":[["8fd7e7d0.112818"]]},{"id":"6e0954ee.59fe0c","type":"json","z":"af709301.03b","name":"","x":370,"y":220,"wires":[["46f55580.468e4c"]]},{"id":"46f55580.468e4c","type":"template","z":"af709301.03b","name":"css","field":"style","fieldType":"msg","format":"html","syntax":"mustache","template":"table {\n color: #333;\n font-family: Helvetica, Arial, sans-serif;\n width: 100%;\n border-collapse: collapse;\n border-spacing: 0;\n}\ntd, th {\n border: 1px solid transparent;\n /* No more visible border */\n height: 30px;\n transition: all 0.3s;\n /* Simple transition for hover effect */\n}\nth {\n background: #DFDFDF;\n /* Darken header a bit */\n font-weight: bold;\n}\ntd {\n background: #FAFAFA;\n text-align: center;\n}\n\n/* Cells in even rows (2,4,6...) are one color */\n\ntr:nth-child(even) td {\n background: #F1F1F1;\n}\n\n/* Cells in odd rows (1,3,5...) are another (excludes header cells) */\n\ntr:nth-child(odd) td {\n background: #FEFEFE;\n}\ntr td:hover {\n background: #666;\n color: #FFF;\n}\n\n/* Hover cell effect! */","x":530,"y":220,"wires":[["fd085881.52bc68"]]},{"id":"1c9e30f9.7d575f","type":"ui_group","z":"af709301.03b","name":"Test","tab":"2a76ca1b.d92466","disp":true,"width":"6"},{"id":"2a76ca1b.d92466","type":"ui_tab","z":"af709301.03b","name":"Tableau","icon":"dashboard"}]

Can you explain a bit more about what you are actually trying to achieve because your 1 sentence description isn't really making it clear.

This is the third thread in as many days about excel to dashboard. Sure sounds like an assignment to me.

[image] dceejay: Sure sounds like an assignment to me. Yep! I thought the same, hence my reply in post #2...

@TotallyInformation sure. So i have a data from some people for a telegram user control panel so i have the data number, email and stuffs but is to much to write the data one by one to allow the access to the people

@dceejay actually i'm from Mexico and i don't have assigments since 2017 but i would like to know if it is possible because i know some stuffs from Node-red but it was like i could do a template but a table to write data like copy and paste i wasn't sure

[image] lalo: data from some people Data from people (e.g. they type it into a web form) or from a system (e.g. database or CSV file)? [image] lalo: to much to write the data one by one to allow the access to the people Are you wanting to show this data to people? Or are you wanting them to enter the data?

yeah so basically the thing i want to do is just paste numbers on a table on my dashboard on node red like copy and paste just that at least 3x2 table and i will figure out how to expand that

Using copy paste table data via dashboard

Dashboard

Paul-Reed 17 February 2020 20:48 4

Your flow above is not importable.
Please see How to share code or flow json

Topic		Replies	Views
Sending Data from file in node to a dashboard table Dashboard	27	8954	3 April 2021
New Table node for Dashboard v2.0 Dashboard dashboard-2	22	1353	22 April 2024
Table with edit / delete function Dashboard dashboard	14	638	11 September 2024
Examples for node-red-node-ui-table Dashboard	92	48858	3 July 2020
Hello! I'm trying to extract the data from an sql server into a table from my dashboard but i dont get the table filled. My version of node-red is v3.0.2, Windows, and i'm running a Docker Dashboard database	16	492	17 November 2023

Using copy paste table data via dashboard

Related topics