This Script is use to convert first row to header, the last row to footer, it delete my content.

[dublove]

This Script is use to convert first row to header, the last row to footer, it delete my content.
Sorry, The original post seemed to be posted by me. But for too long, I didn't find it.
The initial purpose: 

It will judge the last row of the table.

If it is empty, it is directly converted to the footer;if it is not empyt(have content), add 1 row Below the last row, and convert the new row to footer.

It also convert first row to header, apply the  cellstyle.
But now it delete the last row, that it is Non -empty line. my content lost.

table = app.selection[0];
app.selection[0].appliedTableStyle = "mytab";
var myHeaderRow = table.rows[0];
var myNextRow = table.rows[-2];
var myFooterRow = table.rows[-1];

for (var i = 0; i < table.rows.length - 1; i++) {
  table.rows[i].cells.everyItem().minimumHeight = "7.6mm";
};


// Optional:
myFooterRow.cells.everyItem().contents = "";
// Not optional. 
// Set the point size in a value, so that the text could be visible despite the minimal height of the cells:
myFooterRow.cells.everyItem().texts.everyItem().pointSize = 0.1;
myFooterRow.cells.everyItem().appliedCellStyle = "footer";
myHeaderRow.cells.everyItem().appliedCellStyle = "header";
myFooterRow.cells.everyItem().topInset = 0;
myFooterRow.cells.everyItem().leftInset = 0;
myFooterRow.cells.everyItem().bottomInset = 0;
myFooterRow.cells.everyItem().rightInset = 0;

myFooterRow.cells.everyItem().height = "1.06mm";//行高
//myNextRow.cells.everyItem().minimumHeight  = "7.5mm";


if (!(table.rows[0].rowType == RowTypes.HEADER_ROW)) {
  table.rows[0].rowType = RowTypes.HEADER_ROW;
}
else {
  //alert("header existed");
};
if (!(myFooterRow.rows.item(-1).rowType == RowTypes.FOOTER_ROW)) {
  myFooterRow.rows.item(-1).rowType = RowTypes.FOOTER_ROW;
}
else {
  //alert("end of the table exists");
};

[Robert at ID-Tasker]

What kind of translating software are you using? 

Can you post your question in your native language? 

[dublove]

It should be easy to understand now.

[Eugene Tyson]

I'd refer to @Robert at ID-Tasker  as more experienced and better at this than I am

However, I attempted to correct your script, I'm not a professional scripter/coder - I am just learning

Looking forward to how this works - as it seems useful to me too

var table = app.selection[0];
table.appliedTableStyle = "mytab";
var myHeaderRow = table.rows[0];
var myFooterRow = table.rows[-1];

// Convert first row to header and apply cell style
myHeaderRow.cells.everyItem().appliedCellStyle = "header";
if (myHeaderRow.rowType !== RowTypes.HEADER_ROW) {
    myHeaderRow.rowType = RowTypes.HEADER_ROW;
}

// Check if the last row is empty
var isLastRowEmpty = true;
for (var j = 0; j < myFooterRow.cells.length; j++) {
    if (myFooterRow.cells[j].contents !== "") {
        isLastRowEmpty = false;
        break;
    }
}

// If the last row is not empty, add a new row for the footer
if (!isLastRowEmpty) {
    table.rows.add();
    myFooterRow = table.rows[-1];
}

// Convert the last row to footer and apply cell style
myFooterRow.cells.everyItem().contents = "";
myFooterRow.cells.everyItem().texts.everyItem().pointSize = 0.1;
myFooterRow.cells.everyItem().appliedCellStyle = "footer";
myFooterRow.cells.everyItem().topInset = 0;
myFooterRow.cells.everyItem().leftInset = 0;
myFooterRow.cells.everyItem().bottomInset = 0;
myFooterRow.cells.everyItem().rightInset = 0;
myFooterRow.cells.everyItem().height = "1.06mm";

if (myFooterRow.rowType !== RowTypes.FOOTER_ROW) {
    myFooterRow.rowType = RowTypes.FOOTER_ROW;
}

// Set the minimum height for all rows except the last one
for (var i = 0; i < table.rows.length - 1; i++) {
    table.rows[i].cells.everyItem().minimumHeight = "7.6mm";
}

[Robert at ID-Tasker]

The only thing I would optimise is to get rid of all those insets, etc. - this should be set in the CellStyle - that is applied anyway. 

[dublove]

Success.

Thank you very much~

Do I have to choose the entire table? Just need the cursor in the table, okay?

[Robert at ID-Tasker]

Do I have to choose the entire table? Just need the cursor in the table, okay?

By @dublove

You need to select whole table. 

[dublove]

Hi~

@Eugene Tyson 

Can you add a "Continue" row in front of the header?
At the same time, apply "Continue" cellstyle  to it, and set  5mm  accurate line height  for it.

But how do you judge that "Continue" already exists? Need two versions?

Thank you~

[Eugene Tyson]

You should be able to do that automatically

https://www.youtube.com/watch?v=sKpo1jM7Jvk

[dublove]

I can't log in to YouTube.
I know the way to make Continue, but first of all, you have to create a new Continue Row.
I just ask how to quickly insert the  Continue Row in front of the header， and set up accurate high, apply it's cellstyle.

[Robert at ID-Tasker]

I can't log in to YouTube.
I know the way to make Continue, but first of all, you have to create a new Continue Row.
I just ask how to quickly insert the  Continue Row in front of the header， and set up accurate high, apply it's cellstyle.

By @dublove

You mean you want Header to automatically "duplicate" - be visible - in all following TextFrames?

https://www.indesignjs.de/extendscriptAPI/indesign-latest/#Table.html

Two properties:

And a bit more info:

https://www.indesignjs.de/extendscriptAPI/indesign-latest/#HeaderFooterBreakTypes.html

[dublove]

HI @Eugene Tyson 

// Check if the last row is empty
var isLastRowEmpty = true;
for (var j = 0; j < myFooterRow.cells.length; j++) {
    if (myFooterRow.cells[j].contents !== "") {
        isLastRowEmpty = false;
        break;
    }
}

// If the last row is not empty, add a new row for the footer
if (!isLastRowEmpty) {
    table.rows.add();
    myFooterRow = table.rows[-1];
}

After my repeated testing, I think there is something wrong with this code of yours.
It doesn't recognize the two states when the text box is fully expanded, or contains overflow text.

In both states, it doesn't recognize if there is a empty row at the end.
It gets confused. Look at the latest test sample

https://community.adobe.com/t5/indesign-discussions/dead-loop-how-do-i-jump-out-and-why-do-i-get-two...

[Robert at ID-Tasker]

@dublove

Should be: 

    if (myFooterRow.cells[j].texts[0].contents !== "") { 

[Robert at ID-Tasker]

@dublove

Also, are you looking to set "false" footer rows - or "real" ones, like when you define their number in the Table Properties in the UI?

[Eugene Tyson]

It works exactly as you described orginally, I tested it and it does what you asked for.

However, the issue here is that it’s not entirely clear what you're asking for, which makes it difficult to pinpoint the goals. This has led to some confusion, and it’s why I haven't responded sooner. There’s been quite a bit of back-and-forth, and I’m finding it challenging to fully understand what you're looking for.