Paste Data to Editable Table in AppDesigner UI

25 views (last 30 days)
Hello everyone,
I have created the app that I need in AppDesigner. Everything works well. However, in my app, user will enter n number of rows of data to the table provided in the app. Then, I will use this table to calculate the output. However, entering the data to table in AppDesigner is pain. Copy and paste (from Excel, notepad etc.) does not work. User should click to cell, right the number and press enter to skip to next cell.
I don't want to use xlsread since it requires creating an Excel with a given definition. So this is not efficient in my case.
What would you recommend to make this process more efficient?

Answers (1)

J. Alex Lee
J. Alex Lee on 25 Jul 2020
when you say you don't want to use xlsread, is it that you don't want to force usage of excel, or you don't want to read files at all?
if you just don't want excel but are ok with reading files, look into readmatrix(), csvread(), or lower level file i/o functions.
  2 Comments
Berk Demir
Berk Demir on 25 Jul 2020
I don't want to use any file. The easiest way for me is to just copy and paste as long as copy is in format of table.
J. Alex Lee
J. Alex Lee on 25 Jul 2020
if this function works for you, maybe it will help (it says requires java, which I thought matlab carries around its own version of, but maybe it depends on environment): https://www.mathworks.com/help/matlab/ref/clipboard.html
But i wouldn't be surprised if it won't work on a web-deployed app or maybe even stand-alone executable app.

Sign in to comment.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!