提问于:
浏览数:
2278
## 编译环境
操作系统
* [ ] Windows 7/8/10
* [ ] macOS
* [ ] Linux
`若需勾选,请把[ ]改成[x]`
Tex发行版
* [ ] TexLive `年份`
* [ ] MikTeX `版本号`
* [ ] CTeX
`若需勾选,请把[ ]改成[x]`
## 我的问题
在此输入你遇到的问题...
使用excel2latex转表格 放入latex时出错
```
% Table generated by Excel2LaTeX from sheet 'Sheet1'
\begin{table}[htbp]
\centering
\caption{Add caption}
\begin{tabular}{rrrrrrrr}
\toprule
\multicolumn{2}{r}{变量} & \multicolumn{1}{l}{Coef.} & \multicolumn{1}{l}{Std.Err.} & \multicolumn{1}{l}{t} & \multicolumn{1}{l}{P>|t|} & \multicolumn{1}{l}{[95\% Conf.} & \multicolumn{1}{l}{Interval}} \\
\midrule
\multicolumn{2}{r}{real\_cost(实际花费)} & 0.999259 & 0.00121 & 825.86 & 0 & 0.996887 & 1.00613 \\
\multicolumn{2}{r}{ie(库存数量)} & 0.004406 & 0.000848 & 5.2 & 0 & 0.002745 & 0.006067 \\
\multicolumn{2}{r}{tag\_price(标签价)} & -0.07008 & 0.001783 & -39.322 & 0 & -0.07358 & 0.457488 \\
\multicolumn{2}{r}{discount(折扣)} & 0.455103 & 0.001217 & 374.1 & 0 & 0.452719 & 0.457488 \\
\midrule
\multicolumn{2}{r}{\_cons} & 8.20E-15 & 0.00086 & 0 & 1 & -0.00169 & 0.001685 \\
\bottomrule
\end{tabular}%
\label{tab:addlabel}%
\end{table}%
```
表格信息:
![表格信息](https://wenda.latexstudio.net/data/attach/200522/njCWO45Q.png "表格信息")
以下是出错信息
````
Missing \cr inserted. ...\% Conf.} & \multicolumn{1}{l}{Interval}}
Misplaced \cr. ^^I\midrule
Misplaced \noalign. ^^I\midrule
Misplaced \omit. ^^I\multicolumn{2}{r}{real\_cost(实际花费)}
Misplaced \span. ^^I\multicolumn{2}{r}{real\_cost(实际花费)}
Misplaced \omit. ^^I\multicolumn{2}{r}{real\_cost(实际花费)}
Misplaced alignment tab character &. ^^I\multicolumn{2}{r}{real\_cost(实际花费)} &
Misplaced alignment tab character &. ...lumn{2}{r}{real\_cost(实际花费)} & 0.999259 &
Misplaced alignment tab character &. ...{real\_cost(实际花费)} & 0.999259 & 0.00121 &
Misplaced alignment tab character &. ...st(实际花费)} & 0.999259 & 0.00121 & 825.86 &
Misplaced alignment tab character &. ...} & 0.999259 & 0.00121 & 825.86 & 0 &
Misplaced alignment tab character &. ...9 & 0.00121 & 825.86 & 0 & 0.996887 &
Misplaced \cr. ^^I\multicolumn
Misplaced \omit. ^^I\multicolumn{2}{r}{ie(库存数量)}
Misplaced \span. ^^I\multicolumn{2}{r}{ie(库存数量)}
Misplaced \omit. ^^I\multicolumn{2}{r}{ie(库存数量)}
Misplaced alignment tab character &. ^^I\multicolumn{2}{r}{ie(库存数量)} &
Misplaced alignment tab character &. ^^I\multicolumn{2}{r}{ie(库存数量)} & 0.004406 &
Misplaced alignment tab character &. ...n{2}{r}{ie(库存数量)} & 0.004406 & 0.000848 &
Misplaced alignment tab character &. ...ie(库存数量)} & 0.004406 & 0.000848 & 5.2 &
Misplaced alignment tab character &. ...} & 0.004406 & 0.000848 & 5.2 & 0 &
Misplaced alignment tab character &. ...6 & 0.000848 & 5.2 & 0 & 0.002745 &
Misplaced \cr. ^^I\multicolumn
Misplaced \omit. ^^I\multicolumn{2}{r}{tag\_price(标签价)}
Misplaced \span. ^^I\multicolumn{2}{r}{tag\_price(标签价)}
Misplaced \omit. ^^I\multicolumn{2}{r}{tag\_price(标签价)}
Misplaced alignment tab character &. ^^I\multicolumn{2}{r}{tag\_price(标签价)} &
Misplaced alignment tab character &. ...olumn{2}{r}{tag\_price(标签价)} & -0.07008 &
Misplaced alignment tab character &. ...{tag\_price(标签价)} & -0.07008 & 0.001783 &
Misplaced alignment tab character &. ...e(标签价)} & -0.07008 & 0.001783 & -39.322 &
Misplaced alignment tab character &. ...& -0.07008 & 0.001783 & -39.322 & 0 &
Misplaced alignment tab character &. ...& 0.001783 & -39.322 & 0 & -0.07358 &
Misplaced \cr. ^^I\multicolumn
Misplaced \omit. ^^I\multicolumn{2}{r}{discount(折扣)}
Misplaced \span. ^^I\multicolumn{2}{r}{discount(折扣)}
Misplaced \omit. ^^I\multicolumn{2}{r}{discount(折扣)}
Misplaced alignment tab character &. ^^I\multicolumn{2}{r}{discount(折扣)} &
Redefining CJKfamily `\CJKrmdefault' (SimSun(0)).
No file example.aux.
Rerun to get /PageLabels entry.
Font shape `OT1/TimesNewRoman(0)/m/n' undefined(Font) using `OT1/cmr/m/n' instead
Overfull \hbox (3.15614pt too wide) in paragraph
Overfull \hbox (14.34816pt too wide) in paragraph
old toc file detected, not used; run LaTeX again.
Reference `LastPage' on page 1 undefined
Reference `LastPage' on page 2 undefined
Reference `LastPage' on page 3 undefined
Reference `LastPage' on page 4 undefined
Reference `LastPage' on page 5 undefined
Reference `LastPage' on page 6 undefined
Reference `LastPage' on page 7 undefined
Overfull \hbox (23.4789pt too wide) in paragraph
Reference `LastPage' on page 8 undefined
````