xlswrite an empty string

19 次查看（过去 30 天）
Jim
Jim 2012-8-10
I have a list of words in an excel file. I want to delete on item from the list and then move up the words below so there are no blanks, empty cells. I read the file with xlsread. Then I get the shorten list. Finally, I write that array into the same file. The problem is the last item of the original array is still there. For example if the list of words is 'word1 word2 word3' and I delete 'word2' producing 'word1 word3' When I wire this the file contains 'word1 word3 word3' I do not want the second 'word3' there. I've tried putting '' in the last row but that appears as NaN in the excel file.

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

采纳的回答

Oleg Komarov
Oleg Komarov 2012-8-10
You can control the excel file directly without importing it through ActiveX:
% Open the excel file (it remains invisible however)
excel = actxserver ('Excel.Application');
% excel.Visible = 1;
workbook = excel.Workbooks.Open('C:\Users\ok1011\Desktop\test.xlsx');
% Activate the sheet you need (optional if the sheet is the first)
workbook.Worksheets.Item(1).Activate;
% Delete A2, shifts upwards
workbook.ActiveSheet.Range('A2').Delete
% Now save/close/quit/delete
% excel.Visible = 0;
workbook.Save;
excel.Workbook.Close;
invoke(excel, 'Quit');
delete(excel)
  3 个评论
显示 1更早的评论
Oleg Komarov
Oleg Komarov 2012-8-10
workbook.ActiveSheet.Range(sprintf('A%d',wordelete(1,1))).Delete
Jim
Jim 2012-8-11
thanks again

请先登录，再进行评论。

更多回答（0 个）

类别

在 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