先生成该表格：

# In[1]
import pandas as pd
import os

df = pd.read_excel(‘list.xlsx‘)

ids = df[‘Pap ID‘].to_list()
lens = df[‘Page Length‘].to_list()
titles = df[‘Pap Title ‘].to_list()
cor_authors = df[‘Corresponding Author‘].to_list()
authors = df[‘Authors‘].to_list()
emails = df[‘Corresponding Author Email‘].to_list()
affs = df[‘Affiliation‘].to_list()
affs

# In[1]
f = open(‘latex_mode.txt‘, ‘w+‘, encoding=‘utf-8‘)
Name = ‘LNAI‘
page = 12430
cor_mod = ‘{0}\\thanks{{\\mbox{{Corresponding author}}}}‘
latex_mod = """\setcounter{{page}}{{{0}}}
\\title{{{1}}}
\\author{{{2}}}
\\tocauthor{{{3}}}
{4}
\\institute{{{5}\\\	\\email{{{6}}}}}
\\maketitle
\\clearpage
"""
latex_mod

# In[3]
import re 
all_latexs = ""
cur_length = 1
for id, length, title, author, cor_author, aff, email in zip(ids, lens, titles, authors, cor_authors, affs, emails):
    id_name = ‘{0:05d}‘.format(cur_length)
    cur_page = int(id_name)
    # print(‘cur_page: ‘, cur_page, cur_page % 800, cur_page % 801)
    if cur_page % 800 == 0 or cur_page % 801 == 0 % cur_page % 802 == 0:
        page += 1
    cur_name = Name + str(page) + id_name
    print(cur_name)
    # os.rename(str(id), cur_name)
    print(‘==============latex================‘)
    print(title, author,  cor_author, aff, email)
    #### title ####
    ###############
    #### author ####
    author_li = re.split(‘,|and‘, author)
    new_author = []
    for li in author_li:
        li = li.strip()
        if li == cor_author:
            li = cor_mod.format(li)
        new_author.append(li)
    new_author = ‘ \\and ‘.join(new_author)
    # print(new_author)
    ################
    #### tocauthor ####
    tocauthor = author
    ####################
    ###### index #######
    indexs = ""
    for li in author_li:
        li = li.strip().split(‘ ‘)
        if len(li) == 2:
            idx = "\index{{{0}, {1}}}".format(li[1], li[0])
            indexs += idx + ‘\n‘
    ####################
    ###### aff #######
    first_aff = aff.split(‘\n‘)[0]
    ###################
    ###### email ######
    ###################
    print(cur_length)
    cur_latex = latex_mod.format(cur_length, title, 
                                new_author, tocauthor, 
                                indexs[:-1], first_aff, email)
    print(cur_latex)

    # 更新 页码
    cur_length += length
    all_latexs = all_latexs + cur_latex + ‘\n‘

print(all_latexs)
# %%
f.write(all_latexs)
f.close()

将生成代码复制到LaTeX封面模板中，生成如：

NLPCC论文LaTeX封面生成代码