Excel writing Problem: find correct row, write to empty cell

3 次查看（过去 30 天）
B_Richardson
B_Richardson 2011-8-2
Hello Community,
I have a fairly advanced excel writing task. I have 2 types filenames that I need to write to specific cells in a spreadsheet. I acquire these names from user selection in a GUI. The files are named in this fashion: Label_SLR_LL_S1_0006_v1
Segment_SCH_RL_S3_0008_v1
So the files with "Label" are written to the Label and column and so forth.
First problem is I need to write to the next empty row instead of overwriting existing data. Ideally, I would like to check to see if the data already exist in the column, if it does, overwrite, if not find empty cell and write.
The second problem is the sheet contains data that is organized by row in this fashion:
2009-10-06 09-26-15_SHC_RL_S1_0002FinalData.mat
2009-10-06 09-28-01_SHC_RL_S2_0002FinalData.mat
2009-10-06 09-37-31_SHC_LL_S1_0002FinalData.mat
2009-10-06 09-39-18_SHC_LL_S2_0002FinalData.mat
2009-10-06 09-48-43_RHA_RL_S2_0002FinalData.mat
2009-10-06 09-50-06_RHA_RL_S3_0002FinalData.mat
2009-10-06 10-09-46_SLR_RL_S1_0002FinalData.mat
So the keywords are
SLR_LL_S1
SHC_LL_S2
RHA_RL_S3
and so forth Each row in the the sheet contains data specific to that identifer. I need to be able to write my filenames:
Label_SLR_LL_S1_0006_v1
Segment_SCH_RL_S3_0008_v1
into the correct row based on the keywords.
The second part of my problem might not be necessary if a simple sort in excel can put my filenames in the correct order? I dont think it can because of how they are named.
I realize this a hefty question and any suggestion are greatly appreciated. I litteraly spent over 3 hours searching the Answers and newsgroup but couldt find a solution to this problem.
  5 个评论
显示 3更早的评论
Fangjun Jiang
Fangjun Jiang 2011-8-3
So, to summarize, you have nx3 strings in an Excel file, you want to insert new strings into the right cell. The right cell means that the strings with the same keywords are grouped together. I assume you want to insert at least 3 strings at a time, with one for each of the "Header", "Label" and "Segment" column. These 3 strings shall have the same keywords.
B_Richardson
B_Richardson 2011-8-3
The insertion will occur one at a time in 2 pushbutton callbacks, 1 for Labels and the other for Segment. The data in the column "Header" is always there and doesnt change. I only wont to insert data into the "Segment" and "Label" columns.

请先登录，再进行评论。

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-8-3
There are still things you didn't clarify. The data in the column "Header", are there multiple lines of file name that contain the same key? If not,, the following code should be good enough.
NewFileName='Label_SLR_LL_S1_0006_v1';
if strfind(NewFileName,'Label_')
Column=2;
Key=NewFileName(7:16);
elseif strfind(NewFileName,'Segment_');
Column=3;
Key=NewFileName(9:18);
else
error('Wrong File Name.');
end
ExcelFile='MyData.xls';
[Dummy,Dummy,Raw]=xlsread(ExcelFile);
Index=strfind(Raw(:,1),Key);
Index=find(~cellfun('isempty',Index));
Raw{Index,Column}=NewFileName;
xslwrite(ExcelFile,Raw);
  9 个评论
显示 7更早的评论
Fangjun Jiang
Fangjun Jiang 2011-8-3
If the data in your first column could have duplicated key word, how do you decide which row to put if the new file name has that key word? This is a very important question you have to be clear at the beginning.
B_Richardson
B_Richardson 2011-8-3
"You can put a break point in the code and run the code line by line. At any time, you can observe the value of any variable to see the effect of the code and also help you to understand the code. I thought you've been here long enough to know this."
No, I had no idea. That sounds very convenient.
"If the data in your first column could have duplicated key word, how do you decide which row to put if the new file name has that key word? This is a very important question you have to be clear at the beginning."
Thats a good question. I thought it would be possible to find the correct row # by matching with column 7 since the data in that column never repeats. After making that match, because we already know the column #, we could write to the correct cell? Thats what I had in mind but I'm not sure if its possible with my limited skills at this point.
As I said before, excel might be able to properly sort the data in the column, so finding the exact correct row might not be necessary. As long as its writing to the next empty cell

请先登录，再进行评论。

更多回答（1 个）

Fangjun Jiang
Fangjun Jiang 2011-8-3
Watch this video: http://blogs.mathworks.com/videos/2010/09/02/using-debugger-to-walk-through-code/
You can't expect an exact code to solve your problem with so much details.
  7 个评论
显示 5更早的评论
B_Richardson
B_Richardson 2011-8-4
I see. I'm trying to practice using the debugger. It doesnt seem to let me create breakpoints anywhere I want. Is there another tutorial somewhere?
Fangjun Jiang
Fangjun Jiang 2011-8-4
Doug Hull provided lots of tutorial video over there, you can watch them whenever you like. Not every line can be put in a break point. You don't need to actually. Have a few break point and then you can press F10 to run line by line.

请先登录，再进行评论。

类别

在 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