如何使用表单内的电子表格来制作这种类型的表格?

如何使用表单内的电子表格来制作这种类型的表格?

在此处输入图片描述我想使用表格中的电子表格自动计算列总计,但做不到。请帮忙。

    \documentclass[12pt,a4paper,landscape]{article}
    \usepackage[left=0.75in,right=0.75in,top=0.5in,bottom=0.5in]{geometry}
    \usepackage{array} 
    \usepackage{multirow} 
    \usepackage{marvosym}
    \usepackage{graphicx} 
    \usepackage{xcolor}
    \usepackage[T1]{fontenc}
    \usepackage{lmodern}
    \usepackage{url}
    \usepackage{array}
    \usepackage{hyperref}
    \usepackage{spreadtab}

    \begin{document}
    \begin{form}
    \def\arraystretch{1.5}{
    \begin{spreadtab}{{tabular}{|>{\centering\arraybackslash}p{1.0cm}|p{4.8cm}|p{7.3cm}|>{\centering\arraybackslash}p{2.5cm}|>{\centering\arraybackslash}p{2.5cm}|>{\centering\arraybackslash}p{2.5cm}|>{\centering\arraybackslash}p{2.5cm}|}} \cline{4-7}
    \multicolumn{3}{c|}{} & \multicolumn{2}{|c|}{\textbf{Group \#1}} & \multicolumn{2}{|c|}{\textbf{Group \#2}} \\ \cline{4-7}
    \multicolumn{3}{c|}{} & \textbf{Student 1} & \textbf{Student 2} & \textbf{Student 1} & \textbf{Student 2} \\ \hline  
   \textbf{S.No.} & \multicolumn{1}{c|}{\textbf{Criteria}} & \multicolumn{1}{c|}{\textbf{Sub-Criteria}} & \ChoiceMenu[print,height=0.2cm,width=2.4cm,combo,default=,name=group1name1]{}{17MST1001   , 17MST1002 , 17MST1003 , 17MST1004 , 17MST1005 , 17MST1006 , 17MST1008,    17MST1009,  17MST1010,  17MST1011,  17MST1012,  17MST1013,  17MST1014,  17MST1015,  17MST1017,  17MST1018,  17MST1019,  17MST1020,  17MST1021,  17MST1022,  17MST1023,  17MST1024,  17MST1025,  17MST1026,  17MST1027,  17MST1028,  17MST1029,  17MST1030,  17MST1031,  17MST1032,  17MST1033,  17MST1034,  17MST1035,  17MST1036,  17MST1037,  17MST1038,  17MST1039,  17MST1040,  17MST1041,  17MST1042,  17MST1043,  17MST1044,  17MST1045,  17MST1046,  17MST1047,  17MST1048,  17MST1049,  17MST1050,  17MST1051,  17MST1052,  17MST1053,  17MST1054} & \ChoiceMenu[print,height=0.2cm,width=2.4cm,combo,default=,name=group1name2]{}{17MST1001    , 17MST1002 , 17MST1003 , 17MST1004 , 17MST1005 , 17MST1006 , 17MST1008,    17MST1009,  17MST1010,  17MST1011,  17MST1012,  17MST1013,  17MST1014,  17MST1015,  17MST1017,  17MST1018,  17MST1019,  17MST1020,  17MST1021,  17MST1022,  17MST1023,  17MST1024,  17MST1025,  17MST1026,  17MST1027,  17MST1028,  17MST1029,  17MST1030,  17MST1031,  17MST1032,  17MST1033,  17MST1034,  17MST1035,  17MST1036,  17MST1037,  17MST1038,  17MST1039,  17MST1040,  17MST1041,  17MST1042,  17MST1043,  17MST1044,  17MST1045,  17MST1046,  17MST1047,  17MST1048,  17MST1049,  17MST1050,  17MST1051,  17MST1052,  17MST1053,  17MST1054} & \ChoiceMenu[print,height=0.2cm,width=2.4cm,combo,default=,name=group2name1]{}{17MST1001    , 17MST1002 , 17MST1003 , 17MST1004 , 17MST1005 , 17MST1006 , 17MST1008,    17MST1009,  17MST1010,  17MST1011,  17MST1012,  17MST1013,  17MST1014,  17MST1015,  17MST1017,  17MST1018,  17MST1019,  17MST1020,  17MST1021,  17MST1022,  17MST1023,  17MST1024,  17MST1025,  17MST1026,  17MST1027,  17MST1028,  17MST1029,  17MST1030,  17MST1031,  17MST1032,  17MST1033,  17MST1034,  17MST1035,  17MST1036,  17MST1037,  17MST1038,  17MST1039,  17MST1040,  17MST1041,  17MST1042,  17MST1043,  17MST1044,  17MST1045,  17MST1046,  17MST1047,  17MST1048,  17MST1049,  17MST1050,  17MST1051,  17MST1052,  17MST1053,  17MST1054} & \ChoiceMenu[print,height=0.2cm,width=2.4cm,combo,default=,name=group2name2]{}{17MST1001    , 17MST1002 , 17MST1003 , 17MST1004 , 17MST1005 , 17MST1006 , 17MST1008,    17MST1009,  17MST1010,  17MST1011,  17MST1012,  17MST1013,  17MST1014,  17MST1015,  17MST1017,  17MST1018,  17MST1019,  17MST1020,  17MST1021,  17MST1022,  17MST1023,  17MST1024,  17MST1025,  17MST1026,  17MST1027,  17MST1028,  17MST1029,  17MST1030,  17MST1031,  17MST1032,  17MST1033,  17MST1034,  17MST1035,  17MST1036,  17MST1037,  17MST1038,  17MST1039,  17MST1040,  17MST1041,  17MST1042,  17MST1043,  17MST1044,  17MST1045,  17MST1046,  17MST1047,  17MST1048,  17MST1049,  17MST1050,  17MST1051,  17MST1052,  17MST1053,  17MST1054} \\ \hline  
    1. & \multirow{2}{*}{Presentation (30\%)} & Oral Presentation Skill (15\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box1]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \cline{1-1} \cline{3-7}
    2. &  & Visual Aid used (15\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box2]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \hline 
    3. & \multirow{2}{*}{Work  Accomplished (40\%)} & Quality of Work Done (20\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box3]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \cline{1-1} \cline{3-7}
   4. &  & Completion of Work (20\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box4]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \hline 
   5. & \multicolumn{2}{l|}{Asnwering the Queries (10\%)} & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box5]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \hline 
   6. & \multirow{2}{*}{Documentation (20\%)} & Content of the Report (10\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box6]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \cline{1-1} \cline{3-7}
   7. &  & Report Preparation (Formatting) (10\%) & \ChoiceMenu[print,height=0.2cm,width=1.5cm,combo,default=,name=box7]{}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} & & & \\ \hline 
  & \multicolumn{2}{r|}{\textbf{Grand Total} (Out of 70)} & sum(d4:d10) & & & \\ \hline
    & \multicolumn{2}{r|}{\textbf{Percentage}} & & & & \\ \hline
    \end{spreadtab}}
    \end{form}
    \end{document}

相关内容