Adding data into existing excel sheet from matlab

Question

Rekha 2013-5-3

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74537-adding-data-into-existing-excel-sheet-from-matlab

评论： vickey vardwaj 2021-8-19

I have an excel sheet 'myvalues.xlsx' cosisting of 200 vectors of 127bits each. Now I want to add another vector to my excel sheet which will be placed as the 201th row without changing the existing data. How can I acheive it. Have tried xlswrite but its not working.

2 个评论
显示无隐藏无

syahdan edy murad 2018-7-6

i have the same problem here, could you include your code ? like saving the excel file, and adding it after you execute the file again.

vickey vardwaj 2021-8-19

how can we add a row at 100th row and the old 100th row shifts to 101th row?

请先登录，再进行评论。

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

Answer 1

Mark Whirdy 2013-5-6

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74537-adding-data-into-existing-excel-sheet-from-matlab#answer_84566

编辑：Mark Whirdy 2013-5-6

在 MATLAB Online 中打开

It seems that variable "mydata" is of size [1x3] but the size of the range you elected is [1x1] (i.e. a single excel cell rather than a range of cells) in

xlCurrRange = xlsheet.Range(['A' num2str(newRange)]); 
% ['A' num2str(newRange)] = 'A301' since newRange appears to be the scalar 1 which is added to 300

I think that instead of 'A301' you want to have 'A301:C301' which is

xlsheet.Range(['A', num2str(newRange),':C', num2str(newRange)]);

which should capture the full [1x3] size of "mydata"

Is this it or have I misunderstood?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rekha 2013-5-6

Works perfectly !

This is exactly what is needed. Guess I wasn't clear in my problem statements earlier..

Thank you Mark...

请先登录，再进行评论。

Answer 2

Mark Whirdy 2013-5-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74537-adding-data-into-existing-excel-sheet-from-matlab#answer_84332

编辑：Mark Whirdy 2013-5-3

在 MATLAB Online 中打开

Hi Rekha

Lots of similar questions on the Matlab Answers here if you search.

Here's one of mine on using the activex server to manipulate excel range values from matlab. In general there's no reason to use xlsread or xlswrite

http://www.mathworks.co.uk/matlabcentral/answers/53571-how-write-multiple-data-output-in-excel-sheet-using-xlswrite-command

Use commands like:

mydata = rand(100,3);
xlCurrRange = xlActiveSheet.Range('A201:C300');
xlCurrRange.Value2 = mydata;

google "actxserver" - no shortage of other examples on the web

Alternatively, have a look at Alec de Zegher's approach

http://www.mathworks.co.uk/matlabcentral/fileexchange/38591-xlwrite-generate-xlsx-files-without-excel-on-maclinuxwin

All the best

Mark

4 个评论
显示 2更早的评论隐藏 2更早的评论

Mark Whirdy 2013-5-4

编辑：Mark Whirdy 2013-5-4

在 MATLAB Online 中打开

Hi Rekha

From my understanding of your original question, the crux of the issue is that you want to add write a vector to an excel-sheet beginning at row 201. If the crux of the problem is more the "vector-comparison" algorithm, then I need a lot more detail than the above. But it seems you have a handle on this already.

If the problem is in fact writing to excel (regardless of the content of "sparseVector"), it is easier at my end to ignore the context-specific details and just talk about writing to excel. Could you try the below code [which writes a matrix to Range('A201:C300')] & tell me which part does not work or any part you have a question about?

try
    xlApp = actxGetRunningServer('Excel.Application'); % capture existing excel application
catch ME %#ok
    xlApp = actxserver('Excel.Application'); % instantiate new excel application
end
xlApp.Visible = 1;
xlWorkbook = xlApp.ActiveWorkbook;
xlActiveSheet = xlWorkbook.ActiveSheet;
xlCurrRange = xlActiveSheet.Range('A201:C300'); %
mydata = randn(100,3);
xlCurrRange.Value2 = mydata;

Rekha 2013-5-5

在 MATLAB Online 中打开

Hi Mark,

I tried the code given by you. It works perfectly if am writing the mydata generated into the Range ('A201:C300').

Without considering how i'm arriving at the sparseVector or its contents, speaking only with reference to the above code, the problem am encoutering is:

Upon executing your code once my active excel-sheet(which is myvalues.xlsx in this case) will have matrix in the range 'A201:C300'. Before running the code for the second time I change,

    mydata=randn(100,3);
           to
    mydata=randn(1,3);

I want my excel-sheet to get updated with mydata, generated during the second run written into the 301th row and positioned in the range 'A301:C301'. For the third run mydata must be entered into 302th row ('A302:C302') and so on. I have tried to do so, with small modifications in the code provided by you.

   xlApp = actxserver('Excel.Application');
   xlApp.visible = 1;
   %Open the the spreadsheet
   xlworkbook = xlApp.Workbooks.Open('myvalues.xlsx');
   xlsheet = xlworkbook.ActiveSheet;
   mydata=randn(1,3);
   data=xlsread('myvalues.xlsx');
   %Determine last row
   last=size(data,1);
   newRange=last+1;
   xlCurrRange = xlsheet.Range(['A' num2str(newRange)]);
   xlCurrRange.Value2 = mydata;
   %Save and Close the Excel File
   invoke(xlworkbook,'Save');
   invoke(excelApp,'Quit');
   delete(excelApp);

The problem is only the first element in mydata(i.e.mydata(1,1)) is being written into excel-sheet during each run but not the entire value.

Not able to figure out what's missing.

How can this be corrected.

Adithya Pillai 2020-6-25

Hi Rekha Try using a while loop to update the range after writing each row/column into the excel file

请先登录，再进行评论。

Adding data into existing excel sheet from matlab

2 个评论
显示无隐藏无

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（1 个）

4 个评论
显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Adding data into existing excel sheet from matlab

2 个评论 显示 无隐藏 无

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（1 个）

4 个评论 显示 2更早的评论隐藏 2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

4 个评论
显示 2更早的评论隐藏 2更早的评论