Take matrix A=[1, 2, 3, 4;5, 6, 7, 8] as an example for introduction
Case 1:
Enter data into the specified EXCEL, without specifying the workbook or cell location
Enter xlswrite(‘1.xlsx’,A) in the MATLAB main window and press enter and we will see in excel 1.xlsx and sheet1 as follows
Case 1:
Enter data into the specified EXCEL, without specifying the workbook or cell location
Enter xlswrite(‘1.xlsx’,A) in the MATLAB main window and press enter and we will see in excel 1.xlsx and sheet1 as follows
Note: 1 If you put Sheet2 before Sheet1, the data will be written to Sheet2.
2 When this command is executed, the Excel being written should be in the closed state.
Example 2:
Type xlswrite(‘1.xlsx’,A,2) in the main window into the specified sheet without specifying A cell, and press enter
We are putting A matrix in the second sheet. And we need to be careful because we are in sheet3 and not Sheet2.
- example 3 write the data to the specified sheet, specify the location, enter xlswrite(‘1.xlsx’,A,3,’C5′) in the main window of MATLAB, enter
We will see in Sheet2 in the third position that matrix A was written from c5 cell. We could also have written xlswrite(‘1.xlsx’,A,3,’ c5 :F6′). Same result, but the former is simpler and more convenient.
From: http://www.taody.com/zhishi/93f9803fea09f4e0e56f555a.html
Read More:
- Matlab error “Object returned error code of the xlswrite function: 0x800A03EC
- How to use matlab to solve equation
- How to wrap a long string in MATLAB
- How to Solve differential equations with MATLAB
- How to express ln function in MATLAB?
- How to use Latex to Write Matrices
- How to use C + + function pointer array
- How do I change the default background color of all FIGURE objects created in MATLAB
- tf.one_ How to use hot ()
- How to use JavaScript in HTML
- How to Use spatial in MAC
- How to Use Apt get Command Under Mac OSX
- C#: How to Use Httpclient to upload files with other parameters
- React bootstrap loading and how to use modules
- How to use dangerously set inner HTML in react
- How to Use Subfigure in Latex
- How to use torch.sum()
- How to use high version OpenGL under Windows
- Tensorflow: How to use expand_Dim() to add dimensions
- How to Use the Reverse() Function