use xlswrite to paste the content on a specific cell name
3 views (last 30 days)
Hi, i'm using xlsread and xlswrite to copy some cells from one excel file to another.
my problem is that I have the cells in the destination file that have a specific name, for exemple cell A2 is named "volume".
when I use xlsread or xlswrite I don't know how to specify the cell name instead of the cell number. Do I have to use a particular grammar?
Image Analyst on 7 Dec 2022
No, you can just use "A2" as the range when you use xlswrite or writematrix or writetable. It will write the value that you tell it into that cell. It does not matter the cell is named, or that any range of cells has a name. I believe it will ignore it. If you have an existing workbook where you have named certain cells or ranges of cells, I think writing to the cells will just overwrite the values and not do anything with the existing names you assigned to those cell ranges. But you can easily check that yourself.