How to insert data in to a excel file?

2 次查看（过去 30 天）
Faranak
Faranak 2014-1-24
回答： Image Analyst 2014-1-24
Hello all, I have a program which gives me 240 data,I want to put this 240 data in a excel file. for every column I have 20 data,I mean 20 data for File a,20 data for File d, 20 for R,20 for Maximum value and 20 for x and 20 for y. afilename is the name of the variable of the File a which is different in every 20 data. and also for dfilename and r and maximum and mim1 and nim1 . All of them are variable for their data which are changing in every time I run the program. Can anyone help me in this?
ex = {'File a','File d','r','Maximum Value','x','y'; afilename ; dfilename ; r ; maximum ; mim1 ; nim1 }; xlswrite('Subtract1', ex, 1, 'A1')

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

采纳的回答

Image Analyst
Image Analyst 2014-1-24
You can use xlswrite() and it will work, but it will take a long time for 20 files, since it has to launch Excel 20 times and shutdown Excel 20 times. Better is to use ActiveX. It's more complicated programming but it's a lot faster since you only have to launch Excel once. I've attached a demo below in blue text.

更多回答（1 个）

Amit
Amit 2014-1-24
编辑：Amit 2014-1-24
row_headers = {'File a','File d','r','Maximum Value','x','y'};
data = [afilename dfilename r maximum mim1 nim1]; % I am assuming they are column vectors
xlswrite('Subtract1.xls',row_headers,'Sheet1','A1');
xlswrite('Subtract1.xls',data,'Sheet1','A2');

类别

在 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