清空筛选条件
清空筛选条件

how to append row in excel sheet

121 次查看（过去 30 天）
akshay dua
akshay dua 2016-4-6
评论： Cris LaPierre 2022-6-10
hi everyone i am trying to use xlswrite to store value of some variable in excel sheet in one program And when i try to update same excel sheet to add another row of data from other program in same excel sheet it is giving error,can anybody suggest me any method ??
  2 个评论
Muhammad Usman Saleem
Muhammad Usman Saleem 2016-4-7
And when i try to update same excel sheet to add another row of data from other program in same excel sheet it is giving error
Not understand these lines?
akshay dua
akshay dua 2016-4-8
hi!! what i mean from above line is i am storing my data of one program in excel sheet using xls command but what i want to know is how can i use same excel file that i created for previous data to store data of second program and keeping data of first program in that same file,,or in other word how can i add another row of data in excel sheet that is already created

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Muhammad Usman Saleem
xlmwrite('YourfileName',value,'append')
  3 个评论
显示 1更早的评论
Muhammad Usman Saleem
Muhammad Usman Saleem 2016-4-7
For storing data into excel file
>> data=rand(5,2) % creating a random matix
%storing this matrix into 3 sheet of excel file
sheet=3;
%Here i am storing data into excel file of NameOfYourFile
xlswrite('NameOfYourFile',data,sheet,'F1')
%F1 is the cell no where this matrix stor in excel
data =
0.3111 0.9797
0.9234 0.4389
0.4302 0.1111
0.1848 0.2581
0.9049 0.4087
I try this in matlob r2013. Excel file which created this code has attached with this answer

请先登录，再进行评论。

Cris LaPierre
Cris LaPierre 2019-1-4
Look at the documentation for xlswrite:
  • xlswrite(filename,A) writes matrix A to the first worksheet in the Microsoft® Excel® spreadsheet workbook filename starting at cell A1.
You can use the xlRange input to somehow specify what row to write the data to. This would require keeping track of what row you last wrote to. Or first reading in the file to determine how many rows have already been written.
  • xlswrite(filename,A,xlRange) writes to the rectangular region specified by xlRange in the first worksheet of the workbook. Use Excel range syntax, such as 'A1:C3'.
An alternative is to use the user-submitted function xlsappend, available on the file exchange.
  2 个评论
Satish
Satish 2022-6-10
I have excel sheet i need to append the data inthe middle of excel sheet. Any one please help me
Cris LaPierre
Cris LaPierre 2022-6-10
By definition, that is not appending.
You will likely need to rewrite all the information from the insertion point to the end of that sheet to get the data organized the way you want.
My approach would likely be to load all the data by the page, then incorprate the data where I want it, then rewrite all the data to the sheet.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by