How to insert a row and shift cells down in excel
16 views (last 30 days)
Show older comments
Hello, I am currently working on a GUI that collects data from the user and delivers as an Excel file which has a pre-defined template. However, some sections of Excel template that the GUI inserts data have limited number of rows (let's say 20). If I want to insert data which need 30 rows, how can I insert it by shifting the following cells down and without disturbing the pre-defined template? I am using MATLAB 2020a and I can manipulate an Excel file via actxserver().
Edit: Can I insert rows with data? In another saying, can I write a ten rowed table on a single row such that the extra rows are inserted automatically? Now, I am pushing following cells downwards and writing data on the inserted cells.
Thanks in advance.
0 Comments
Answers (1)
Jakob B. Nielsen
on 1 Jun 2021
I believe you can achieve this using
Excel.Run('InsertRow');
you might have to have the relevant row selected before it works - I use it just to add new rows from the very top in an excel database, but that works like a charm at least :)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!