Hi Jan, I've written a script that I hope will do what you need. Please adjust the variables with your correct Cell Style names, make a selection that includes one or more tables, and run script.
- Mark
Edit: by the way, if you want to apply to ALL tables in the document, change line 23 to "var tables = getTables(doc);"
/*
Set Table Row Styles With Criteria
by m1b
here: https://community.adobe.com/t5/indesign-discussions/tabellen-zellen-suchen-und-formatieren-mit-grep/m-p/12705550
*/
function main() {
// table cell style names:
var headCellStyleName = 'Head',
subheadCellStyleName = 'Subhead',
normalStyleName = "Normal";
var doc = app.activeDocument;
if (doc.selection.length == 0) {
alert('Please make a select one or more tables and run script again.');
return;
}
var tables = getTables(doc.selection);
for (var i = 0; i < tables.length; i++) {
for (var r = 0; r < tables[i].rows.length; r++) {
var row = tables[i].rows[r];
// set style based on criteria:
if (
// HEADING ROW
row.cells.lastItem().contents == ''
) {
setStyle(doc, row, 'cellStyle', headCellStyleName, true);
// merge heading row
row.cells.firstItem().merge(row.cells.lastItem());
} else if (
// SUBHEADING ROW
row.cells.lastItem().contents == '100'
) {
setStyle(doc, row, 'cellStyle', subheadCellStyleName, true);
} else {
// NORMAL ROW
setStyle(doc, row, 'cellStyle', normalStyleName, true);
}
}
}
// convenience function for getting tables
function getTables(items, found) {
if (items == undefined) return [];
if (found == undefined) found = [];
if (!items.hasOwnProperty('0')) items = [items];
for (var i = 0; i < items.length; i++) {
var item = items[i];
if (
// item is a table
item.constructor.name == 'Table'
) {
found.push(item);
} else if (
// item contains tables
item.hasOwnProperty('tables')
&& item.tables.length > 0
) {
found = found.concat(getTables(item.tables));
} else if (
// parent is a table cell
item.hasOwnProperty('parent')
&& item.parent.constructor.name == 'Cell'
) {
found = found.concat(getTables([item.parent.parent]));
} else if (
// is in a story, which may contain tables
item.hasOwnProperty('parentStory')
) {
found = found.concat(getTables([item.parentStory]));
} else if (
// contains page items, which may be tables
item.hasOwnProperty('pageItems')
&& item.pageItems.length > 0
) {
found = found.concat(getTables(item.pageItems));
} else if (
// has a parent which might be a table
item.hasOwnProperty('parent')
&& item.parent.constructor.name != 'Document'
) {
found = found.concat(getTables([item.parent]));
}
}
return found;
}
// convenience function for setting styles
function setStyle(doc, item, styleType, styleName, clearOverrides) {
if (doc == undefined || item == undefined || styleName == undefined) return;
if (clearOverrides == undefined) clearOverrides = true;
switch (styleType.toLowerCase()) {
case 'cellstyle':
if (doc.cellStyles.itemByName(styleName).isValid) {
if (
!item.hasOwnProperty('appliedCellStyle')
&& item.hasOwnProperty('cells')
&& item.cells.length > 0
) {
item = item.cells.everyItem();
}
item.appliedCellStyle = doc.cellStyles.itemByName(styleName);
if (clearOverrides) item.clearCellStyleOverrides(false);
} else {
throw ('Cell Style "' + styleName + '" not found.');
}
break;
case 'paragraphstyle':
if (doc.paragraphStyles.itemByName(styleName).isValid) {
item.texts[0].paragraphs.everyItem().appliedParagraphStyle = doc.paragraphStyles.itemByName(styleName);
if (clearOverrides) item.texts[0].clearOverrides(OverrideType.ALL);
} else {
throw ('Paragraph Style "' + styleName + '" not found.');
}
break;
case 'characterstyle':
if (doc.characterStyles.itemByName(styleName).isValid) {
item.texts[0].paragraphs.everyItem().appliedCharacterStyle = doc.characterStyles.itemByName(styleName);
if (clearOverrides) item.texts[0].clearOverrides(OverrideType.CHARACTER_ONLY);
} else {
throw ('Character Style "' + styleName + '" not found.');
}
break;
default:
throw ('Unrecognised style "' + styleName + '" (' + styleType + ').');
break;
}
}
} // end main
app.doScript(main, ScriptLanguage.JAVASCRIPT, undefined, UndoModes.ENTIRE_SCRIPT, "Set Table Cell Styles");
14
Replies
AdChoices
